java为什么不使用odbc_java不用odbc设置数据源连接access编程问题，数据库没有问题，输出不了，求修改...

importjava.sql.Connection;importjava.sql.Statement;importjava.sql.ResultSet;importjava.sql.DriverManager;publicclassMyExample{publicstaticvoidmain(String[]args)throwsExce...

import java.sql.Connection;

import java.sql.Statement;

import java.sql.ResultSet;

import java.sql.DriverManager;

public class MyExample {

public static void main(String []args) throws Exception {

String url="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=book.mdb";

try {

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

Connection conn = DriverManager.getConnection(url);

Statement stmt = conn.createStatement();

String command = "select * from book where bno='1'";

ResultSet rs = stmt.executeQuery(command);

String x1=rs.getString(1);String x2= rs.getString(2);String x3=rs.getString(3);

String x4= rs.getString(4);float x5=rs.getFloat(5);String x6=rs.getString(6);

while(rs.next()) {

System.out.print(" " + x1 + " ");

System.out.print(" " + x2 + " ");

System.out.print(" " + x3 + " ");

System.out.print(" " + x4 + " ");

System.out.print(" " + x5 + " ");

System.out.print(" " + x6 + " ");conn.close();

}

}

catch(Exception e) {

e.printStackTrace();

}

}

}

展开