Java实验8实习报告.docx
- 文档编号:28323592
- 上传时间:2023-07-10
- 格式:DOCX
- 页数:10
- 大小:24.99KB
Java实验8实习报告.docx
《Java实验8实习报告.docx》由会员分享,可在线阅读,更多相关《Java实验8实习报告.docx(10页珍藏版)》请在冰豆网上搜索。
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-generatedcatchblock
e.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.(1,No;
statement.setString(2,name;
statement.setInt(3,age;
statement.executeUpdate(;
statement.close(;
}catch(SQLExceptione1{
//TODOAuto-generatedcatchblock
e1.printStackTrace(;
}
}
}
package数据库编程;
importjava.sql.Connection;
importjava.sql.SQLException;
publicclassDeleteTest{
publicstatic
privatestaticstatement;publicstatic
sql=deleteSQL;
sql="deletefromstudentwhereSno=?
";
try{
statement=conn.prepareStatement(sql;
statement.setString(1,No;
statement.executeUpdate(;
statement.close(;
}catch(SQLExceptione{
//TODOAuto-generatedcatchblock
e.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,Sagevalues(?
?
?
";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-generatedcatchblock
e.printStackTrace(;
}
}
}2
package数据库编程;
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=(ConnectionDriverManager.getConnection("jdbc:
odbc:
star","","";state=((java.sql.Connectioncn.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 }}}publicstaticvoidmain(String[]args{try{Test3test=newTest3(;String[][]info={{"001","李刚","20"},{"002","周文颜","22"},{"003","何丽军","21"},{"004","李泰然","21"},{"005","苏海龙","20"}};test.insert(info;test.close(;}catch(SQLExceptione{System.out.println("error! ";System.out.print(e;}}}
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- Java 实验 实习 报告