import
java.sql.
*
;
public class lookup {
public static void main(String[] args)
throws SQLException, ClassNotFoundException {
// 定义了数据库连接串
String dbUrl = " jdbc:odbc:dbjdbc " ;
// 数据库的用户名
String user = " manager " ;
// 数据库的用户口令
String password = " ora912 " ;
// 加载jdbc-odbc bridge驱动程序
Class.forName( " sun.jdbc.odbc.JdbcOdbcDriver " );
// 与url指定的数据源建立连接
Connection c = DriverManager.getConnection(dbUrl, user, password);
// 采用Statement进行查询
Statement s = c.createStatement();
ResultSet r = s.executeQuery( " SELECT empno,name from emp " );
while (r.next()) {
// 打印字段信息
System.out.println(r.getString( " empno " ) + " ,
" + r.getString( " name " ) );
}
// 关闭Statement,其上的ResultSet也将关闭
s.close();
}
}
public class lookup {
public static void main(String[] args)
throws SQLException, ClassNotFoundException {
// 定义了数据库连接串
String dbUrl = " jdbc:odbc:dbjdbc " ;
// 数据库的用户名
String user = " manager " ;
// 数据库的用户口令
String password = " ora912 " ;
// 加载jdbc-odbc bridge驱动程序
Class.forName( " sun.jdbc.odbc.JdbcOdbcDriver " );
// 与url指定的数据源建立连接
Connection c = DriverManager.getConnection(dbUrl, user, password);
// 采用Statement进行查询
Statement s = c.createStatement();
ResultSet r = s.executeQuery( " SELECT empno,name from emp " );
while (r.next()) {
// 打印字段信息
System.out.println(r.getString( " empno " ) + " ,
" + r.getString( " name " ) );
}
// 关闭Statement,其上的ResultSet也将关闭
s.close();
}
}