📄 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 + -