Java实验8实习报告

实验题1学生信息管理函数。数据库中的信息参考Exp9.1.txt，这些命令用来创建student表，包含学生的学号、姓名、年龄信息。①根据学号，可以查询到学生的姓名和年龄；②给定学生的学号、姓名、年龄，在表中追加一行信息；③给定学生的学号，可以从表中删除该学生的信息；[基本要求]对上面的每一个功能编写相应的函数，并测试。实验题2学生信息管理系统。 学号：学号：姓名：年龄：查询追加删除状态：图3.15学生信息管理系统界面①点击“追加”按钮，可以追加一个学生信息；②点击“查询”按钮和“删除”按钮，可以按照学号查询或者删除一个学生信息；[技术提示]可以使用上一题开发的函数。实验题3向student表连续插入5条记录，使用JDBC事务保证插入操作正确性，若若5条记录插入成功，则操作成功；否则回滚插入操作。package数据库编程;importjava.sql.Connection;importjava.sql.ResultSet;importjava.sql.ResultSetMetaData;importjava.sql.SQLException;publicclassUpdate{publicstaticStringsql=null;privatestaticjava.sql.PreparedStatementstatement;publicUpdate(){}publicstaticvoidSelect(Stringstr,StringselectSQL,Connectionconn){sql=selectSQL;try{statement=conn.prepareStatement(sql);statement.setString(1,str);ResultSetrs=statement.executeQuery();ResultSetMetaDatametaData=rs.getMetaData();System.out.print(metaData.getColumnName(1)+"");System.out.print(metaData.getColumnName(2)+"");System.out.println(metaData.getColumnName(3)+"");while(rs.next()){Stringno=rs.getString(1);Stringname=rs.getString(2);intage=rs.getInt(3);System.out.println(""+no+""+name+""+age);}rs.close();statement.close();}catch(SQLExceptione){//TODOAuto-generatedcatchblocke.printStackTrace();}}}package数据库编程;importjava.sql.Connection;importjava.sql.SQLException;publicclassInsertTest{publicstaticStringsql=null;publicstaticvoidInsert(StringNo,Stringname,intage,StringinsertSQL,Connectionconn){sql=insertSQL;try{java.sql.PreparedStatementstatement=conn.prepareStatement(sql);statement.setString(1,No);statement.setString(2,name);statement.setInt(3,age);statement.executeUpdate();statement.close();}catch(SQLExceptione1){//TODOAuto-generatedcatchblocke1.printStackTrace();}}}package数据库编程;importjava.sql.Connection;importjava.sql.SQLException;publicclassDeleteTest{publicstaticStringsql=null;privatestaticjava.sql.PreparedStatementstatement;publicstaticvoidDelete(StringNo,StringdeleteSQL,Connectionconn){sql=deleteSQL;sql="deletefromstudentwhereSno=?";try{statement=conn.prepareStatement(sql);statement.setString(1,No);statement.executeUpdate();statement.close();}catch(SQLExceptione){//TODOAuto-generatedcatchblocke.printStackTrace();}}}package数据库编程;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.SQLException;importjava.util.Scanner;import数据库编程.Update;publicclassStudent{staticStringsql;publicstaticConnectioncon;publicStudent(){ try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); } catch(ClassNotFoundExceptione){ System.out.print(e); }try{con=DriverManager.getConnection("jdbc:odbc:star","","");}catch(SQLExceptione){e.printStackTrace();}}publicstaticvoidmain(String[]args){StudentstuInfoMan=newStudent();sql="select*fromstudentwhereSno=?";Scannerscan=newScanner(System.in);System.out.println("请输入你要查询的学生的学号");StringNo=scan.nextLine();Update.Select(No,sql,con);//查询System.out.println("输入要插入的学号");No=scan.next();System.out.println("输入要插入的姓名");Stringname=scan.next();System.out.println("输入要插入的年龄");intage=scan.nextInt();sql="insertintostudent(Sno,Sname,Sage)values(?,?,?)";Insert.Insert(No,name,age,sql,con);sql="deletefromstudentwhereSno=?";System.out.println("输入要删除的学号");No=scan.next();Delete.Delete(No,sql,con);try{con.close();}catch(SQLExceptione){//TODOAuto-generatedcatchblocke.printStackTrace();}}}2package数据库编程;importjavax.swing.JFrame;importjava.awt.event.ActionEvent;importjava.awt.event.ActionListener;importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.sql.Statement;importjavax.swing.*;importjava.sql.*;importcom.sun.corba.se.pept.transport.Connection;publicclassStudentTestextendsJFrame{ privatestaticfinallongserialVersionUID=1L; Stringid; Stringname; intage; staticConnectioncn=null; staticStatementstate=null; staticJTextFieldtext1; staticJTextFieldtext2; staticJTextFieldtext3; publicStudentTest() { super(); getContentPane().setLayout(null); setTitle("学生信息管理系统"); setBounds(300,200,400,300); setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); setVisible(true); JLabellabel1=newJLabel("学号："); JLabellabel2=newJLabel("姓名："); JLabellabel3=newJLabel("年龄："); label1.setBounds(20,20,80,40); getContentPane().add(label1); label2.setBounds(20,80,80,40); getContentPane().add(label2); label3.setBounds(20,140,80,40); getContentPane().add(label3); text1=newJTextField(); text2=newJTextField(); text3=newJTextField(); text1.setBounds(90,30,150,30); getContentPane().add(text1); text2.setBounds(90,90,150,30); getContentPane().add(text2); text3.setBounds(90,150,150,30); getContentPane().add(text3); JButtonb1=newJButton("追加"); JButtonb2=newJButton("查询"); JButtonb3=newJButton("删除"); b1.setBounds(250,30,100,30); getContentPane().add(b1); b2.setBounds(250,90,100,30); getContentPane().add(b2); b3.setBounds(250,150,100,30); getContentPane().add(b3); b1.addActionListener(newadd1()); b2.addActionListener(newselect()); b3.addActionListener(newdelete()); setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); } classadd1implementsActionListener { publicvoidactionPerformed(ActionEventarg0) { id=text1.getText(); name=text2.getText(); age=Integer.parseInt(text3.getText()); Stringsql="insertintostudentvalues('"+id+"','"+name+"','"+age+"');"; try{ state.executeUpdate(sql); newJdbc(); }catch(SQLExceptione){ e.printStackTrace(); } } } classselectimplementsActionListener { publicvoidactionPerformed(ActionEventq) { try{ id=text1.getText(); ResultSetrs=state.executeQuery("select*fromstudentwhereid='"+id+"'"); while(rs.next()) { Stringname1=rs.getString("name"); intage1=rs.getInt("age"); System.out.println(""+name1+""+age1); text2.setText(name1); text3.setText(age1+""); } } catch(SQLExceptione){ e.printStackTrace(); } } } classdeleteimplementsActionListener { publicvoidactionPerformed(ActionEventw) { id=text1.getText(); Stringsq="deletefromstudentwhereid='"+id+"'"; try{ state.executeUpdate(sq); newJdbc(); }catch(SQLExceptione){ e.printStackTrace(); } } } publicstaticvoidmain(String[]args) { StudentTesttest=newStudentTest(); test.setVisible(true); try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); }catch(ClassNotFoundExceptione){ System.out.print(e); try{ cn=(Connection)DriverManager.getConnection("jdbc:odbc:star","",""); state=((java.sql.Connection)cn).createStatement(); } catch(SQLExceptione1){ System.out.println(e1); } }}}classJdbcextendsJFrame{ privatestaticfinallongserialVersionUID=1L; publicJdbc() { super(); setBounds(400,200,400,400); getContentPane().setLayout(null); setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); setVisible(true); JLabellab=newJLabel(); lab.setText("一行受影响"); this.getContentPane().add(lab); }}3．package数据库编程;importjava.sql.*;publicclassTest3{Connectioncon;PreparedStatementrs;try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}catch(ClassNotFoundExceptione){System.out.print(e);}publicTest3()throwsSQLException{con=DriverManager.getConnection("jdbc:odbc:star","","");}publicvoidclose(){ try{ rs.close(); con.close(); }catch(SQLExceptione){ System.out.println("errorinclose!"); System.out.println(e); } return; }publicvoidinsert(String[][]info){Stringt="insertintostudentvalues(?,?,?)";try{rs=con.prepareStatement(t);rs.clearBatch();for(inti=0;i<info.le