📄 library.java
字号:
catch(SQLException ee){
System.out.println("SQLException:"+ee.getMessage());}
}
else if(e.getSource()==CancelBtn)
{
dispose();
}
else if(e.getSource()==UpdateBtn)
{
if(NewNameField.getText().trim().equals(""))
{
JOptionPane.showMessageDialog(null,"姓名不能为空！");
}
else if(NewSexField.getText().trim().equals(""))
{
JOptionPane.showMessageDialog(null,"性别不能为空！");
}
else if(NewClassnoField.getText().trim().equals(""))
{
JOptionPane.showMessageDialog(null,"班级号码不能为空");
}
else
{
try{Updatestudent();}
catch(SQLException ee){
System.out.println("SQLException:"+ee.getMessage());}
}
}
}
public void Showall()throws SQLException
{
String Sno,Sname,Ssex,Scno;
int i=0;
try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch(ClassNotFoundException e){
System.out.println("ForName:"+e.getMessage());}
String conURL="jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};"+"DBQ=library.mdb";
Connection ExlCon=DriverManager.getConnection(conURL);
Statement Exlstmt=ExlCon.createStatement();
ResultSet rs=Exlstmt.executeQuery("SELECT * FROM student");
while (rs.next())
{
Sno=rs.getString("student_no");
Sname=rs.getString("name");
Ssex=rs.getString("sex");
Scno=rs.getString("class_no");
if(Sno.equals(StudentnoField.getText().trim()))
{
NameField.setText(Sname);
SexField.setText(Ssex);
ClassnoField.setText(Scno);
i=1;
break;
}
}
ExlCon.close();
if (i==0)
{
JOptionPane.showMessageDialog(null,"不存在该学号对应的学生档案!");
}}
public void Updatestudent()throws SQLException
{try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch(ClassNotFoundException e){
System.out.println("ForName:"+e.getMessage());}
String conURL="jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};"+"DBQ=library.mdb";
Connection ExlCon=DriverManager.getConnection(conURL);
Statement Exlstmt=ExlCon.createStatement();
String s1="'"+NewNameField.getText().trim()+"'",
s2="'"+NewSexField.getText().trim()+"'",
s3="'"+NewClassnoField.getText().trim()+"'",
s4="'"+StudentnoField.getText().trim()+"'";
String s6="UPDATE student SET name="+s1+",sex="+s2+",class_no="+s3+"WHERE student_no ="+s4;
Exlstmt.executeUpdate(s6);
ExlCon.close();
JOptionPane.showMessageDialog(null,"更新成功,请校验");
}
}
//图书馆图书列表
class Booklist extends JFrame implements ActionListener
{
String url="jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};"
+"DBQ=library.mdb";
JTextArea t1;
JButton flush;
Booklist()
{
super("图书馆藏书列表");
flush=new JButton("刷新");
t1=new JTextArea(16,50);
add(t1,BorderLayout.CENTER);
add(flush,BorderLayout.SOUTH);
flush.addActionListener(this);
setSize(800,600);
show();
try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch(ClassNotFoundException e){
System.out.println("ForName:"+e.getMessage());}
try
{
Connection con=DriverManager.getConnection(url);
Statement s=con.createStatement();
ResultSet rs1=s.executeQuery("select * from book");
String k;
t1.setEnabled(true);
t1.setText("书籍编号"+"\t"+"书名"+"\t\t"+"出版社"+"\t"+"作者"+"\t"+"价格"+"\t"+"状态"+"\n");
boolean boo=false;
while((boo=rs1.next())==true)
{
t1.append (rs1.getString("book_no")+"\t"+rs1.getString("bookname")+"\t\t"+rs1.getString("press")+"\t"+rs1.getString("author")+"\t"
+rs1.getString("price")+"\t"+rs1.getString("status")+"\n");
}
con.close();
}
catch(SQLException ee)
{System.out.println("SQLException :" + ee.getMessage( ));}
}
public void actionPerformed(ActionEvent ee)
{
if(ee.getSource()==flush)
{
try
{
Connection con=DriverManager.getConnection(url);
Statement s=con.createStatement();
ResultSet rs1=s.executeQuery("select * from book");
String k;
t1.setEnabled(true);
t1.setText("书籍编号"+"\t"+"书名"+"\t\t"+"出版社"+"\t"+"作者"+"\t"+"价格"+"\t"+"状态"+"\n");
boolean boo=false;
while((boo=rs1.next())==true)
{
t1.append (rs1.getString("book_no")+"\t"+rs1.getString("bookname")+"\t\t"+rs1.getString("press")+"\t"+rs1.getString("author")+"\t"
+rs1.getString("price")+"\t"+rs1.getString("status")+"\n");
}
con.close();
}
catch(SQLException ee1)
{System.out.println("SQLException :" + ee1.getMessage( ));}
}
}
}
//添加书籍
class Bookadd extends JFrame implements ActionListener
{
Container c;
JPanel panel1,panel2;
JLabel BooknoLabel,BooknameLabel,PressLabel,AuthorLabel,PriceLabel;
JTextField BooknoField,BooknameField,PressField,AuthorField,PriceField;
JButton AddBtn,CancelBtn;
Bookadd ()
{
super("添加用户");
c=getContentPane();
c.setLayout(new BorderLayout());
BooknoLabel=new JLabel("书号",JLabel.CENTER);
BooknameLabel=new JLabel("书名",JLabel.CENTER);
PressLabel=new JLabel("出版社",JLabel.CENTER);
AuthorLabel=new JLabel("作者",JLabel.CENTER);
PriceLabel=new JLabel("价格",JLabel.CENTER);
BooknoField=new JTextField(10);
BooknameField=new JTextField(10);
PressField=new JTextField(10);
AuthorField=new JTextField(10);
PriceField=new JTextField(10);
AddBtn=new JButton("添加");
CancelBtn=new JButton("取消");
AddBtn.addActionListener(this);
CancelBtn.addActionListener(this);
panel1=new JPanel();
panel1.setLayout(new GridLayout(5,2));
panel1.add(BooknoLabel);
panel1.add(BooknoField);
panel1.add(BooknameLabel);
panel1.add(BooknameField);
panel1.add(PressLabel);
panel1.add(PressField);
panel1.add(AuthorLabel);
panel1.add(AuthorField);
panel1.add(PriceLabel);
panel1.add(PriceField);
c.add(panel1,BorderLayout.CENTER);
panel2=new JPanel();
panel2.add(AddBtn);
panel2.add(CancelBtn);
c.add(panel2,BorderLayout.SOUTH);
setSize(370,180);
show();
}
public void actionPerformed(ActionEvent e)
{
if(e.getSource() == AddBtn)
{if(BooknoField.getText().trim().equals(""))
{
JOptionPane.showMessageDialog(null,"书号不能为空！");
}
else if(BooknameField.getText().trim().equals(""))
{
JOptionPane.showMessageDialog(null,"书名不能为空！");
}
else if(PressField.getText().trim().equals(""))
{
JOptionPane.showMessageDialog(null,"出版社不能为空！");
}
else if(AuthorField.getText().trim().equals(""))
{
JOptionPane.showMessageDialog(null,"作者不能为空！");
}
else if(PriceField.getText().trim().equals(""))
{
JOptionPane.showMessageDialog(null,"价格不能为空！");
}
else
{
try{Addbook();}
catch(SQLException ee){
System.out.println("SQLException:"+ee.getMessage());}
}
}
if(e.getSource() == CancelBtn)
{dispose();
}
}
public void Addbook()throws SQLException
{
try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch(ClassNotFoundException e){
System.out.println("ForName:"+e.getMessage());}
String conURL="jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};"+"DBQ=library.mdb";
Connection ExlCon=DriverManager.getConnection(conURL);
Statement Exlstmt=ExlCon.createStatement();
String t="'free'";
String a1="'"+BooknoField.getText().trim()+"'";
String a2="'"+BooknameField.getText().trim()+"'";
String a3="'"+PressField.getText().trim()+"'";
String a4="'"+AuthorField.getText().trim()+"'";
String a5="'"+PriceField.getText().trim()+"'";
String a6="select * from book where book_no='"+
BooknoField.getText().trim()+"'";
ResultSet a7=Exlstmt.executeQuery(a6);
if(a7.next())
{
JOptionPane.showMessageDialog(null,"该书号已存在!");
}
else {
String temp="INSERT INTO book VALUES ("+a1+","+a2+","+a3+","+a4+","+a5+","+t+")";
Exlstmt.executeUpdate(temp);
JOptionPane.showMessageDialog(null,"添加成功");
ExlCon.close();
}
}
}
//书籍档案修改
class Bookmodify extends JFrame implements ActionListener
{
JPanel panel1,panel2;
Container c;
JLabel BooknoLabel,BookNameLabel,BookPressLabel,BookAuthorLabel,BookPriceLabel,BookStatusLabel,
NewBooknoLabel,NewBookNameLabel,NewBookPressLabel,NewBookAuthorLabel,NewBookPriceLabel,NewBookStatusLabel;
JTextField BooknoField,BookNameField,BookPressField,BookAuthorField,BookPriceField,BookStatusField,
NewBooknoField,NewBookNameField,NewBookPressField,NewBookAuthorField,NewBookPriceField,NewBookStatusField;
JButton ShowBtn,UpdateBtn,CancelBtn;
Bookmodify()
{
super("更改书籍档案");
c=getContentPane();
c.setLayout(new BorderLayout());
BooknoLabel=new JLabel("原书号",JLabel.CENTER);
BookNameLabel=new JLabel("原书名",JLabel.CENTER);
BookPressLabel=new JLabel("原出版社",JLabel.CENTER);
BookAuthorLabel=new JLabel("原作者名",JLabel.CENTER);
BookPriceLabel=new JLabel("原价格",JLabel.CENTER);
BookStatusLabel=new JLabel("原状态",JLabel.CENTER);
BooknoField=new JTextField(10);
BookNameField=new JTextField(10);
BookPressField=new JTextField(10);
BookAuthorField=new JTextField(10);
BookPriceField=new JTextField(10);
BookStatusField=new JTextField(10);
NewBooknoLabel=new JLabel("书号",JLabel.CENTER);
NewBookNameLabel=new JLabel("新书名",JLabel.CENTER);
NewBookPressLabel=new JLabel("新出版社",JLabel.CENTER);
NewBookAuthorLabel=new JLabel("新作者名",JLabel.CENTER);
NewBookPriceLabel=new JLabel("新价格",JLabel.CENTER);
NewBookStatusLabel=new JLabel("新状态",JLabel.CENTER);
NewBooknoField=new JTextField("书号不可更改",10);
NewBooknoField.setEditable(false);
NewBookNameField=new JTextField(10);
NewBookPressField=new JTextField(10);
NewBookAuthorField=new JTextField(10);
NewBookPriceField=new JTextField(10);
NewBookStatusField=new JTextField(10);
ShowBtn=new JButton("显示");
UpdateBtn=new JButton("更新");
CancelBtn=new JButton("取消");
ShowBtn.addActionListener(this);
UpdateBtn.addActionListener(this);
CancelBtn.addActionListener(this);
panel1=new JPanel();
panel1.setLayout(new GridLayout(6,6));
panel1.add(BooknoLabel);
panel1.add(BooknoField);
panel1.add(NewBooknoLabel);
panel1.add(NewBooknoField);
panel1.add(BookNameLabel);
panel1.add(BookNameField);
panel1.add(NewBookNameLabel);
panel1.add(NewBookNameField);
panel1.add(BookPressLabel);
panel1.add(BookPressField);
panel1.add(NewBookPressLabel);
panel1.add(NewBookPressField);
panel1.add(BookAuthorLabel);
panel1.add(BookAuthorField);
panel1.add(NewBookAuthorLabel);
panel1.add(NewBookAuthorField);
panel1.add(BookPriceLabel);
panel1.add(BookPriceField);
panel1.add(NewBookPriceLabel);
panel1.add(NewBookPriceField);
panel1.add(BookStatusLabel);
panel1.add(BookStatusField);
panel1.add(NewBookStatusLabel);
panel1.add(NewBookStatusField);
panel2=new JPanel();
panel2.add(ShowBtn);
panel2.add(UpdateBtn);
panel2.add(CancelBtn);
c.add(panel1,BorderLayout.CENTER);
c.add(panel2,BorderLayout.SOUTH);
setSize(400,180);
show();
}
public void actionPerformed(ActionEvent e)
{
if(e.getSource()==ShowBtn)
{try{Showinfo();}
catch(SQLException ee){
System.out.println("SQLException:"+ee.getMessage());}
}
else if(e.getSource()==CancelBtn)
{
dispose();
}
else if(e.getSource()==UpdateBtn)
{
if(NewBookNameField.getText().trim().equals(""))
{
JOptionPane.showMessageDialog(null,"新书名不能为空！");
}
else if(NewBookPressField.getText().trim().equals(""))
{
JOptionPane.showMessageDialog(null,"新出版社不能为空！");
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -