The examples in this article share the specific code of java GUI student book management for your reference. The specific content is as follows
- MySQL database table building:
1.book table
2.bs book loan record form
3.std student table
4.dl login user table
.
- List content
1.databd.java //Program portal and login verification
import java.awt.*;import java.awt.event.*;import java.sql.*;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("Login"); JButton btnNewButton_1 = new JButton("Register"); JTextField show=new JTextField("/t Please select button",10); private JPanel contentPane; private JTextField userField; private JPasswordField pwdField; private Statement statement = null; //Query account private Statement statement2 = null; //Register account 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("Account"); lblUsername.setBounds(12, 13, 54, 15); contentPane.add(lblUsername); JLabel lblPassword = new JLabel("Password"); 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('*'); //Password echo characters pwdField.setBounds(76, 35, 144, 21); contentPane.add(pwdField); pwdField.setColumns(10); add(show,BorderLayout.SOUTH); btnNewButton.addActionListener(this); //Login btnNewButton.setBounds(10, 92, 93, 23); contentPane.add(btnNewButton); btnNewButton_1.addActionListener(this); //Register btnNewButton_1.setBounds(127, 92, 93, 23); contentPane.add(btnNewButton_1); show.addActionListener(this); }catch(ClassNotFoundException e){System.out.print("Drive not found"); }catch(Exception e){System.out.print("Error occurred");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){ //Login if(rs.next()){ if(rs.getString(2).equals(pd)){ frame.setVisible(false); JOptionPane.showMessageDialog(null, "Login successfully"); UIManager.setLookAndFeel(UIManager.getSystemLookAndFeelClassName()); a=frameDemo.a; //Generate a static object}else show.setText("/t password error"); } else show.setText("/t account does not exist"); } else if(e.getSource()==btnNewButton_1){ //Register if(userField.getText().equals("")){ show.setText("/t Registered Account cannot be empty");} else { if((String.valueOf(pwdField.getPassword())).equals("")) show.setText("/t Registered Password cannot be empty"); 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 Registration Successfully"); } catch(Exception e){show.setText("/t Registration Failed");} }}2.frameDemo //Main framework, hand over the event to the addinformation class
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={"Please select operation","Add collection record","Add book borrowing record","Add student record"}; String[] deletes={"Please select operation","Delete collection record","Delete book borrowing record","Delete student record"}; String[] changes={"Please select operation","Modify inventory record","Date to return"}; String[] querys={"Please select operation","Query book number","Query student borrowing record","Query student information"}; String[] shows={"Please select operation","Show all collection records","Show borrowing records","Show student records"}; String[] record=new String[4]; JTextArea ta=new JTextArea("-->Welcome to use system/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("Please select the operation"); 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("Library Management System"); 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="111111"; conn=DriverManager.getConnection(url, user, password); panel4.setLayout(new GridLayout(3,1,30,10)); panel4.setBorder(new TitledBorder("Select Management:")); panel1.add(new JLabel("Add record:")); panel1.add(add); panel1.add(new JLabel("Delete record:")); panel1.add(delete); panel2.add(new JLabel("Modify record:")); panel2.add(change); panel2.add(new JLabel("Query record:")); panel2.add(query); panel3.add(new JLabel("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); //roll can be rolled and updated 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){ //The database is non-empty if(add.getSelectedIndex()==1){ ta.append("-->Add collection record/n"); addinformation a1=new addinformation("Book number", "Book title", "Inventory",1); } else if(add.getSelectedIndex()==2){ ta.append("-->Add book borrow record/n"); addinformation a1=new addinformation("Book number", "Student number",2); } else if(add.getSelectedIndex()==3){ ta.append("-->Add student record/n"); addinformation a1=new addinformation("Student student number", "Student name",3); } add.setSelectedItem("Please select operation"); if(delete.getSelectedIndex()==1){ ta.append("-->Delete collection record/n"); addinformation a1=new addinformation("Book number",4); } else if(delete.getSelectedIndex()==2){ ta.append("-->Delete book borrowing record/n"); addinformation a1=new addinformation("Book number","Student student number",5); } else if(delete.getSelectedIndex()==3){ ta.append("-->Delete student record/n"); addinformation a1=new addinformation("Student student number",6); } delete.setSelectedItem("Please select operation"); if(change.getSelectedIndex()==1){ ta.append("-->Modify inventory record/n"); addinformation a1=new addinformation("Book Number","Inventory Number",7); } else if(change.getSelectedIndex()==2){ ta.append("-->Modify the date to return/n"); addinformation a1=new addinformation("Book Number","Student Student Number","Date to return",8); } change.setSelectedItem("Please select the operation"); if(query.getSelectedIndex()==1){ ta.append("-->Query by book title/n"); addinformation a1=new addinformation("Book Name",9); } else if(query.getSelectedIndex()==2){ ta.append("-->Query by book number/n"); addinformation a1=new addinformation("Book number",10); } else if(query.getSelectedIndex()==3){ ta.append("-->Query student borrowing records/n"); addinformation a1=new addinformation("Student student student number",11); } else if(query.getSelectedIndex()==4){ ta.append("-->Query student information/n"); addinformation a1=new addinformation("Student student number",12); } query.setSelectedItem("Please select the operation"); if(show.getSelectedIndex()==1){ ta.append("-->Show all collection records/n"); try{ rst=stmt.executeQuery("SELECT * FROM book"); rst.first(); ta.append("------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ta.append("/t"+id+"/t"+name+"/t"+num+"/n"); while(rst.next()){ id=rsst.getInt(1); name=rsst.getString(2); num=rsst.getInt(3); ta.append("/t"+id+"/t"+name+"/t"+num+"/n"); }//After execution, the cursor points to the last position of the last line, rst.first(); ta.append("---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ta.append("-->Show book borrowing record/n"); rst1=stmt1.executeQuery("SELECT * FROM bs"); Calendar calendar =new GregorianCalendar(); try{ rst1.first(); ta.append("------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ utilDate = (java.util.Date)calendar.getTime(); utilDate = (java.util.Date)calendar.getTime(); Date newDate = new Date(utilDate.getTime()); ta.append("/tbook number/t student number/t borrow date/t/t should return date/n"); ta.append("/t"+bookid+"/t"+stdid+"/t"+x+"/t"+newDate+"/n"); while(rst1.next()){ bookid=rsst1.getInt(2); stdid=rsst1.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"); }//After execution, the cursor points to the last position of the last line, rst1.first(); ta.append("------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- name=rst2.getString(2); ta.append("/t student number/t student name/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"); }//After execution, the cursor points to the last position of the last line rst2.first(); ta.append("------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ show.setSelectedItem("Please select the action"); ta.setCaretPosition(ta.getText().length()); //Scrollbar remains in the last } catch(Exception e){e.printStackTrace();} } public void showMessage(){ try{ int a=rst.getRow(); ta.append(a+"/n"); rst.first(); ta.append("-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 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"); }//After execution, the cursor points to the last position of the last line rst.absolute(a); ta.append("-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------3.addinformation.java //handle events
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("OK"), quxiao=new JButton("Cancel"); 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, "The book date should be in XXXX-XX-XX format!","Warning",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(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, "If there is a borrowing record, the book information cannot be deleted!","Warning",JOptionPane.WARNING_MESSAGE); } if(m==6){ JOptionPane.showMessageDialog(null, "If there is a borrowing record, the student information cannot be deleted!","Warning",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){ //Add the collection record 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("-->Add success/n"); }catch(Exception x){frameDemo.a.ta.append("-->Insert error/n"); x.printStackTrace();} addinformation.this.dispose(); } if(x==2){ //Add a borrowing record 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();//See if there is this book and whether the inventory is 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();//Someone 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("-->Add success/n"); } else{frameDemo.a.ta.append("-->No student record, no borrowing record/n");} }else{frameDemo.a.ta.append("-->No this book or has been borrowed all/n");} } }catch(Exception x){frameDemo.a.ta.append("-->Insert error/n"); x.printStackTrace();} addinformation.this.dispose(); } if(x==3){ //Add student record 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("-->Add success/n"); }catch(Exception x){frameDemo.a.ta.append("-->Insert error/n"); x.printStackTrace();} addinformation.this.dispose(); } if(x==4){ //Delete the book record 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()){ //There is a book in the borrowing record, JOptionPane.showMessageDialog(null, "There is a borrowing record for the book in the borrowing record!", "Warning",JOptionPane.WARNING_MESSAGE); } else{ //There is no book in the borrowing record, 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("-->Delete error/n"); JOptionPane.showMessageDialog(null, "The book information does not exist!", "Warning",JOptionPane.WARNING_MESSAGE); } else frameDemo.a.ta.append("-->Delete record successfully/n"); } } catch(Exception x){frameDemo.a.ta.append("-->Deletion failed/n");x.printStackTrace();} addinformation.this.dispose(); } if(x==5){ //Delete the book borrowing record 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("-->Delete the borrowing record successfully/n"); } else{ frameDemo.a.ta.append("-->Delete error/n"); JOptionPane.showMessageDialog(null, "This borrowing record does not exist!","Warning",JOptionPane.WARNING_MESSAGE); } }catch(Exception x){frameDemo.a.ta.append("-->Delete error/n");x.printStackTrace();} addinformation.this.dispose(); } if(x==6){ //Delete student record 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()){ //The person is in the borrowing record, JOptionPane.showMessageDialog(null, "The person is in the borrowing record!","Warning",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("-->Delete error/n"); JOptionPane.showMessageDialog(null, "The student record does not exist!", "Warning",JOptionPane.WARNING_MESSAGE); } else frameDemo.a.ta.append("-->Delete record successfully/n"); } } catch(Exception x){frameDemo.a.ta.append("-->Delete error/n");x.printStackTrace();} addinformation.this.dispose(); } if(x==7){ //Modify book inventory record 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("-->Modification error/n"); JOptionPane.showMessageDialog(null, "The book record does not exist!", "Warning", JOptionPane.WARNING_MESSAGE); } else frameDemo.a.ta.append("-->Modification record is successful/n"); } catch(Exception x){frameDemo.a.ta.append("-->Modification error/n"); x.printStackTrace();} addinformation.this.dispose(); } if(x==8){ //Modify the date to be returned 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("-->Modification error/n"); JOptionPane.showMessageDialog(null, "The borrowing record does not exist!", "Warning",JOptionPane.WARNING_MESSAGE); } else frameDemo.a.ta.append("-->Modification record is successful/n"); } catch(Exception x){frameDemo.a.ta.append("-->Modification error/n"); x.printStackTrace();} addinformation.this.dispose(); } if(x==9){ //Query 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("----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- frameDemo.a.ta.append("/t"+rst.getInt(1)+"/t"+rst.getString(2)+"/t"+rst.getInt(3)+"/n"); frameDemo.a.ta.append("------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ x){frameDemo.a.ta.append("-->Query error/n");x.printStackTrace();} addinformation.this.dispose(); } if(x==10){ //Query 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("-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- JOptionPane.showMessageDialog(null, "The book does not exist!","Warning",JOptionPane.WARNING_MESSAGE); } }catch(Exception x){frameDemo.a.ta.append("-->Query error/n");x.printStackTrace();} addinformation.this.dispose(); } if(x==11){ //Query 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("------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ 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("------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 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())); rsst=stmt.executeQuery(); if(rst.next()){ frameDemo.a.ta.append("----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- frameDemo.a.ta.append("/t"+rst.getInt(1)+"/t"+rst.getString(2)+"/n"); frameDemo.a.ta.append("--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- x){frameDemo.a.ta.append("-->Query error/n");x.printStackTrace();} addinformation.this.dispose(); } } if(ae.getSource()==quxiao){ addinformation.this.dispose(); frameDemo.a.ta.append("-->Operation Cancel/n"); } }}The above is all the content of this article. I hope it will be helpful to everyone's learning and I hope everyone will support Wulin.com more.