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);
...
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);
...
解决方案 »
- spring集成memcache启动的问题!!
- datetime类型转存为json数据格式后日期的变中文
- javascript熟练地看看 ... 解决不了郁闷...
- 如何不输入用户名和密码进行登录
- 我一运行APACHE,就提示:the requested operation has failed
- 高分求助!内网建站问题!!
- 请问JSP中的流程控制语句。
- window.form1和document.Form1有什么区别呢??
- 100分求救!!用过eclipse和tomcat的请进!!!
- 为什么我的jdbc for sqlserver2000只能用rs.next(),其他的比如rs.first()等都不好用
- 第一天做JSP,超级水问题~~~~~~~~~~谢谢
- 急!!货币格式转换问题。大家帮我看看。
第二种方法要求连接的客户机上安装配置了DB2的客户端。