数据库与多线程编程.doc

数据库和多线程编程 一、实验目的 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,gefengjie,123); 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(); } }