谁有poolman java 连接Oracle10g的实例

2025-05-09 00:40:59
推荐回答(1个)
回答1:

import java.sql.*;

public class TestOracle {
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
String className="oracle.jdbc.OracleDriver";
String url="jdbc:oracle:thin:@chen:1521/orcl";
//jdbc:oralce:thin://@192.168.16.240:1521:orcl
//jdbc:oracle:thin:@chen:1521/orcl
public void link(){

try {
Class.forName(className);
conn=DriverManager.getConnection(url,"chenlong","394401");

System.out.println("Connect Success!!!");
} catch (Exception e) {

e.printStackTrace();
System.out.println("Connect Fail!!!");
}

String sql="select * from test";

try {
stmt=conn.createStatement();

rs=stmt.executeQuery(sql);
ResultSetMetaData rm=rs.getMetaData();
System.out.println("===============");
while(rs.next()){

for(int i=1;i<=rm.getColumnCount();i++){
System.out.print(rs.getObject(i)+" ");
}
System.out.println("\n");
}
System.out.println("\n===============");

} catch (SQLException e) {

e.printStackTrace();
}

}
public static void main(String[] args) {

TestOracle chen=new TestOracle();
chen.link();

}

}

哈哈,过来看看你,虽然扯不上关系啊