81,122
社区成员




import java.sql.*;
public class test{
public static void main(String args[]){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection("jdbc:odbc:stu","",""); //连接stu 的数据库,用户名和密码为空
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM user_info");
while(rs.next()){
System.out.print("\t id:" + rs.getInt(1));
System.out.println("\t name:" + rs.getString(2));
}
rs.close();
conn.close();
stmt.close();
}
catch(Exception e){
e.printStackTrace();
}
}
}
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();