＋设为首页 ＋添加到收藏夹
如何用servlet对DB2数据库(数据库服务器在另一台机器上)上的表进行读取
最好贴个代码例子出来
Class.forName("COM.ibm.db2.jdbc.net.DB2Driver");
String url = "jdbc:db2://192.168.0.1:6789/testdb";
String user = "db2admin";
String password = "db2admin";
Connection conn = DriverManager.getConnection(url, user, password);
String sql = "SELECT * FROM test_table";
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
while(rs.next())
{
System.out.println(rs.getString(1));
}
rs.close();
stmt.close();
conn.close();
或者：
Class.forName("COM.ibm.db2.jdbc.app.DB2Driver");
String url = "jdbc:db2:testdb"; //在本地配置了testdb数据库或数据库别名
String user = "db2admin";
String password = "db2admin";
Connection conn = DriverManager.getConnection(url, user, password);
...
