?? tushutianjia.java
字號:
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
public class TushuTianjia extends JFrame implements ActionListener{
public final static int TO_INSEART=1,TO_UPDATE=2;
int insql;
ShuJuKu db=new ShuJuKu();
ShuJuKu db1=new ShuJuKu();
ShuJuKu db2=new ShuJuKu();
ShuJuKu db3=new ShuJuKu();
ShuJuKu db4=new ShuJuKu();
ResultSet rs,rs1;
public JTextField fields[];
JLabel labels[];
public JTextArea textArea;
JButton b1,b2,b3,b4;
String labelsName[]={"圖書編號","書名","圖書作者","出版社","字數","責任編輯","主題分類","借閱分類","總冊數","庫存量","借書證號","當前日期"};
public TushuTianjia(int inseartOrUpdate){
super("圖書管理");
insql=inseartOrUpdate;
labels=new JLabel[12];
fields=new JTextField[12];
JPanel p1=new JPanel();
JPanel p2=new JPanel();
JPanel p3=new JPanel();
JPanel p4=new JPanel();
JPanel p5=new JPanel();
p1.setLayout(new GridLayout(12,1,0,15));
p2.setLayout(new GridLayout(12,1,0,10));
for(int i=0;i<12;i++){
labels[i]=new JLabel(labelsName[i]+":");
fields[i]=new JTextField(15);
p1.add(labels[i]);
p2.add(fields[i]);
}
p3.setBorder(BorderFactory.createTitledBorder("圖書簡介"));
labels[10] = new JLabel("借書人學號");
textArea=new JTextArea(5,15);
JScrollPane t=new JScrollPane(textArea);
b1=new JButton("確定按鈕");
b1.addActionListener(this);
b2=new JButton("取消按鈕");
b2.addActionListener(this);
b3=new JButton("借書按鈕");
b3.addActionListener(this);
p3.add(t);
p4.add(p1);
p4.add(p2);
p4.add(p3);
p5.add(b1);
p5.add(b2);
p5.add(b3);
Container c=getContentPane();
c.add(p4,BorderLayout.CENTER);
c.add(p5,BorderLayout.SOUTH);
fields[9].setEnabled(false);
if(insql==2){
b3.setVisible(true);
fields[0].setEnabled(false);
fields[10].setEnabled(true);
fields[11].setEnabled(true);}
else{
b3.setVisible(false);
fields[0].setEnabled(true);
fields[10].setEnabled(false);
fields[11].setEnabled(false);
}
}
public void actionPerformed(ActionEvent e) {
if(e.getSource()==b2)
{
db.closeConnection();
this.dispose();
}
//------借書功能------
else if(e.getSource()==b3){
if(fields[10].getText().trim().equals("")) {
JOptionPane.showMessageDialog(null,"借書證號不能為空！");
}
else if(fields[11].getText().trim().equals(""))
{
JOptionPane.showMessageDialog(null,"請輸入當前日期");
}
String leibie="",shumu="",kucun="";
String strSQL;
//------------------
//------------------
strSQL="Select duzheleibie,jieyueshumu From duzhexinxi where duzhehao like '"+fields[10].getText()+"%'";
rs=db.getResult(strSQL);
try{
if(rs.next())
{leibie = rs.getString("duzheleibie");
shumu = rs.getString("jieyueshumu");}
//kucun = rs.getString("kucunliang");
db.closeConnection();
}
catch(SQLException sqle){
System.out.println(sqle.toString());
}
catch(Exception ex){
System.out.println(ex.toString());
}
//-------
strSQL="Select kucunliang From tushuxinxi where tushuhao like '"+fields[0].getText()+"%'";
rs1=db1.getResult(strSQL);
try{
if(rs1.next())
{
kucun = rs1.getString("kucunliang");
}
db1.closeConnection();
}
catch(SQLException sqle){
System.out.println(sqle.toString());
}
catch(Exception ex){
System.out.println(ex.toString());
}
if(((leibie.equals("老師"))&&(shumu.equals("5")))||((leibie.equals("學生"))&&(shumu.equals("3"))))
{
JOptionPane.showMessageDialog(null,"對不起 您的書已經借滿");
this.dispose();
}
else if(kucun.equals("0")){
JOptionPane.showMessageDialog(null,"對不起 庫存已經為零");
this.dispose();
}
else
{
int a,b=1;
a=Integer.parseInt( shumu );
a= a+1;
shumu=String.valueOf(a);
JOptionPane.showMessageDialog(null,shumu);
a=Integer.parseInt(kucun);
a=a-1;
kucun= String.valueOf(a);
String riqi=(String)fields[11].getText();
//JOptionPane.showMessageDialog(null,kucun);
try{
strSQL="update tushuxinxi set kucunliang='"+kucun+"' "+"where tushuhao='"+fields[0].getText().trim()+"'";
if(db2.updateSql(strSQL))
{
//JOptionPane.showMessageDialog(null,"上傳庫存量信息 成功！");
//this.dispose();
b=b+1;
}
else
{
JOptionPane.showMessageDialog(null,"上傳庫存量 失敗！");
this.dispose();
}
db2.closeConnection();
}
catch(Exception ex){
System.out.println(ex.toString());
}
try{
strSQL="update duzhexinxi set jieyueshumu='"+shumu+"' "+"where duzhehao='"+fields[10].getText().trim()+"'";
if(db3.updateSql(strSQL))
{
//JOptionPane.showMessageDialog(null,"上傳借閱數目 成功！");
//this.dispose();
b=b+1;
}
else
{
JOptionPane.showMessageDialog(null,"上傳借閱數目信息 失敗！");
this.dispose();
}
db3.closeConnection();
}
catch(Exception ex){
System.out.println(ex.toString());
}
try{
strSQL="insert into tushubiao(tushuhao,duzhehao,jiehuanriqi,xingwei,daihuan) values('"+
fields[0].getText().trim()+"','"+
fields[10].getText().trim()+"','"+
fields[11].getText().trim()+"','"+
"借"+"','"+"待還"+"')";
if(db4.updateSql(strSQL))
{
//JOptionPane.showMessageDialog(null,"修改歷史信息 成功！");
//this.dispose();
b=b+1;
}
else
{
JOptionPane.showMessageDialog(null,"修改歷史信息 失敗！");
this.dispose();
}
db4.closeConnection();
}
catch(Exception ex){
System.out.println(ex.toString());
}
if(b==4){
JOptionPane.showMessageDialog(null,"借書成功");
}
}
}
//========定義借書結束======
//--------還書功能=========
/* else if(e.getSource()==b4){
if(fields[10].getText().trim().equals("")) {
JOptionPane.showMessageDialog(null,"借書證號不能為空！");
}
else if(fields[11].getText().trim().equals(""))
{
JOptionPane.showMessageDialog(null,"請輸入當前日期");
}
else{
HuanshuBiao hsb=new HuanshuBiao();
Dimension FrameSize=hsb.getPreferredSize();
Dimension MainFrameSize=getSize();
Point loc=getLocation();
hsb.setLocation((MainFrameSize.width-FrameSize.width)/2+loc.x,
(MainFrameSize.height-FrameSize.height)/2+loc.y);
hsb.dzh=fields[11].getText().trim();
hsb.dqrq=fields[12].getText().trim();
hsb.pack();
hsb.show();
}
}*/
//==========還書定義完畢--------
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(fields[4].getText().trim().equals(""))
{
JOptionPane.showMessageDialog(null,"字數不能為空！");
}
else if(fields[5].getText().trim().equals(""))
{
JOptionPane.showMessageDialog(null,"責任編輯不能為空！");
}
else if(fields[6].getText().trim().equals(""))
{
JOptionPane.showMessageDialog(null,"主題分類不能為空！");
}
else if(fields[7].getText().trim().equals(""))
{
JOptionPane.showMessageDialog(null,"借閱分類不能為空！");
}
else if(fields[8].getText().trim().equals(""))
{
JOptionPane.showMessageDialog(null,"總冊數不能為空！");
}
else
{
//--設置窗口功能--
if(insql==1){
try
{
String strSQL="insert into tushuxinxi(tushuhao,tushuming,zuozhe,chubansheming,zishu,zerenbianji,zhutifenlei,jieyuefenlei,zongceshu,kucunliang,tushujianjie) values('"+
fields[0].getText().trim()+"','"+
fields[1].getText().trim()+"','"+
fields[2].getText().trim()+"','"+
fields[3].getText().trim()+"','"+
fields[4].getText().trim()+"','"+
fields[5].getText().trim()+"','"+
fields[6].getText().trim()+"','"+
fields[7].getText().trim()+"','"+
fields[8].getText().trim()+"','"+
fields[8].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 tushuxinxi set tushuming='"+fields[1].getText().trim()+"',"+"zuozhe='"+fields[2].getText().trim()+"',"+"chubansheming='"+fields[3].getText().trim()+"',"+"zishu='"+fields[4].getText().trim()+"',"+"zerenbianji='"+fields[5].getText().trim()+"',"+"zhutifenlei='"+fields[6].getText().trim()+"',"+"jieyuefenlei='"+fields[7].getText().trim()+"',"+"zongceshu='"+fields[8].getText().trim()+"',"+"kucunliang='"+fields[9].getText().trim()+"',"+"tushujianjie='"+textArea.getText().trim()+"'where tushuhao='"+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 + -