《实验三java程序中利用jdbc访问数据库》由会员分享,可在线阅读,更多相关《实验三java程序中利用jdbc访问数据库(19页珍藏版)》请在金锄头文库上搜索。
1、实验三 Java程序中利用JDBC访问数据库,计算机科学与技术系,实验目的 1.了解JDBC-ODBC工作原理。 2.JDBC-ODBC桥接驱动程序。 3.掌握数据库的基本编程技术.,实验内容 利用JDBC.ODBC实现数据库的 1.查询 2.插入 3.修改 4.删除 5.生成表 (下载源码就到源码网:),实验步骤,1.在SQL SERVER数据库中建立employ表 Use database_name Create table employ ( no int, name char(10), sex char(2), ) 2.设置 ODBC,查询 Query.java,import java.
2、sql.*; public class Query public static void main(String args) try Class.forName(“sun.jdbc.odbc.JdbcOdbcDriver“); Connection con =DriverManager.getConnection(“jdbc:odbc:mydb1“,“,“); Statement stmt = con.createStatement(); ResultSet rs=stmt.executeQuery(“select * from employee“);,while (rs.next() Sys
3、tem.out.print(“编号t“ +“t“+ rs.getInt(1); System.out.print(“t姓名t“ + rs.getString(2).trim(); System.out.print(“t性别t“ + rs.getString(3).trim(); System.out.println(); rs.close(); stmt.close(); con.close(); catch (Exception e) e.printStackTrace(); ,插入Insert1.java,import java.sql.*; public class Insert1 pu
4、blic static void main(String args) try Class.forName(“sun.jdbc.odbc.JdbcOdbcDriver“); Connection con =DriverManager.getConnection(“jdbc:odbc:mydb1“,“,“); Statement stmt = con.createStatement(); ResultSet rs=stmt.executeQuery(“select * from employee“);,System.out.print(“显示插入前的employee“); System.out.p
5、rintln(); while (rs.next() System.out.print(“编号t“ +“t“+ rs.getInt(1); System.out.print(“t姓名t“ + rs.getString(2).trim(); System.out.print(“t性别t“ + rs.getString(3).trim(); System.out.println(); ,System.out.println(); System.out.println(); System.out.print(“显示插入后的employee“); System.out.println(); Strin
6、g sqlstr=“insert into employee values(23,asb,m)“; stmt.execute(sqlstr); rs=stmt.executeQuery(“select * from employee“); while (rs.next() System.out.print(“编号t“ +“t“+ rs.getInt(1); System.out.print(“t姓名t“ + rs.getString(2).trim(); System.out.print(“t性别t“ + rs.getString(3).trim(); System.out.println()
7、; ,rs.close(); stmt.close(); con.close(); catch (Exception e) e.printStackTrace(); ,修改 Update1.java,import java.sql.*; public class Update1 public static void main(String args) try Class.forName(“sun.jdbc.odbc.JdbcOdbcDriver“); Connection con =DriverManager.getConnection(“jdbc:odbc:mydb1“,“,“); Stat
8、ement stmt = con.createStatement(); ResultSet rs=stmt.executeQuery(“select * from employee“); /显示哺更新前的employee System.out.print(“显示更新前的employee“);,while (rs.next() System.out.print(“编号t“ +“t“+ rs.getInt(1); System.out.print(“t姓名t“ + rs.getString(2).trim(); System.out.print(“t性别t“ + rs.getString(3).t
9、rim(); System.out.println(); ,System.out.println();System.out.println();System.out.println();System.out.println();System.out.println(); String sql = “update employee set no= 3000“ + “where name= AB“; stmt.executeUpdate(sql); sql = “update employee set sex=f “ + “where no = 23“; stmt.executeUpdate(sq
10、l); rs=stmt.executeQuery(“select * from employee“); /显示哺更新后employee System.out.print(“显示更新后的employee“);,while (rs.next() System.out.print(“编号t“ +“t“+ rs.getInt(1); System.out.print(“t姓名t“ + rs.getString(2).trim(); System.out.print(“t性别t“ + rs.getString(3).trim(); System.out.println(); rs.close(); st
11、mt.close(); con.close(); catch (Exception e) e.printStackTrace(); ,4.删除,import java.sql.*; public class Delete public static void main(String args) try Class.forName(“sun.jdbc.odbc.JdbcOdbcDriver“); Connection con =DriverManager.getConnection(“jdbc:odbc:mydb1“,“,“); Statement stmt = con.createStatem
12、ent(); ResultSet rs=stmt.executeQuery(“select * from employee“);,System.out.print(“显示delete前的employee“); System.out.println(); while (rs.next() System.out.print(“编号t“ +“t“+ rs.getInt(1); System.out.print(“t姓名t“ + rs.getString(2).trim(); System.out.print(“t性别t“ + rs.getString(3).trim(); System.out.pr
13、intln(); ,System.out.println(); String sql = “delete from employee where no=1“; stmt.executeUpdate(sql); rs=stmt.executeQuery(“select * from employee“); /显示delete后的 employee System.out.print(“显示delete后的employee“); System.out.println();,while (rs.next() System.out.print(“编号t“ +“t“+ rs.getInt(1); System.out.print(“t姓名t“ + rs.getString(2).trim(); System.out.print(“t性别t“ + rs.getString(3).trim(); System.out.println(); rs.close(); stmt.close(); con.close(); catch (Exception e) e.printStackTrace(); ,写实验报告注意事项,必须写“实验名称”和“实验目的”。 还应写出源程序的编译命令行和执行命令行,如果结果是数字时还应写出执行结果。 写英文字母时注意写清楚大小写。 尽量少写或不写简化字。,