java GUI實(shí)現(xiàn)學(xué)生圖書(shū)管理簡(jiǎn)單實(shí)例
更新時(shí)間：2018年01月12日 14:26:44 作者：wqdsb
這篇文章主要為大家詳細(xì)介紹了java GUI實(shí)現(xiàn)學(xué)生圖書(shū)管理簡(jiǎn)單示例，具有一定的參考價(jià)值，感興趣的小伙伴們可以參考一下
本文實(shí)例為大家分享了java GUI學(xué)生圖書(shū)管理的具體代碼，供大家參考，具體內(nèi)容如下
- mysql數(shù)據(jù)庫(kù)建表：
1.book表
2.bs借書(shū)記錄表
3.std學(xué)生表
4.dl登錄用戶表
.
- 列表內(nèi)容
1.databd.java //程序入口及登錄驗(yàn)證
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import javax.swing.*;
import javax.swing.border.EmptyBorder;
public class databd extends JFrame implements ActionListener{
static frameDemo a=null;
String getuser="";
String getpd="";
String sql = "select * from dl where id='";
String sql1 = "select password from dl where password='";
JButton btnNewButton = new JButton("登錄");
JButton btnNewButton_1 = new JButton("注冊(cè)");
JTextField show=new JTextField("\t 請(qǐng)選擇按鈕",10);
private JPanel contentPane;
private JTextField userField;
private JPasswordField pwdField;
private Statement statement = null; //查詢賬號(hào)
private Statement statement2 = null; //注冊(cè)賬戶
private static databd frame; //
ResultSet rst2=null;
public static void main(String[] args) {
EventQueue.invokeLater(new Runnable() {
public void run() {
try {
frame = new databd();
frame.setVisible(true);
} catch (Exception e) {
e.printStackTrace();
}
}
});
}
public databd() {
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost:8088/library?useUnicode=true&characterEncoding=utf-8&useSSL=false";
String user = "root";
String password = "11111";
try{
Class.forName(driver);
Connection conn = DriverManager.getConnection(url, user, password);
Connection conn2 = DriverManager.getConnection(url, user, password);
statement = conn.createStatement();
statement2 = conn2.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
rst2=statement2.executeQuery("select * from dl");
show.setEditable(false);
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
setSize(250, 200);
setLocationRelativeTo(null);
contentPane = new JPanel();
contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
contentPane.setLayout(null);
add(contentPane);
JLabel lblUsername = new JLabel("賬號(hào)");
lblUsername.setBounds(12, 13, 54, 15);
contentPane.add(lblUsername);
JLabel lblPassword = new JLabel("密碼");
lblPassword.setBounds(12, 38, 54, 15);
contentPane.add(lblPassword);
userField = new JTextField();
userField.setBounds(76, 10, 144, 21);
contentPane.add(userField);
userField.setColumns(10);
pwdField = new JPasswordField();
pwdField.setEchoChar('*'); //密碼回顯字符
pwdField.setBounds(76, 35, 144, 21);
contentPane.add(pwdField);
pwdField.setColumns(10);
add(show,BorderLayout.SOUTH);
btnNewButton.addActionListener(this); //登錄
btnNewButton.setBounds(10, 92, 93, 23);
contentPane.add(btnNewButton);
btnNewButton_1.addActionListener(this); //注冊(cè)
btnNewButton_1.setBounds(127, 92, 93, 23);
contentPane.add(btnNewButton_1);
show.addActionListener(this);
}catch(ClassNotFoundException e){System.out.print("不能找到驅(qū)動(dòng)器");
}catch(Exception e){System.out.print("出現(xiàn)錯(cuò)誤");e.printStackTrace();}
}
public void actionPerformed(ActionEvent e) {
getuser=userField.getText().trim()+"'";
String pd=String.valueOf(pwdField.getPassword());
try{
ResultSet rs=statement.executeQuery(sql+getuser);
if(e.getSource()==btnNewButton){ //登錄
if(rs.next()){
if(rs.getString(2).equals(pd)){
frame.setVisible(false);
JOptionPane.showMessageDialog(null, "登錄成功");
UIManager.setLookAndFeel(UIManager.getSystemLookAndFeelClassName());
a=frameDemo.a; //生成靜態(tài)對(duì)象
}else show.setText("\t 密碼錯(cuò)誤");
}
else
show.setText("\t 賬號(hào)不存在");
}
else if(e.getSource()==btnNewButton_1){ //注冊(cè)
if(userField.getText().equals("")){
show.setText("\t 注冊(cè)賬號(hào)不能為空");}
else {
if((String.valueOf(pwdField.getPassword())).equals(""))
show.setText("\t 注冊(cè)密碼不能為空");
else {register();}
}
}
}catch(Exception c){c.printStackTrace();}
}
private void register(){
String name=userField.getText(),
passwd=String.valueOf(pwdField.getPassword());
try{
rst2.moveToInsertRow();
rst2.updateString(1, name);
rst2.updateString(2, passwd);
rst2.insertRow();
rst2.moveToCurrentRow();
show.setText("\t 注冊(cè)成功");
}catch(Exception e){show.setText("\t 注冊(cè)失敗");}
}
}
2.frameDemo //主框架，處理事件交給addinformation類
package database;
import javax.swing.*;
import javax.swing.border.TitledBorder;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import java.util.Calendar;
import java.util.GregorianCalendar;
public class frameDemo extends JFrame implements ActionListener{
public static frameDemo a=new frameDemo();
JPanel panel=new JPanel(),
panel1=new JPanel(),
panel2=new JPanel(),
panel3=new JPanel(),
panel4=new JPanel(),
panel5=new JPanel();
String[] adds={"請(qǐng)選擇操作","添加館藏記錄","添加借書(shū)記錄","添加學(xué)生記錄"};
String[] deletes={"請(qǐng)選擇操作","刪除館藏記錄","刪除借書(shū)記錄","刪除學(xué)生記錄"};
String[] changes={"請(qǐng)選擇操作","修改庫(kù)存記錄","修改應(yīng)還日期"};
String[] querys={"請(qǐng)選擇操作","查詢書(shū)籍","查詢書(shū)號(hào)","查詢學(xué)生借書(shū)記錄","查詢學(xué)生信息"};
String[] shows={"請(qǐng)選擇操作","顯示所有館藏記錄","顯示借書(shū)記錄","顯示學(xué)生記錄"};
String[] record=new String[4];
JTextArea ta=new JTextArea("-->歡迎使用系統(tǒng)\n",11,60);
JScrollPane pane=new JScrollPane(ta);
Connection conn=null;
Statement stmt=null;
Statement stmt1=null;
Statement stmt2=null;
ResultSet rst=null;
ResultSet rst1=null;
ResultSet rst2=null;
static boolean key;
private JFrame big=new JFrame("請(qǐng)選擇操作");
private JComboBox add=new JComboBox(adds);
private JComboBox delete=new JComboBox(deletes);
private JComboBox change=new JComboBox(changes);
private JComboBox query=new JComboBox(querys);
private JComboBox show=new JComboBox(shows);
public frameDemo(){
super("圖書(shū)館管理系統(tǒng)");
try{
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://localhost:8088/library?useUnicode=true&characterEncoding=utf-8&useSSL=false";
String user="root";
String password="11111";
conn=DriverManager.getConnection(url, user, password);
panel4.setLayout(new GridLayout(3,1,30,10));
panel4.setBorder(new TitledBorder("選擇管理:"));
panel1.add(new JLabel("添加記錄:"));
panel1.add(add);
panel1.add(new JLabel("刪除記錄:"));
panel1.add(delete);
panel2.add(new JLabel("修改記錄:"));
panel2.add(change);
panel2.add(new JLabel("查詢記錄:"));
panel2.add(query);
panel3.add(new JLabel("顯示記錄:"));
panel3.add(show);
panel4.add(panel1);panel4.add(panel2);panel4.add(panel3);
panel5.add(pane);
panel.add(panel5,BorderLayout.SOUTH);
panel.add(panel4,BorderLayout.CENTER);
add(panel);
//pack();
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);//可滾可更
stmt1=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
stmt2=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
add.addActionListener(this);
delete.addActionListener(this);
change.addActionListener(this);
query.addActionListener(this);
show.addActionListener(this);
setSize(470,440);
//setResizable(false);
setLocationRelativeTo(null);
setVisible(true);
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
}catch(Exception e){e.printStackTrace();}
}
public void actionPerformed(ActionEvent ae){
try{
//if(key){ //數(shù)據(jù)庫(kù)非空
if(add.getSelectedIndex()==1){
ta.append("-->添加館藏記錄\n");
addinformation a1=new addinformation("圖書(shū)編號(hào)", "書(shū)名", "庫(kù)存",1);
}
else if(add.getSelectedIndex()==2){
ta.append("-->添加借書(shū)記錄\n");
addinformation a1=new addinformation("圖書(shū)編號(hào)", "學(xué)號(hào)",2);
}
else if(add.getSelectedIndex()==3){
ta.append("-->添加學(xué)生記錄\n");
addinformation a1=new addinformation("學(xué)生學(xué)號(hào)", "學(xué)生姓名",3);
}
add.setSelectedItem("請(qǐng)選擇操作");
if(delete.getSelectedIndex()==1){
ta.append("-->刪除館藏記錄\n");
addinformation a1=new addinformation("圖書(shū)編號(hào)",4);
}
else if(delete.getSelectedIndex()==2){
ta.append("-->刪除借書(shū)記錄\n");
addinformation a1=new addinformation("圖書(shū)編號(hào)","學(xué)生學(xué)號(hào)",5);
}
else if(delete.getSelectedIndex()==3){
ta.append("-->刪除學(xué)生記錄\n");
addinformation a1=new addinformation("學(xué)生學(xué)號(hào)",6);
}
delete.setSelectedItem("請(qǐng)選擇操作");
if(change.getSelectedIndex()==1){
ta.append("-->修改庫(kù)存記錄\n");
addinformation a1=new addinformation("圖書(shū)編號(hào)","庫(kù)存數(shù)目",7);
}
else if(change.getSelectedIndex()==2){
ta.append("-->修改應(yīng)還日期\n");
addinformation a1=new addinformation("圖書(shū)編號(hào)","學(xué)生學(xué)號(hào)","應(yīng)還日期",8);
}
change.setSelectedItem("請(qǐng)選擇操作");
if(query.getSelectedIndex()==1){
ta.append("-->按書(shū)名查詢\n");
addinformation a1=new addinformation("書(shū)名",9);
}
else if(query.getSelectedIndex()==2){
ta.append("-->按書(shū)籍編號(hào)查詢\n");
addinformation a1=new addinformation("書(shū)籍編號(hào)",10);
}
else if(query.getSelectedIndex()==3){
ta.append("-->查詢學(xué)生借書(shū)記錄\n");
addinformation a1=new addinformation("學(xué)生學(xué)號(hào)",11);
}
else if(query.getSelectedIndex()==4){
ta.append("-->查詢學(xué)生信息\n");
addinformation a1=new addinformation("學(xué)生學(xué)號(hào)",12);
}
query.setSelectedItem("請(qǐng)選擇操作");
if(show.getSelectedIndex()==1){
ta.append("-->顯示所有館藏記錄\n");
try{
rst=stmt.executeQuery("SELECT * FROM book");
rst.first();
ta.append("------------------------------------\n");
int id=rst.getInt(1);
String name=rst.getString(2);
int num=rst.getInt(3);
ta.append("\t書(shū)籍編號(hào)\t書(shū)籍名稱\t在館庫(kù)存\n");
ta.append("\t"+id+"\t"+name+"\t"+num+"\n");
while(rst.next()){
id=rst.getInt(1);
name=rst.getString(2);
num=rst.getInt(3);
ta.append("\t"+id+"\t"+name+"\t"+num+"\n");
}//執(zhí)行后游標(biāo)指向最后一行的后一個(gè)位置
rst.first();
ta.append("------------------------------------\n");
}catch(Exception e){ta.append("-->顯示錯(cuò)誤");}
}
else if(show.getSelectedIndex()==2){
ta.append("-->顯示借書(shū)記錄\n");
rst1=stmt1.executeQuery("SELECT * FROM bs");
Calendar calendar =new GregorianCalendar();
try{
rst1.first();
ta.append("----------------------------------------------------\n");
int bookid=rst1.getInt(2);
int stdid=rst1.getInt(3);
Date x=rst1.getDate(4);
calendar.setTime(x);
calendar.add(calendar.DATE, 30);
java.util.Date utilDate = (java.util.Date)calendar.getTime();
utilDate = (java.util.Date)calendar.getTime();
Date newDate =new Date(utilDate.getTime());
ta.append("\t書(shū)籍編號(hào)\t學(xué)生學(xué)號(hào)\t借書(shū)日期\t\t應(yīng)還日期\n");
ta.append("\t"+bookid+"\t"+stdid+"\t"+x+"\t"+newDate+"\n");
while(rst1.next()){
bookid=rst1.getInt(2);
stdid=rst1.getInt(3);
x=rst1.getDate(4);
calendar.setTime(x);
calendar.add(calendar.DATE, 30);
utilDate = (java.util.Date)calendar.getTime();
utilDate = (java.util.Date)calendar.getTime();
newDate =new Date(utilDate.getTime());
ta.append("\t"+bookid+"\t"+stdid+"\t"+x+"\t"+newDate+"\n");
}//執(zhí)行后游標(biāo)指向最后一行的后一個(gè)位置
rst1.first();
ta.append("----------------------------------------------------\n");
}catch(Exception e){ta.append("-->顯示錯(cuò)誤");e.printStackTrace();}
}
else if(show.getSelectedIndex()==3){
ta.append("-->顯示學(xué)生記錄\n");
try{
rst2=stmt2.executeQuery("SELECT * FROM std");
rst2.first();
ta.append("------------------------------------\n");
int id=rst2.getInt(1);
String name=rst2.getString(2);
ta.append("\t學(xué)生學(xué)號(hào)\t學(xué)生姓名\n");
ta.append("\t"+id+"\t"+name+"\t"+"\n");
while(rst2.next()){
id=rst2.getInt(1);
name=rst2.getString(2);
ta.append("\t"+id+"\t"+name+"\t"+"\n");
}//執(zhí)行后游標(biāo)指向最后一行的后一個(gè)位置
rst2.first();
ta.append("------------------------------------\n");
}catch(Exception e){ta.append("-->顯示錯(cuò)誤");}
}
show.setSelectedItem("請(qǐng)選擇操作");
ta.setCaretPosition(ta.getText().length()); //滾動(dòng)條保持在最后一條
}catch(Exception e){e.printStackTrace();}
}
public void showMessage(){
try{
int a=rst.getRow();
ta.append(a+"\n");
rst.first();
ta.append("---------------------------\n");
String id=rst.getString(1),
name=rst.getString(2),
brand=rst.getString(3),
price=rst.getString(4),
stock=rst.getString(5);
ta.append(id+" "+name+" "+brand+" "+price+" "+stock+"\n");
while(rst.next()){
id=rst.getString(1);
name=rst.getString(2);
brand=rst.getString(3);
price=rst.getString(4);
stock=rst.getString(5);
ta.append(id+" "+name+" "+brand+" "+price+" "+stock+"\n");
}//執(zhí)行后游標(biāo)指向最后一行的后一個(gè)位置
rst.absolute(a);
ta.append("---------------------------\n");
}catch(Exception e){ta.append("-->顯示錯(cuò)誤");}
}
// public static void main(String[] args){
// try{
//UIManager.setLookAndFeel(UIManager.getSystemLookAndFeelClassName());
// }catch(Exception e){System.out.print("1111111111");}
// a=new frameDemo();
// }
}
3.addinformation.java //處理事件
package database;
import javax.swing.*;
import java.util.Calendar;
import java.util.GregorianCalendar;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
public class addinformation extends JFrame implements ActionListener{
JButton sure=new JButton("確定"),
quxiao=new JButton("取消");
JTextField jtf1=new JTextField(10),
jtf2=new JTextField(10),
jtf3=new JTextField(10);
Connection conn=null;
static{
try{
Class.forName("com.mysql.jdbc.Driver");
}catch(Exception e){e.printStackTrace();}
}
int x=0;
public Connection getConnection() throws SQLException{
if(conn==null){
conn=DriverManager.getConnection("jdbc:mysql://localhost:8088/library?useUnicode=true&characterEncoding=utf-8&useSSL=false","root","11111");
}
return conn;
}
addinformation(String s1,String s2,String s3,int m){
JPanel p=new JPanel();
p.setLayout(new FlowLayout());
p.add(new JLabel(s1));
p.add(jtf1);
p.add(new JLabel(s2));
p.add(jtf2);
p.add(new JLabel(s3));
p.add(jtf3);
p.add(sure);
p.add(quxiao);
add(p);
if(m==8){
JOptionPane.showMessageDialog(null, "圖書(shū)日期應(yīng)為 XXXX-XX-XX 格式！","警告",JOptionPane.WARNING_MESSAGE);
}
setSize(500, 100);
setVisible(true);
setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
setLocationRelativeTo(null);
sure.addActionListener(this);
quxiao.addActionListener(this);
x=m;
}
addinformation(String s1,String s2,int m){
JPanel p=new JPanel();
p.setLayout(new FlowLayout());
p.add(new JLabel(s1));
p.add(jtf1);
p.add(new JLabel(s2));
p.add(jtf2);
p.add(sure);
p.add(quxiao);
add(p);
setSize(500, 100);
setVisible(true);
setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
setLocationRelativeTo(null);
sure.addActionListener(this);
quxiao.addActionListener(this);
x=m;
}
addinformation(String s1,int m){
JPanel p=new JPanel();
p.setLayout(new FlowLayout());
p.add(new JLabel(s1));
p.add(jtf1);
if(m==4){
JOptionPane.showMessageDialog(null, "若存在借閱記錄則不能刪除書(shū)籍信息！","警告",JOptionPane.WARNING_MESSAGE);
}
if(m==6){
JOptionPane.showMessageDialog(null, "若學(xué)生存在借閱記錄則不能刪除該學(xué)生信息！","警告",JOptionPane.WARNING_MESSAGE);
}
p.add(sure);
p.add(quxiao);
add(p);
setSize(500, 80);
setVisible(true);
setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
setLocationRelativeTo(null);
sure.addActionListener(this);
quxiao.addActionListener(this);
x=m;
}
public void actionPerformed(ActionEvent ae){
if(ae.getSource()==sure){
if(x==1){ //添加 館藏記錄
String sql="INSERT INTO book VALUES(?,?,?)";
try(
Connection conn=getConnection();
PreparedStatement stmt=conn.prepareStatement(sql)){
int id=Integer.parseInt(jtf1.getText());
String name=jtf2.getText();
int num=Integer.parseInt(jtf3.getText());
stmt.setInt(1, id);
stmt.setString(2, name);
stmt.setInt(3, num);
stmt.executeUpdate();
frameDemo.a.ta.append("-->添加成功\n");
}catch(Exception x){frameDemo.a.ta.append("-->插入出錯(cuò)\n");x.printStackTrace();}
addinformation.this.dispose();
}
if(x==2){ //添加借書(shū)記錄
String sql="INSERT INTO bs(bookid,stdid,date) VALUES(?,?,?)";
String sql1="SELECT id,num FROM book WHERE id=?";
String sql2="SELECT id FROM std WHERE id=?";
try{
Connection conn1=getConnection();
PreparedStatement stmt1=conn1.prepareStatement(sql1,ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
stmt1.setInt(1,Integer.parseInt(jtf1.getText()));
ResultSet rst1=stmt1.executeQuery();//找有沒(méi)有這本書(shū)和庫(kù)存是否為0
if(rst1.next()&&(rst1.getInt(2)>0)){
int n=rst1.getInt(2);n-=1;
int m=rst1.getInt(1);
rst1.updateInt(1, m);
rst1.updateInt(2, n);
rst1.updateRow();
Connection conn2=getConnection();
PreparedStatement stmt2=conn2.prepareStatement(sql2);
stmt2.setInt(1,Integer.parseInt(jtf2.getText()));
ResultSet rst2=stmt2.executeQuery();//有人
if(rst2.next()){
Connection conn=getConnection();
PreparedStatement stmt=conn.prepareStatement(sql);
int bookid=Integer.parseInt(jtf1.getText());
int stdid=Integer.parseInt(jtf2.getText());
stmt.setInt(1, bookid);
stmt.setInt(2, stdid);
stmt.setDate(3, new Date(System.currentTimeMillis()));
stmt.executeUpdate();
frameDemo.a.ta.append("-->添加成功\n");
}
else{frameDemo.a.ta.append("-->無(wú)該學(xué)生記錄，不能添加借閱記錄\n");}
}else{frameDemo.a.ta.append("-->無(wú)此書(shū)或已全部借出\n");}
}catch(Exception x){frameDemo.a.ta.append("-->插入出錯(cuò)\n");x.printStackTrace();}
addinformation.this.dispose();
}
if(x==3){ //添加學(xué)生記錄
String sql="INSERT INTO std VALUES(?,?)";
try(
Connection conn=getConnection();
PreparedStatement stmt=conn.prepareStatement(sql)){
int id=Integer.parseInt(jtf1.getText());
String name=jtf2.getText();
stmt.setInt(1, id);
stmt.setString(2, name);
stmt.executeUpdate();
frameDemo.a.ta.append("-->添加成功\n");
}catch(Exception x){frameDemo.a.ta.append("-->插入出錯(cuò)\n");x.printStackTrace();}
addinformation.this.dispose();
}
if(x==4){ //刪除圖書(shū)記錄
String sql="DELETE FROM book WHERE id=?";
String sql1="SELECT * FROM bs WHERE bookid=?";
try{
Connection conn1=getConnection();
PreparedStatement stmt1=conn1.prepareStatement(sql1);
stmt1.setInt(1,Integer.parseInt(jtf1.getText()));
ResultSet rst1=stmt1.executeQuery();
if(rst1.next()){ //借閱記錄中有書(shū)
JOptionPane.showMessageDialog(null, "借閱記錄中有該書(shū)的借閱記錄！","警告",JOptionPane.WARNING_MESSAGE);
}
else{ //借閱記錄無(wú)書(shū)，可以刪掉
Connection conn=getConnection();
PreparedStatement stmt=conn.prepareStatement(sql);
int id=Integer.parseInt(jtf1.getText());
stmt.setInt(1, id);
int t=stmt.executeUpdate();
if(t==0){
frameDemo.a.ta.append("-->刪除出錯(cuò)\n");
JOptionPane.showMessageDialog(null, "不存在該圖書(shū)信息！","警告",JOptionPane.WARNING_MESSAGE);
}
else frameDemo.a.ta.append("-->刪除記錄成功\n");
}
}catch(Exception x){frameDemo.a.ta.append("-->刪除失敗\n");x.printStackTrace();}
addinformation.this.dispose();
}
if(x==5){ //刪除借書(shū)記錄
String sql="DELETE FROM bs WHERE bookid=? AND stdid=?";
String sql1="SELECT id,num FROM book WHERE id=?";
try{
Connection conn=getConnection();
PreparedStatement stmt=conn.prepareStatement(sql);
int bookid=Integer.parseInt(jtf1.getText());
int stdid=Integer.parseInt(jtf2.getText());
stmt.setInt(1, bookid);
stmt.setInt(2, stdid);
int t=stmt.executeUpdate();
if(t!=0){
Connection conn1=getConnection();
PreparedStatement stmt1=conn1.prepareStatement(sql1,ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
stmt1.setInt(1,Integer.parseInt(jtf1.getText()));
ResultSet rst1=stmt1.executeQuery();rst1.next();
int m=rst1.getInt(1);
int n=rst1.getInt(2);n+=1;
rst1.updateInt(1, m);
rst1.updateInt(2, n);
rst1.updateRow();
frameDemo.a.ta.append("-->刪除借閱記錄成功\n");
}
else{
frameDemo.a.ta.append("-->刪除出錯(cuò)\n");
JOptionPane.showMessageDialog(null, "不存在這條借閱記錄！","警告",JOptionPane.WARNING_MESSAGE);
}
}catch(Exception x){frameDemo.a.ta.append("-->刪除出錯(cuò)\n");x.printStackTrace();}
addinformation.this.dispose();
}
if(x==6){ //刪除學(xué)生記錄
String sql="DELETE FROM std WHERE id=?";
String sql1="SELECT * FROM bs WHERE stdid=?";
try {
Connection conn1=getConnection();
PreparedStatement stmt1=conn1.prepareStatement(sql1);
stmt1.setInt(1,Integer.parseInt(jtf1.getText()));
ResultSet rst1=stmt1.executeQuery();
if(rst1.next()){ //借閱記錄中有該人
JOptionPane.showMessageDialog(null, "借閱記錄中有該人的借閱記錄！","警告",JOptionPane.WARNING_MESSAGE);
}
else{
Connection conn=getConnection();
PreparedStatement stmt=conn.prepareStatement(sql);
int stdid=Integer.parseInt(jtf1.getText());
stmt.setInt(1, stdid);
int t=stmt.executeUpdate();
if(t==0){
frameDemo.a.ta.append("-->刪除出錯(cuò)\n");
JOptionPane.showMessageDialog(null, "不存在該學(xué)生記錄！","警告",JOptionPane.WARNING_MESSAGE);
}
else frameDemo.a.ta.append("-->刪除記錄成功\n");
}
}catch(Exception x){frameDemo.a.ta.append("-->刪除出錯(cuò)\n");x.printStackTrace();}
addinformation.this.dispose();
}
if(x==7){ //修改圖書(shū)庫(kù)存記錄
String sql="UPDATE book SET num=? WHERE id=?";
try(
Connection conn=getConnection();
PreparedStatement stmt=conn.prepareStatement(sql)){
int num=Integer.parseInt(jtf2.getText());
int bookid=Integer.parseInt(jtf1.getText());
stmt.setInt(1, num);
stmt.setInt(2, bookid);
int t=stmt.executeUpdate();
if(t==0){
frameDemo.a.ta.append("-->修改出錯(cuò)\n");
JOptionPane.showMessageDialog(null, "不存在該圖書(shū)記錄！","警告",JOptionPane.WARNING_MESSAGE);
}
else frameDemo.a.ta.append("-->修改記錄成功\n");
}catch(Exception x){frameDemo.a.ta.append("-->修改出錯(cuò)\n");x.printStackTrace();}
addinformation.this.dispose();
}
if(x==8){ //修改應(yīng)還日期
String sql="UPDATE bs SET date=? WHERE bookid=? AND stdid=?";
try(
Connection conn=getConnection();
PreparedStatement stmt=conn.prepareStatement(sql)){
Date date = Date.valueOf(jtf3.getText());
Calendar calendar =new GregorianCalendar();
calendar.setTime(date);
calendar.add(calendar.DATE, -30);
java.util.Date utilDate = (java.util.Date)calendar.getTime();
utilDate = (java.util.Date)calendar.getTime();
Date newDate =new Date(utilDate.getTime());
int stdid=Integer.parseInt(jtf2.getText());
int bookid=Integer.parseInt(jtf1.getText());
stmt.setDate(1, newDate);
stmt.setInt(2, bookid);
stmt.setInt(3, stdid);
int t=stmt.executeUpdate();
if(t==0){
frameDemo.a.ta.append("-->修改出錯(cuò)\n");
JOptionPane.showMessageDialog(null, "不存在該借書(shū)記錄！","警告",JOptionPane.WARNING_MESSAGE);
}
else frameDemo.a.ta.append("-->修改記錄成功\n");
}catch(Exception x){frameDemo.a.ta.append("-->修改出錯(cuò)\n");x.printStackTrace();}
addinformation.this.dispose();
}
if(x==9){ //按書(shū)名查詢
String sql="SELECT * from book WHERE name=?";
ResultSet rst=null;
try(
Connection conn=getConnection();
PreparedStatement stmt=conn.prepareStatement(sql)){
String name=jtf1.getText();
stmt.setString(1, name);
rst=stmt.executeQuery();
if(rst.next()){
frameDemo.a.ta.append("---------------------------------------\n");
frameDemo.a.ta.append("\t圖書(shū)編號(hào)\t書(shū)名\t在館數(shù)\n");
frameDemo.a.ta.append("\t"+rst.getInt(1)+"\t"+rst.getString(2)+"\t"+rst.getInt(3)+"\n");
frameDemo.a.ta.append("---------------------------------------\n");
}
else{
frameDemo.a.ta.append("-->查詢出錯(cuò)\n");
JOptionPane.showMessageDialog(null, "不存在該書(shū)！","警告",JOptionPane.WARNING_MESSAGE);
}
}catch(Exception x){frameDemo.a.ta.append("-->查詢出錯(cuò)\n");x.printStackTrace();}
addinformation.this.dispose();
}
if(x==10){ //按書(shū)籍編號(hào)查詢
String sql="SELECT * from book WHERE id=?";
ResultSet rst=null;
try(
Connection conn=getConnection();
PreparedStatement stmt=conn.prepareStatement(sql)){
stmt.setInt(1, Integer.parseInt(jtf1.getText()));
rst=stmt.executeQuery();
if(rst.next()){
frameDemo.a.ta.append("---------------------------------------\n");
frameDemo.a.ta.append("\t圖書(shū)編號(hào)\t書(shū)名\t在館數(shù)\n");
frameDemo.a.ta.append("\t"+rst.getInt(1)+"\t"+rst.getString(2)+"\t"+rst.getInt(3)+"\n");
frameDemo.a.ta.append("---------------------------------------\n");
}
else{
frameDemo.a.ta.append("-->查詢出錯(cuò)\n");
JOptionPane.showMessageDialog(null, "不存在該書(shū)！","警告",JOptionPane.WARNING_MESSAGE);
}
}catch(Exception x){frameDemo.a.ta.append("-->查詢出錯(cuò)\n");x.printStackTrace();}
addinformation.this.dispose();
}
if(x==11){ //按學(xué)生借書(shū)記錄查詢
String sql="SELECT bookid,stdid,date from bs WHERE stdid=?";
ResultSet rst=null;
try(
Connection conn=getConnection();
PreparedStatement stmt=conn.prepareStatement(sql)){
stmt.setInt(1, Integer.parseInt(jtf1.getText()));
rst=stmt.executeQuery();
Calendar calendar =new GregorianCalendar();
if(rst.next()){
frameDemo.a.ta.append("----------------------------------------------------\n");
frameDemo.a.ta.append("\t圖書(shū)編號(hào)\t學(xué)生學(xué)號(hào)\t借書(shū)時(shí)間\t\t應(yīng)還時(shí)間\n");
Date x=rst.getDate(3);
calendar.setTime(x);
calendar.add(calendar.DATE, 30);
java.util.Date utilDate = (java.util.Date)calendar.getTime();
utilDate = (java.util.Date)calendar.getTime();
Date newDate =new Date(utilDate.getTime());
frameDemo.a.ta.append("\t"+rst.getInt(1)+"\t"+rst.getInt(2)+"\t"+x+"\t"+newDate+"\n");
while(rst.next()){
x=rst.getDate(3);
calendar.setTime(x);
calendar.add(calendar.DATE, 30);
utilDate = (java.util.Date)calendar.getTime();
utilDate = (java.util.Date)calendar.getTime();
newDate =new Date(utilDate.getTime());
frameDemo.a.ta.append("\t"+rst.getInt(1)+"\t"+rst.getInt(2)+"\t"+x+"\t"+newDate+"\n");
}
frameDemo.a.ta.append("----------------------------------------------------\n");
}
else{
frameDemo.a.ta.append("-->查詢出錯(cuò)\n");
JOptionPane.showMessageDialog(null, "不存在該借書(shū)記錄！","警告",JOptionPane.WARNING_MESSAGE);
}
}catch(Exception x){frameDemo.a.ta.append("-->查詢出錯(cuò)\n");x.printStackTrace();}
addinformation.this.dispose();
}
if(x==12){ //查詢學(xué)生信息
String sql="SELECT * from std WHERE id=?";
ResultSet rst=null;
try(
Connection conn=getConnection();
PreparedStatement stmt=conn.prepareStatement(sql)){
stmt.setInt(1, Integer.parseInt(jtf1.getText()));
rst=stmt.executeQuery();
if(rst.next()){
frameDemo.a.ta.append("---------------------------------------\n");
frameDemo.a.ta.append("\t學(xué)生學(xué)號(hào)\t學(xué)生姓名\t\n");
frameDemo.a.ta.append("\t"+rst.getInt(1)+"\t"+rst.getString(2)+"\n");
frameDemo.a.ta.append("---------------------------------------\n");
}
else{
frameDemo.a.ta.append("-->查詢出錯(cuò)\n");
JOptionPane.showMessageDialog(null, "不存在該學(xué)生！","警告",JOptionPane.WARNING_MESSAGE);
}
}catch(Exception x){frameDemo.a.ta.append("-->查詢出錯(cuò)\n");x.printStackTrace();}
addinformation.this.dispose();
}
}
if(ae.getSource()==quxiao){
addinformation.this.dispose();
frameDemo.a.ta.append("-->操作取消\n");
}
}
}
以上就是本文的全部?jī)?nèi)容，希望對(duì)大家的學(xué)習(xí)有所幫助，也希望大家多多支持腳本之家。
您可能感興趣的文章:
- 圖書(shū)管理系統(tǒng)java代碼實(shí)現(xiàn)
- 圖書(shū)管理系統(tǒng)java版
- 一個(gè)簡(jiǎn)陋的java圖書(shū)管理系統(tǒng)
- java實(shí)現(xiàn)圖書(shū)館管理系統(tǒng)
- Java+MySQL實(shí)現(xiàn)圖書(shū)管理系統(tǒng)(完整代碼)
- 圖書(shū)信息管理java實(shí)現(xiàn)代碼
- JAVA初級(jí)項(xiàng)目——實(shí)現(xiàn)圖書(shū)管理系統(tǒng)
- java控制臺(tái)輸出圖書(shū)館管理系統(tǒng)
- java+mysql實(shí)現(xiàn)圖書(shū)館管理系統(tǒng)實(shí)戰(zhàn)
- AndriodStudio使用listview實(shí)現(xiàn)簡(jiǎn)單圖書(shū)管理
相關(guān)文章
![解決Idea運(yùn)行junit測(cè)試時(shí)報(bào)Error:[3,17]?程序包org.junit不存在的問(wèn)題](http://img.jbzj.com/images/xgimg/bcimg0.png)
解決Idea運(yùn)行junit測(cè)試時(shí)報(bào)Error:[3,17]?程序包org.junit不存在的問(wèn)題
這篇文章主要介紹了Idea運(yùn)行junit測(cè)試時(shí)報(bào)Error:[3,17]?程序包org.junit不存在解決方法,本文給大家分享兩種解決辦法，需要的朋友可以參考下2023-03-03
java讀取cvs文件并導(dǎo)入數(shù)據(jù)庫(kù)
這篇文章主要為大家詳細(xì)介紹了java讀取cvs文件并導(dǎo)入數(shù)據(jù)庫(kù)，具有一定的參考價(jià)值，感興趣的小伙伴們可以參考一下2019-08-08
SpringBoot返回文件使前端下載的幾種方式小結(jié)
本文主要介紹了Spring Boot中幾種文件下載的方法,通過(guò)后端應(yīng)用下載文件并進(jìn)行業(yè)務(wù)處理,文中通過(guò)示例代碼介紹的非常詳細(xì),對(duì)大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價(jià)值,需要的朋友們下面隨著小編來(lái)一起學(xué)習(xí)學(xué)習(xí)吧2024-11-11
關(guān)于Java雙大括號(hào){{}}的具體使用
本文主要介紹了關(guān)于Java雙大括號(hào){{}}的具體使用，文中通過(guò)示例代碼介紹的非常詳細(xì)，對(duì)大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價(jià)值，需要的朋友們下面隨著小編來(lái)一起學(xué)習(xí)學(xué)習(xí)吧2022-07-07
如何解決Could not transfer artifact org.spri
在Maven更新過(guò)程中遇到“Could not transfer artifact org.springframework.boot”錯(cuò)誤通常是由于網(wǎng)絡(luò)問(wèn)題,解決方法是在Maven的設(shè)置中忽略HTTPS,添加特定語(yǔ)句后,可以正常下載依賴,但下載速度可能較慢,這是一種常見(jiàn)的解決方案,希望對(duì)遇到相同問(wèn)題的人有所幫助2024-09-09
詳解簡(jiǎn)單基于spring的redis配置(單機(jī)和集群模式)
這篇文章主要介紹了詳解簡(jiǎn)單基于spring的redis配置(單機(jī)和集群模式)，小編覺(jué)得挺不錯(cuò)的，現(xiàn)在分享給大家，也給大家做個(gè)參考。一起跟隨小編過(guò)來(lái)看看吧2019-02-02
淺析fastjson2時(shí)間序列化和反序列化的簡(jiǎn)單使用
在項(xiàng)目中將fastjson升級(jí)為fastjson2后,我們遇到了一些與fastjson不完全兼容的問(wèn)題,所以本文就來(lái)探討下fastjson2的時(shí)間序列化和反序列化的簡(jiǎn)單使用吧2025-01-01
springBoot基于webSocket實(shí)現(xiàn)掃碼登錄
最近做了個(gè)新項(xiàng)目，涉及到掃碼登錄。之前項(xiàng)目使用的是 ajax輪詢的方式。感覺(jué)太low了。所以這次用webSocket的方式進(jìn)行實(shí)現(xiàn)，感興趣的可以了解一下2021-06-06
mybatis中${}和#{}的區(qū)別以及底層原理分析
這篇文章主要介紹了mybatis中${}和#{}的區(qū)別以及底層原理,具有很好的參考價(jià)值,希望對(duì)大家有所幫助,如有錯(cuò)誤或未考慮完全的地方,望不吝賜教2024-05-05
這篇文章主要給大家分享了java自帶排序使用，該方法是升序排序，方法的內(nèi)部采用了快排實(shí)現(xiàn)，但該方法是?穩(wěn)定的。下面一起來(lái)看看文章的詳細(xì)介紹吧2021-12-12