数据库和多线程编程

一、实验目的

1.掌握Java概念；

2.掌握eclipse集成开发环境的使用； 3.掌握JDBC-ODBC桥接的方式访问数据库； 4.掌握多线程编程的方法。

二、实验内容及步骤

内容

数据库存放一学生表，有字段sdept-部门，sno-学号，sage-年龄，sname-姓名,通过JDBC-ODBC编程对该表进行增、删、改、查的操作； student.java

import java.sql.*; public class student {

public static void main(String[] args) throws ClassNotFoundException,

SQLException {

Connection con; Statement stmt; ResultSet rs;

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

con=DriverManager.getConnection(\"jdbc:odbc:db1\ stmt=con.createStatement();

rs=stmt.executeQuery(\"select * from stu\"); while(rs.next()){

System.out.println(rs.getString(\"sdept\")+\"

\"+rs.getString(\"sno\")+\" \"+rs.getString(\"sage\")+\" \"+rs.getString(\"sname\"));

}

System.out.println(\"查询完成！\");

Statement stmt1=con.createStatement(); String sql;

sql=\"insert into stu values('外语',30,22,'小蔡')\"; stmt.executeUpdate(sql);

ResultSet rs1=stmt1.executeQuery(\"select * from stu\"); while(rs1.next()){

System.out.println(rs1.getString(\"sdept\")+\"

\"+rs1.getString(\"sno\")+\" \"+rs1.getString(\"sage\")+\" \"+rs1.getString(\"sname\"));

}

System.out.println(\"插入完成！\");

Statement stmt2=con.createStatement(); String sql1;

sql1=\"update stu set sage=17 where sno=22\"; stmt.executeUpdate(sql1);

ResultSet rs2=stmt2.executeQuery(\"select * from stu\"); while(rs2.next()){

System.out.println(rs2.getString(\"sdept\")+\"

\"+rs2.getString(\"sno\")+\" \"+rs2.getString(\"sage\")+\" \"+rs2.getString(\"sname\"));

}

System.out.println(\"更新完成！\");

Statement stmt3=con.createStatement(); String sql2;

sql2=\"delete from stu where sno=26\"; stmt.executeUpdate(sql2);

ResultSet rs3=stmt3.executeQuery(\"select * from stu\"); while(rs3.next()){

System.out.println(rs3.getString(\"sdept\")+\"

\"+rs3.getString(\"sno\")+\" \"+rs3.getString(\"sage\")+\" \"+rs3.getString(\"sname\"));

}

System.out.println(\"删除完成！\"); con.close(); } }