Java实验8实习报告

实验题1 学生信息管理函数。

数据库中的信息参考Exp9.1.txt，这些命令用来创建student表，包含学生的学号、姓名、年龄信息。

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

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

③给定学生的学号，可以从表中删除该学生的信息；

[基本要求] 对上面的每一个功能编写相应的函数，并测试。

实验题2学生信息管理系统。

图3.15 学生信息管理系统界面

①点击“追加”按钮，可以追加一个学生信息；

②点击“查询”按钮和“删除”按钮，可以按照学号查询或者删除一个学生信息；

[技术提示] 可以使用上一题开发的函数。

实验题3 向student表连续插入5条记录，使用JDBC事务保证插入操作正确性，若若5条记录插入成功，则操作成功；否则回滚插入操作。

package数据库编程;

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.ResultSetMetaData;

import java.sql.SQLException;

public class Update{

public static String sql = null;

private static java.sql.PreparedStatement statement;

public Update(){}

public static void Select(String str,String selectSQL,Connection conn){ sql = selectSQL;

try {

statement = conn.prepareStatement(sql);

statement.setString(1, str);

ResultSet rs = statement.executeQuery();

ResultSetMetaData metaData = rs.getMetaData();

System.out.print(metaData.getColumnName(1)+" ");

System.out.print(metaData.getColumnName(2)+" ");

System.out.println(metaData.getColumnName(3)+" ");

while(rs.next()){

String no = rs.getString(1);

String name = rs.getString(2);

int age = rs.getInt(3);

System.out.println(""+no+" "+name+" "+age);

}

rs.close();

statement.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

}

package数据库编程;

import java.sql.Connection;

import java.sql.SQLException;

public class InsertTest {

public static String sql = null;

public static void Insert(String No,String name,int age,String insertSQL,Connection conn){

sql = insertSQL;

try {

java.sql.PreparedStatement statement = conn.prepareStatement(sql);

statement.setString(1, No);

statement.setString(2, name);

statement.setInt(3, age);

statement.executeUpdate();

statement.close();

} catch (SQLException e1) {

// TODO Auto-generated catch block

e1.printStackTrace();

}

}

}

package数据库编程;

import java.sql.Connection;

import java.sql.SQLException;

public class DeleteTest {

public static

private static statement; public static

sql = deleteSQL;

sql = "delete from student where Sno = ?";

try {

statement = conn.prepareStatement(sql);

statement.setString(1, No);

statement.executeUpdate();

statement.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

}

package数据库编程;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

import java.util.Scanner;

import数据库编程.Update;

public class Student{

static String sql;

public static Connection con;

public Student(){

try{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

}

catch(ClassNotFoundException e){

System.out.print(e);

}

try {

con =DriverManager.getConnection("jdbc:odbc:star","",""); } catch (SQLException e) {

e.printStackTrace();

}

}

public static void main(String[] args) {

Student stuInfoMan = new Student();

sql = "select * from student where Sno = ?";

Scanner scan = new Scanner(System.in);

System.out.println("请输入你要查询的学生的学号"); String No = scan.nextLine();

Update.Select(No,sql,con);

// 查询

System.out.println("输入要插入的学号");

No = scan.next();

System.out.println("输入要插入的姓名");

String name = scan.next();

System.out.println("输入要插入的年龄");

int age = scan.nextInt();

sql ="insert into student(Sno,Sname,Sage) values(?,?,?)"; Insert.Insert(No, name, age, sql, con);

sql = "delete from student where Sno = ?";

System.out.println("输入要删除的学号");

No = scan.next();

Delete.Delete(No, sql, con);

try {

con.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

}2

package数据库编程;

import 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.sql.Statement;

import javax.swing.*;

import java.sql.*;

import com.sun.corba.se.pept.transport.Connection;

public class StudentTest extends JFrame {

private static final long serialVersionUID = 1L;

String id;

String name;

int age;

static Connection cn=null;

static Statement state=null;

static JTextField text1;

static JTextField text2;

static JTextField text3;

public StudentTest()

{

super();

getContentPane().setLayout(null);

setTitle("学生信息管理系统");

setBounds(300,200, 400,300);

setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

setVisible(true);

JLabel label1=new JLabel("学号：");

JLabel label2=new JLabel("姓名：");

JLabel label3=new JLabel("年龄：");

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=new JTextField();

text2=new JTextField();

text3=new JTextField();

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);

JButton b1=new JButton("追加");

JButton b2=new JButton("查询");

JButton b3=new JButton("删除");

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(new add1());

b2.addActionListener(new select());

b3.addActionListener(new delete());

setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

}

class add1 implements ActionListener

{

public void actionPerformed(ActionEvent arg0)

{

id=text1.getText();

name=text2.getText();

age=Integer.parseInt(text3.getText());

String sql="insert into student values('"+id+"', '"+name+"','"+age+"');";

try {

state.executeUpdate(sql);

new Jdbc();

} catch (SQLException e) {

e.printStackTrace();

}

}

}

class select implements ActionListener

{

public void actionPerformed(ActionEvent q)

{

try {

id=text1.getText();

ResultSet rs=state.executeQuery("select * from student where id='"+ id+ "'" );

while(rs.next())

{

String name1=rs.getString("name");

int age1=rs.getInt("age");

System.out.println(" "+name1+" "+age1);

text2.setText(name1);

text3.setText(age1+"");

}

}

catch (SQLException e) {

e.printStackTrace();

}

}

}

class delete implements ActionListener

{

public void actionPerformed(ActionEvent w)

{

id=text1.getText();

String sq="delete from student where id='"+ id+ "'" ;

try {

state.executeUpdate(sq);

new Jdbc();

} catch (SQLException e) {

e.printStackTrace();

}

}

}

public static void main(String[] args)

{

StudentTest test=new StudentTest();

test.setVisible(true);

try {

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

} catch (ClassNotFoundException e) {

System.out.print(e);

try{

cn=(Connection)

DriverManager.getConnection("jdbc:odbc:star","","");

state=((java.sql.Connection) cn).createStatement();

}

catch (SQLException e1) {

System.out.println(e1);

}

}

}

}

class Jdbc extends JFrame

{

private static final long serialVersionUID = 1L;

public Jdbc()

{

super();

setBounds(400,200, 400,400);

getContentPane().setLayout(null);

setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

setVisible(true);

JLabel lab=new JLabel();

lab.setText("一行受影响");

this.getContentPane().add(lab);

}

}

3．

package数据库编程;

import java.sql.*;

public class Test3 {

Connection con;

PreparedStatement rs;

try {

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

} catch (ClassNotFoundException e) {

System.out.print(e);

}

public Test3() throws SQLException {

con = DriverManager.getConnection("jdbc:odbc:star","","");

}

public void close() {

try {

rs.close();

con.close();

} catch (SQLException e) {

System.out.println("error in close!");

System.out.println(e);

}

return;

}

public void insert(String[][] info) {

String t = "insert into student values(?,?,?)";

try {

rs = con.prepareStatement(t);

rs.clearBatch();

for (int i = 0; i < info.length; i++) {

rs.setString(1, info[i][0]);

rs.setString(2, info[i][1]);

rs.setInt(3, Integer.parseInt(info[i][2]));

rs.addBatch();

}

rs.executeBatch();

https://www.360docs.net/doc/7613846825.html,mit();

System.out.println("插入成功");

} catch (SQLException e) {

try {

System.out.println("插入失败，请重新插入");

con.rollback();

} catch (SQLException e1) {

e.printStackTrace();

}

}

}

public static void main(String[] args) {

try {

Test3 test = new Test3();

String[][] info = {

{ "001", "李刚", "20" },

{ "002", "周文颜", "22" },

{ "003", "何丽军", "21" },

{ "004", "李泰然", "21" },

{ "005", "苏海龙", "20" } };

test.insert(info);

test.close();

} catch (SQLException e) {

System.out.println("error!");

System.out.print(e);

}

}

}