Java实验8实习报告

Word———Java实验8实习报告;

privatestaticstatement;

publicstaticsql=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,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-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=(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;