import java.sql.*;public class odbc_test2
{
public static void main(String args[])
{
try
{
DriverManager.registerDriver(new sun.jdbc.odbc.JdbcOdbcDriver());
String url = "jdbc:odbc:TOY"; Connection db = DriverManager.getConnection(url,"username","password");
Statement stmt = db.createStatement();
String stmt_str = "SELECT * FROM MyTestTable";
ResultSet rs = stmt.executeQuery(stmt_str); while (rs.next())
{
... ...
}
rs.close();
stmt.close();
db.close();
}
catch(Exception e)
{
System.out.println(e.getMessage());
e.printStackTrace();
}
} //end main
}
{
public static void main(String args[])
{
try
{
DriverManager.registerDriver(new sun.jdbc.odbc.JdbcOdbcDriver());
String url = "jdbc:odbc:TOY"; Connection db = DriverManager.getConnection(url,"username","password");
Statement stmt = db.createStatement();
String stmt_str = "SELECT * FROM MyTestTable";
ResultSet rs = stmt.executeQuery(stmt_str); while (rs.next())
{
... ...
}
rs.close();
stmt.close();
db.close();
}
catch(Exception e)
{
System.out.println(e.getMessage());
e.printStackTrace();
}
} //end main
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货