Java实验8实习报告

实验题1学生信息管理函数数据库中的信息参考Exp

9.l.txt,这些命令用来创建student表，包含学生的学号、姓名、年龄信息

①根据学号，可以查询到学生的姓名和年龄；

②给定学生的学号、姓名、年龄，在表中追加一行信息；

③给定学生的学号，可以从表中删除该学生的信息；［基本要求］对上面的每一个功能编写相应的函数，并测试实验题2学生信息管理系统状态________________________________________________图

3.15学生信息管理系统界面1点击“追加”按钮，可以追加一个学生信息；2点击“查询”按钮和“删除”按钮，可以按照学号查询或者删除一个学生信息；［技术提示］可以使用上一题开发的函数实验题3向student表连续插入5条记录，使用JDBC事务保证插入操作正确性，若若5条记录插入成功，则操作成功；否则回滚插入操作数据库编程；packageimport java.sqLConnection;import java.sql.ResultSet;import java.sqLResultSetMetaData;import java.sqLSQLException;public classUpdate{public static String sql=null;private staticjava.sql.PreparedStatement statement,public Update{}public staticvoid SelectStringstr,String selectSQL,Connection conn{sql=selectSQL;try{statement=conn.prepareStatements7/;招，sta mectsetStringstr;ResultSet rs=sfafemenf.executeQuery;ResultSetMetaData metaData=rs.getMetaData;H；System.oL/AprintmetaData.getColumnName1+”H；System.OL/AprintmetaData.getColumnName24-n；System.OL/AprintlnmetaData.getColumnName34-”whilers.next{String no=rs.getStringl;String name=rs.getString2;int age=rs.getlnt3;n,,H nSystem.OL/f.println+no++name+”+age;rs.close;statementc\ose;}catch SQLExceptione{//TODO Auto-generated catchblocke.printStackTrace;数据库编程；packageimport java.sql.Connection;import java.sql.SQLException;public classInsertTest{public staticString sql=null;public staticvoid lnsertStringNo,String name,int age,StringinsertSQL,Connection conn{sql=insertSQL;try{java.sql.PreparedStatement statement=conn.prepareStatementSQ/;statement.setString1,No;statement.setString2,name;statement.setlnt3,age;statement.executeUpdateO;statement.close;}catch SQLExceptione1{//TODO Auto-generated catchblocke

1.printStackTrace;数据库编程；packageimport java.sql.Connection;import java.sql.SQLException;public classDeleteTest{public staticString sql=null;private staticiava.sal.PreparedStatement statement;public staticvoid DeleteStringNo,String deleteSQL,Connection conn{sql=deleteSQL;；sql=delete from student where Sno=”try；statement=conn.prepareStatements7/sfafemenf.setString1,No;sfae/77enAexecuteUpdate;statementc\oseQ;}catch SQLExceptione{//TODO Auto-generated catchblocke.printStackTrace;数据库编程；packageimport java.sql.Connection;import java.sql.DriverManager;import java.sqLSQLException;import java.util.Scanner;数据库编程import.Update;public classStudent{staticString sql;public static Connection con;public Student{y{,nClass.forA/ame;catchClassNotFoundException e{System.ot/f.printe;try{n H，H,con=DriverManager.^efConnecf/on jdbc:odbc:star,7;}catch SQLExceptione{e.printStackTrace;public staticvoid mainString[]args{Student stuInfoMan=new Student;；sql=select*from student whereSno=”Scanner scan=new ScannerSystem./77;请输入你要查询的学生的学号System.outprintlnString No=scan.nextLine;Update.Select No,sql,con;//查询输入要插入的学号System.outprintlnNo=scan.next;”,输入要插入的姓名System.printinString name=scan.next;输入要插入的年龄System.outprintlnint age=scan.nextlnt;nsq/=insert intostudentSno,Sname,Sage values,;5Insert./nserfNo,name,age,sql,con;nsql=delete fromstudent whereSno=;输入要删除的学号System,out.printinNo=scan.next;Delete.De/efeNo,sql,con;try{con.close;}catch SQLExceptione{//TODO Auto-generated catchblock e.printStackTrace;}2数据库编程；packageimport javax.swing.JFrame;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sqLStatement;import javax.swing.*;import java.sql.*;import com.sun.corba.se.pept.transport.Connection;public classStudentTest extendsJFrame{private static final long serialVersionUID=1L;String id;String name;int age;staticConnection cn=null;static Statementsfafe=null;static JTextFieldtextl;static JTextFieldtext2;static JTextFieldtext3;public StudentTestsuper;getContentPane.setLayoutnull;学生信息管理系统setTitle setBounds300,200400,300;JsetDefaultCloseOperationJFrame.EX/7^OACCLOSE;setVisibletrue;学号:;JLabel Iabel1=new JLabel“姓名”;JLabel Iabel2=new JLabel年龄”;JLabel Iabel3=new JLabel labell.setBounds20,20,80,40;getContentPane.addlabel1;label

2.setBounds20,80,80,40;getContentPane.addlabel2;Iabel

3.setBounds20,140,80,40;getContentPane.addlabel3;text1=ne\N JTextField;text2=ne\N JTextField;；text3=ne\N JTextFieldfexf/.setBounds90,30,150,30;getContentPane.addfexf7;fexf

2.setBounds90,90,150,30;getContentPane.addexf2;fexf

3.setBounds90,150,150,30;getContentPane.addfexf3;追加”；JButton b1=new JButton查询JButton b2=new JButton删除JButton b3=new JButtonb

1.setBounds250,30,100,30;getContentPane.addb1;b

2.setBounds250,90,100,30;getContentPane.addb2;b

3.setBounds250,150,100,30;getContentPane.addb3;b

1.addActionListenernew add1;b

2.addActionListenernew select;b

3.addActionListenernew delete;setDefaultCloseOperationJFrame.EX/7^0A/_CLOSE;class add1implements ActionListenerpublic void actionPerformedActionEventargO{id=texf/.getText;name=fexf

2.getT ext;age=lnteger.parse/nffexf

3.getText;HString sql=insert intostudent values+id+,+name+J+age+”;;try{sfafe.executellpdatesql;new Jdbc;}catch SQLExceptione{e.printStackTrace;class selectimplements ActionListenerpublic void actionPerformedActionEventqtry id=fexf/.getText;HResultSet rs=sfafe.executeQuery select*fromstudentwhere id=+id+;whilers.nextH nStringnamel=rs.getString name;H nintage1=rs.getlnt age;nSystem.ot/.println+name1++age1;fexf

2.setTextname1;；fexf

3.setTextage1+””catch SQLExceptione{e.printStackTrace;}class deleteimplements ActionListenerpublicvoid actionPerformedActionEventwid=texf/.getText;H,Stringsq=delete fromstudentwhereid=+id+;try{sfafe.executellpdatesq;new Jdbc;}catch SQLExceptione{e.printStackTrace;}public staticvoid mainString[]argsStudentTest test=new StudentTest;test.setVisibletrue;try{nHClass.forA/ame;}catch ClassNotFoundExceptione{System.oi/Aprinte;try{cn=Connectionn nn，，HDriverManager.gefConnecf/on jdbc:odbc:star,7;sfafe=java.sql.Connectioncn.createStatement;}catch SQLExceptione1{System.0L/f.printlne1;}class Jdbcextends JFrameprivatestaticfinallongserialVersionUID=1L;public Jdbcsuper;setBounds400,200,400,400;getContentPane.setLayoutnull;setDefaultCloseOperationJFrame.EX/7^OA/_CLOSE;setVisibletrue;JLabellab=new JLabel;一行受影响lab.setText this.getContentPane.addlab;

3.数据库编程；packageimport java.sql.*;public classTest3{Connection con;PreparedStatement rs;try{nClass.;}catch ClassNotFoundExceptione{System.out.printe;public Test3throws SQLException{n Hnn nHcon=DriverManager.gefConnecf/on jdbc:odbc:star,;5publicvoidclose{tryrs.close;con.close;}catch SQLExceptione{H HSystem.ouf.println errorin close!;System.ot/.printlne;return;}publicvoidinsertString[][]info{nString t=insert intostudent values,;Jtry{rs=con.prepareStatementt;rs.clearBatch;for inti=0;iinfo.length;i++{rs.setString1,info[i]

[0];rs.setString2,info[i]

[1];rs.setlnt3,lnteger.parse/ninfo[i]

[2];rs.addBatch;rs.executeBatch;con.commit;插入成功；System.outprintln}catch SQLExceptione{try{插入失败,请重新插入con.rollback;}catch SQLExceptione1{e.printStackTrace;}public staticvoid mainString[]args{try{Test3test=new Test3;String[][]info={「李刚「{”00120”},，周文颜“，“{“002““22”},「何丽军「「李泰然「，苏海龙，{”00321”},{”00421”},{“005““““20”}};test.insertinfo;test.close;}catch SQLExceptione{H HSystem.ouf.println error!;System.otyf.printe;。