?? chubanshetianjia.java
字號:
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
public class ChuBanSheTianjia extends JFrame implements ActionListener{
public final static int TO_INSEART=1,TO_UPDATE=2;
int insql;
ShuJuKu db=new ShuJuKu();
ResultSet rs;
public JTextField fields[];
JLabel labels[];
public JTextArea textArea;
JButton b1,b2;
String labelsName[]={"出版社名字","出版社地址","出版社網站","出版社郵箱"};
public ChuBanSheTianjia(int inseartOrUpdate){
super("出版社管理");
insql=inseartOrUpdate;
labels=new JLabel[4];
fields=new JTextField[4];
JPanel p1=new JPanel();
JPanel p2=new JPanel();
JPanel p3=new JPanel();
JPanel p4=new JPanel();
JPanel p5=new JPanel();
p1.setLayout(new GridLayout(4,1,0,10));
p2.setLayout(new GridLayout(4,1,0,10));
for(int i=0;i<4;i++){
labels[i]=new JLabel(labelsName[i]+":");
fields[i]=new JTextField(15);
p1.add(labels[i]);
p2.add(fields[i]);
}
p3.setBorder(BorderFactory.createTitledBorder("出版社簡介"));
textArea=new JTextArea(5,15);
JScrollPane t=new JScrollPane(textArea);
b1=new JButton("確定按鈕");
b1.addActionListener(this);
b2=new JButton("取消按鈕");
b2.addActionListener(this);
p3.add(t);
p4.add(p1);
p4.add(p2);
p4.add(p3);
p5.add(b1);
p5.add(b2);
Container c=getContentPane();
c.add(p4,BorderLayout.CENTER);
c.add(p5,BorderLayout.SOUTH);
if(insql==1){
fields[0].setEnabled(true);}
else{
fields[0].setEnabled(false);
}
}
public void actionPerformed(ActionEvent e) {
if(e.getSource()==b2)
{
db.closeConnection();
this.dispose();
}
else if(e.getSource()==b1){
if(fields[0].getText().trim().equals(""))
{
JOptionPane.showMessageDialog(null,"出版社名不能為空");
}
else if(fields[1].getText().trim().equals(""))
{
JOptionPane.showMessageDialog(null,"出版社地址不能為空");
}
else if(fields[2].getText().trim().equals(""))
{
JOptionPane.showMessageDialog(null,"出版社網站不能為空");
}
else if(fields[3].getText().trim().equals(""))
{
JOptionPane.showMessageDialog(null,"出版社地址不為空");
}
else
{
//--設置窗口功能--
if(insql==1){
try
{
String strSQL="insert into chubanshe(chubansheming,dizhi,chubanshewang,chubansheyou,chubanshebeizhu) values('"+
fields[0].getText().trim()+"','"+
fields[1].getText().trim()+"','"+
fields[2].getText().trim()+"','"+
fields[3].getText().trim()+"','"+
textArea.getText().trim()+"')";
if(db.updateSql(strSQL))
{
JOptionPane.showMessageDialog(null,"添加信息成功!");
//this.dispose();
}
else
{
JOptionPane.showMessageDialog(null,"添加信息失敗請認真填寫各項信息!");
this.dispose();
}
db.closeConnection();
}
catch(Exception ex)
{
System.out.println(ex.toString());
}
}
//--修改口功能--
else{
try
{
String strSQL="update chubanshe set dizhi='"+fields[1].getText().trim()+"',"+"chubanshewang='"+fields[2].getText().trim()+"',"+"chubansheyou='"+fields[3].getText().trim()+"',"+"chubanshebeizhu='"+textArea.getText().trim()+"'where chubansheming='"+fields[0].getText().trim()+"'";
if(db.updateSql(strSQL))
{
JOptionPane.showMessageDialog(null,"修改信息成功!");
this.dispose();
}
else
{
JOptionPane.showMessageDialog(null,"修改信息失敗!");
this.dispose();
}
db.closeConnection();
}
catch(Exception ex)
{
System.out.println(ex.toString());
}
}
}
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -