ODBC连接数据库代码

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.Statement;

//file name:InsertRecord.java

public class InserRecord {

public static void main(String[] args){

String JDriver=\"sun.jdbc.odbc.Jdbc0dbcDriver\";

String conURL=\"jdbc:odbc:DBTest\";

try{

Class.forName(JDriver);

}

catch(java.lang.ClassNotFoundException e){

System.out.println(\"forName :\"+e.getMessage());

}

try{

Connection con=DriverManager.getConnection(conURL);

Statement stat=con.createStatement();

String r1=\"insert into student values(\"+\"'20050705','张丽','女','1991-9-1','一班','软件',88)\";

String r2=\"insert into student values(\"+\"'20050706','马亮','男','1986-10-1','二班','应用',92)\";

String r3=\"insert into student values(\"+\"'20050707','刘凯','男','1991-9-3','三班','安全',87)\";

stat.executeUpdate(r1);

stat.executeUpdate(r2);

stat.executeUpdate(r3);

ResultSet rs=stat.executeQuery(\"SELECT *FROM student\");

while(rs.next()){

System.out.println(rs.getString(1)+\"\\"+rs.getString(2)+\"\\"

+rs.getString(3)+\"\\"+rs.getString(4)+\"\\"+rs.getString(5)+\"\\"

+rs.getString(6)+\"\\"+rs.getString(7));

}

rs.close();

con.close();

}

catch(SQLException e){

System.out.println(\"SQLException:\"+e.getMessage());

}

}

}