Java程序通过JDBC-ODBC连接本地数据库

/* * @作者：刘猛 * @时间：2017.11.12 * @功能：jdbc-odbc桥接使Java程序连接数据库 */package com.jdbc.odbc;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;public class JdbcOdbc {@SuppressWarnings("unused")public static void main(String[] args) {// TODO Auto-generated method stubDatabaseConnection databaseConnection = new DatabaseConnection();}}//定义一个数据库连接类class DatabaseConnection{//创建连接对象Connection ct = null;//创建用于发生sql语句的对象PreparedStatement ps = null;//创建用于接受结果集的对象ResultSet rs = null;//构造函数public DatabaseConnection(){try {//加载驱动Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//得到连接ct = DriverManager.getConnection("jdbc:odbc:student","wtuliumeng","1");//进行crud操作//增加操作ps = ct.prepareStatement("insert into student(Sno,Sname,Ssex) values('1513220146','马云','男')");ps.executeUpdate();//删除操作ps = ct.prepareStatement("delete from student where Sname = '马云'");ps.executeUpdate();//修改操作ps = ct.prepareStatement("update student set Sname = '岳云鹏' where Sname = '鹿晗'");ps.executeUpdate();//查询操作ps = ct.prepareStatement("select * from student");//将结果输入到结果集中rs = ps.executeQuery();//循环输出while(rs.next()){String a = rs.getString(2);String b = rs.getString(3);//输出结果System.out.println(a + " " + b);}} catch (Exception e) {// TODO: handle exceptione.printStackTrace();}finally{try {//关闭资源if(rs != null){rs.close();}if(ps != null){ps.close();}if(ct != null){ct.close();}} catch (Exception e2) {// TODO: handle exceptione2.printStackTrace();}}}}