import java.io.*;
import java.sql.*;
import java.util.*;public class JDBCtest{
public static void main(String args[]){
//上面两个括号 Vector drivers = new Vector();
Connection con;
String driverClassName = "oracle.jdbc.driver.OracleDriver";
String URL = "jdbc:oracle:thin:@172.16.58.160:1521:orc1";
String user = "test2";
String password = "test2";
try { //注册数据库驱动
Driver driver = (Driver)Class.forName(driverClassName).newInstance();
DriverManager.registerDriver(driver);
drivers.addElement(driver);
System.out.println("Registered JDBC driver " + driverClassName);
}
catch (Exception e) {
System.out.println("Can't register JDBC driver: " +
driverClassName + ", Exception: " + e);
}
try { //创建连接
if (user == null) {
con = DriverManager.getConnection(URL);
}
else {
con = DriverManager.getConnection(URL,user,password);
}
System.out.println("Created a new connection in pool " + user);
String sql = "select * from sms_mo";
Statement stmt = null;
for(int i=0; i<1000;i++){
System.out.println("i="+i);
Statement stmtT = con.createStatement();
stmtT.close();
System.gc();
}
ResultSet rs=stmt.executeQuery(sql);
rs.next();
System.out.println(rs.getString("ID").trim());
}
catch (SQLException e) {
System.out.println("Can't create a new connection for " + URL);
}
finally{
}
//下面两个括号
}
}
import java.sql.*;
import java.util.*;public class JDBCtest{
public static void main(String args[]){
//上面两个括号 Vector drivers = new Vector();
Connection con;
String driverClassName = "oracle.jdbc.driver.OracleDriver";
String URL = "jdbc:oracle:thin:@172.16.58.160:1521:orc1";
String user = "test2";
String password = "test2";
try { //注册数据库驱动
Driver driver = (Driver)Class.forName(driverClassName).newInstance();
DriverManager.registerDriver(driver);
drivers.addElement(driver);
System.out.println("Registered JDBC driver " + driverClassName);
}
catch (Exception e) {
System.out.println("Can't register JDBC driver: " +
driverClassName + ", Exception: " + e);
}
try { //创建连接
if (user == null) {
con = DriverManager.getConnection(URL);
}
else {
con = DriverManager.getConnection(URL,user,password);
}
System.out.println("Created a new connection in pool " + user);
String sql = "select * from sms_mo";
Statement stmt = null;
for(int i=0; i<1000;i++){
System.out.println("i="+i);
Statement stmtT = con.createStatement();
stmtT.close();
System.gc();
}
ResultSet rs=stmt.executeQuery(sql);
rs.next();
System.out.println(rs.getString("ID").trim());
}
catch (SQLException e) {
System.out.println("Can't create a new connection for " + URL);
}
finally{
}
//下面两个括号
}
}
解决方案 »
- 数据源与连接池 java.lang.ClassCastException
- 如何限制线程的数量?
- 使用ireport导出excel时的怪问题:提示文件丢失或损坏
- ibatis删除数据后读取出错!!
- eclipse下如何导入tomcat源码?
- 讨论一下2007年值得学习的框架!!!
- 做前段输入检验,用JS和Struts Validator的利弊,请大家谈谈
- SVNKIT 多次执行repository.getDir()报错svn:E175002:connection refused by the server
- 各位高手请回答:能否实现,从不同的机子,不通的数据库里提取数据到jsp页面.请指点,谢谢各位!
- 我用的是springmvc框架,为什么在tomcat 的server.xml里面设置了URIEncoding="UTF-8" get提交时还是会乱码
- 发邮件时为为什么总是这个错,真是陈年老病
- 我想说java技术真烂!
Registered JDBC driver oracle.jdbc.driver.OracleDriverCan't create a new connection for jdbc:oracle:thin:@kkk:1521:pmp问题何在?
自己去搜索吧
到处都是
如果在jbuilder里面,就不用了,设了也没用,jb是不读的。当前项目的
paths/required libraries有这个包就足够
这样吧,你在dos下运行这个程序,把class12放到java-home/jre/lib/ext下
编译,运行,就应该没问题,试试呢这个贴我回答这么多,你一定要结哦
jdbc:oracle:thin:@kkk:1521:pmp 写错了