📄 library.java
字号:
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 a1="'"+BooknoField.getText().trim()+"'";
String a2="'"+BookNameField.getText().trim()+"'";
String a3="'"+StudentnoField.getText().trim()+"'";
String a4="'"+NameField.getText().trim()+"'";
String a5="'"+DateField.getText().trim()+"'";
String a6="'borrowed'";
String temp="INSERT INTO bookborrowed VALUES ("+a1+","+a2+","+a3+","+a4+","+a5+")";
Exlstmt.executeUpdate(temp);
String s7="UPDATE book SET status="+a6+"WHERE book_no ="+a1;
Exlstmt.executeUpdate(s7);
JOptionPane.showMessageDialog(null,"借出登记成功");
ExlCon.close();
}}
//还书
class Returnbook extends JFrame implements ActionListener
{
JPanel panel1,panel2;
Container c;
JLabel StudentnoLabel,BooknoLabel;
JTextField BooknoField,StudentnoField;
JButton YesBtn,CancelBtn;
Returnbook()
{
super("删除书籍档案");
c=getContentPane();
c.setLayout(new BorderLayout());
BooknoLabel=new JLabel("书籍编号",JLabel.CENTER);
StudentnoLabel=new JLabel("学生号",JLabel.CENTER);
BooknoField=new JTextField(7);
StudentnoField=new JTextField(7);
YesBtn=new JButton("确定");
CancelBtn=new JButton("取消");
YesBtn.addActionListener(this);
CancelBtn.addActionListener(this);
panel1=new JPanel();
panel1.setLayout(new GridLayout(2,2));
panel1.add(StudentnoLabel);
panel1.add(StudentnoField);
panel1.add(BooknoLabel);
panel1.add(BooknoField);
panel2=new JPanel();
panel2.add(YesBtn);
panel2.add(CancelBtn);
c.add(panel1,BorderLayout.CENTER);
c.add(panel2,BorderLayout.SOUTH);
setSize(250,110);
show();
}
public void actionPerformed(ActionEvent e)
{
if(e.getSource()==CancelBtn)
{
this.dispose();
}
else if(e.getSource()==YesBtn)
{
if(BooknoField.getText().trim().equals(""))
{
JOptionPane.showMessageDialog(null,"书号不能为空！");
}
else if(StudentnoField.getText().trim().equals(""))
{
JOptionPane.showMessageDialog(null,"学生号不能为空！");
}
else
{
try{Bookreturn();}
catch(SQLException ee){
System.out.println("SQLException:"+ee.getMessage());}
}
}
}
public void Bookreturn()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 c1="'"+BooknoField.getText().trim()+"'",
c2="'"+StudentnoField.getText().trim()+"'";
String b5="select * from bookborrowed where book_no="+c1+"and student_no="+c2;
ResultSet b4=Exlstmt.executeQuery(b5);
if(b4.next())
{
String a1="'"+BooknoField.getText().trim()+"'";
String temp="DELETE FROM bookborrowed WHERE book_no="+a1;
Exlstmt.executeUpdate(temp);
String a6="'free'";
String s7="UPDATE book SET status="+a6+"WHERE book_no ="+a1;
Exlstmt.executeUpdate(s7);
JOptionPane.showMessageDialog(null,"书籍已经归还");
ExlCon.close();
}
else {
JOptionPane.showMessageDialog(null,"不存在该借书记录");
}
}}
///SHOW ALL
class Borrowedlist extends JFrame implements ActionListener
{
String url="jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};"
+"DBQ=library.mdb";
JTextArea t1;
JButton flush;
Borrowedlist()
{
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 bookborrowed");
String k;
t1.setEnabled(true);
t1.setText("书籍编号"+"\t"+"书名"+"\t\t"+"借书者学号"+"\t"+"借书者名字"+"\t"+"借书时间"+"\n");
boolean boo=false;
while((boo=rs1.next())==true)
{
t1.append (rs1.getString("book_no")+"\t"+rs1.getString("book_name")+"\t\t"+rs1.getString("student_no")+"\t"+rs1.getString("student_name")+"\t"
+rs1.getString("borrowdate")+"\t"+"\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 bookborrowed");
String k;
t1.setEnabled(true);
t1.setText("书籍编号"+"\t"+"书名"+"\t\t"+"借书者学号"+"\t"+"借书者名字"+"\t"+"借书时间"+"\n");
boolean boo=false;
while((boo=rs1.next())==true)
{
t1.append (rs1.getString("book_no")+"\t"+rs1.getString("book_name")+"\t\t"+rs1.getString("student_no")+"\t"+rs1.getString("student_name")+"\t"
+rs1.getString("borrowdate")+"\t"+"\n");
}
con.close();
}
catch(SQLException ee1)
{System.out.println("SQLException :" + ee1.getMessage( ));}
}
}}
//主窗体
class Mainwindow extends JFrame implements ActionListener
{
JPanel panel1;
Container c;
JMenuBar MenuB;
JMenu SystemMenu,BookMGRMenu,BorrowBookMenu,InfoBrowseMenu,UserMGRMenu,StudentFilesMenu;
JMenuItem UserLoginMenuItem,UserAddMenuItem,UserModifyMenuItem,
UserDeleteMenuItem,ExitMenuItem,BookAddMenuItem,BookModifyMenuItem,BookDeleteMenuItem,
BorrowBookMenuItem,BorrowInfoMenuItem,ReturnBookMenuItem,ReturnInfoMenuItem,
BookListMenuItem,BorrowBookListMenuItem,UserListMenuItem,StudentAddMenuItem,StudentModifyMenuItem,
StudentDeleteMenuItem,StudentListMenuItem,About;
JLabel titleLabel,AuthorLabel,DateLabel;
Mainwindow(String s3)
{
super("图书馆管理系统");
//--系统管理菜单--
MenuB=new JMenuBar();
SystemMenu=new JMenu("系统管理");
UserMGRMenu=new JMenu("admin管理");
UserLoginMenuItem=new JMenuItem("用户重登陆");
UserAddMenuItem=new JMenuItem("添加用户");
UserModifyMenuItem=new JMenuItem("修改用户");
UserDeleteMenuItem=new JMenuItem("删除用户");
UserListMenuItem=new JMenuItem("admin列表");
ExitMenuItem=new JMenuItem("退出");
SystemMenu.add(UserLoginMenuItem);
UserMGRMenu.add(UserAddMenuItem);
UserMGRMenu.add(UserModifyMenuItem);
UserMGRMenu.add(UserDeleteMenuItem);
UserMGRMenu.add(UserListMenuItem);
SystemMenu.add(UserMGRMenu);
SystemMenu.addSeparator();
SystemMenu.add(ExitMenuItem);
UserLoginMenuItem.addActionListener(this);
UserAddMenuItem.addActionListener(this);
UserModifyMenuItem.addActionListener(this);
UserDeleteMenuItem.addActionListener(this);
UserListMenuItem.addActionListener(this);
ExitMenuItem.addActionListener(this);
MenuB.add(SystemMenu);
//学生档案管理
StudentFilesMenu=new JMenu("学生档案管理");
StudentAddMenuItem=new JMenuItem("添加学生档案");
StudentModifyMenuItem=new JMenuItem("修改学生档案");
StudentDeleteMenuItem=new JMenuItem("删除学生档案");
StudentListMenuItem=new JMenuItem("学生档案列表");
StudentFilesMenu.add(StudentAddMenuItem);
StudentFilesMenu.add(StudentModifyMenuItem);
StudentFilesMenu.add(StudentDeleteMenuItem);
StudentFilesMenu.add(StudentListMenuItem);
StudentAddMenuItem.addActionListener(this);
StudentModifyMenuItem.addActionListener(this);
StudentDeleteMenuItem.addActionListener(this);
StudentListMenuItem.addActionListener(this);
MenuB.add(StudentFilesMenu);
//--借还书管理菜单--
BorrowBookMenu=new JMenu("借还书管理");
BorrowBookMenuItem=new JMenuItem("书籍出借");
ReturnBookMenuItem=new JMenuItem("书籍还入");
BorrowBookListMenuItem=new JMenuItem("借阅情况表");
BorrowBookMenu.add(BorrowBookMenuItem);
BorrowBookMenu.add(ReturnBookMenuItem);
BorrowBookMenu.add(BorrowBookListMenuItem);
BorrowBookMenuItem.addActionListener(this);
ReturnBookMenuItem.addActionListener(this);
BorrowBookListMenuItem.addActionListener(this);
MenuB.add(BorrowBookMenu);
//---书籍管理菜单--
BookMGRMenu=new JMenu("书籍管理");
BookAddMenuItem=new JMenuItem("添加书籍");
BookModifyMenuItem=new JMenuItem("修改书籍");
BookDeleteMenuItem=new JMenuItem("删除书籍");
BookListMenuItem=new JMenuItem("书籍列表");
BookMGRMenu.add(BookAddMenuItem);
BookMGRMenu.add(BookModifyMenuItem);
BookMGRMenu.add(BookDeleteMenuItem);
BookMGRMenu.add(BookListMenuItem);
BookAddMenuItem.addActionListener(this);
BookModifyMenuItem.addActionListener(this);
BookDeleteMenuItem.addActionListener(this);
BookListMenuItem.addActionListener(this);
MenuB.add(BookMGRMenu);
//--信息一览菜单--
InfoBrowseMenu=new JMenu("关于");
About=new JMenuItem("About");
InfoBrowseMenu.add(About);
About.addActionListener(this);
MenuB.add(InfoBrowseMenu);
//----------------------------------
setJMenuBar(MenuB);
String s8="欢迎管理员:";
//String s9=" Have a good day!";
titleLabel=new JLabel(new ImageIcon(".\\background.jpg"));
JLabel label1=new JLabel(s8+s3+"!");
c=getContentPane();
c.setLayout(new BorderLayout());
panel1=new JPanel();
panel1.setLayout(new BorderLayout());
panel1.add(titleLabel,BorderLayout.CENTER);
c.add(panel1,BorderLayout.CENTER);
panel1.add(label1,BorderLayout.NORTH);
//c.add(panel1,BorderLayout.NORTH);
setBounds(150,150,640,540);
show();
}
public void actionPerformed(ActionEvent e)
{
if(e.getSource() == UserLoginMenuItem)
{//用户重登录
dispose();
new Login();}
else if(e.getSource() == UserAddMenuItem)
{//添加用户
new Useradd();
}
else if(e.getSource() == UserModifyMenuItem)
{//修改用户密码
new UserModify();
}
else if(e.getSource() == UserDeleteMenuItem)
{//DEL用户
new UserDelete();
}
else if(e.getSource() == UserListMenuItem)
{
//用户列表
new Showuser();
}
else if(e.getSource() == StudentAddMenuItem)
{
//学生档案ADD
new Studentadd();
}
else if(e.getSource() == StudentModifyMenuItem)
{//学生档案修改
new Studentmodify();
}
else if(e.getSource() == StudentDeleteMenuItem)
{//学生档案DEL
new Delstudent();
}
else if(e.getSource() == StudentListMenuItem)
{
//学生档案列表
new Studentlist();
}
else if(e.getSource()==BookAddMenuItem)
{//添加书籍
new Bookadd();
}
else if(e.getSource()==BookModifyMenuItem)
{//修改书籍档案
new Bookmodify();
}
else if(e.getSource()==BookListMenuItem)
{//书籍列表
new Booklist();
}
else if(e.getSource()==About)
{//书籍列表
new About();
}
else if(e.getSource()==BookDeleteMenuItem)
{
new Bookdel();
}
else if(e.getSource()==BorrowBookMenuItem)
{
//书籍出借
new Bookborrow();
}
else if(e.getSource()==ReturnBookMenuItem)
{
new Returnbook();
}
else if(e.getSource()==BorrowBookListMenuItem)
{
new Borrowedlist();
}
else if(e.getSource() == ExitMenuItem)
//退出
{System.exit(0);}
}
}
public class Library
{
public static void main(String args[])
{
new Login();
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -