import java.sql.*;
import oracle.jdbc.driver.OracleDriver;
/**
*创建Oracle的Connection
*@return conn
*/
public class OracleConnection extends MyConnection{
public OracleConnection(){
super();
driver="oracle.jdbc.driver.OracleDriver";
url="jdbc:oracle:thin:@ln-pc:1521:o8ibegin";
user="scott";
passwd="tiger";
}
public Connection createConnection(){
try{
Class.forName(driver).newInstance();
conn=DriverManager.getConnection(url,user,passwd);
System.out.println("Oracle connection successful...");
}catch(Exception e){
System.err.println("OracleConnection.createConnection():"+e.getMessage());
}
return conn;
}
/**内部测试用*/
public static void main(String[] args){
try{
MyConnection my=new OracleConnection();
Connection sqlconn=my.createConnection();
Statement stmt=null;
ResultSet rs=null;
stmt=sqlconn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs=stmt.executeQuery("select * from information");
while(rs.next())
System.out.println(rs.getString(2));
my.closeConnection();
sqlconn.close();
}catch(Exception e){
System.err.println(e.getMessage());
}
}
}偶的一段码!可以用.做为给你的参考!
import oracle.jdbc.driver.OracleDriver;
/**
*创建Oracle的Connection
*@return conn
*/
public class OracleConnection extends MyConnection{
public OracleConnection(){
super();
driver="oracle.jdbc.driver.OracleDriver";
url="jdbc:oracle:thin:@ln-pc:1521:o8ibegin";
user="scott";
passwd="tiger";
}
public Connection createConnection(){
try{
Class.forName(driver).newInstance();
conn=DriverManager.getConnection(url,user,passwd);
System.out.println("Oracle connection successful...");
}catch(Exception e){
System.err.println("OracleConnection.createConnection():"+e.getMessage());
}
return conn;
}
/**内部测试用*/
public static void main(String[] args){
try{
MyConnection my=new OracleConnection();
Connection sqlconn=my.createConnection();
Statement stmt=null;
ResultSet rs=null;
stmt=sqlconn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs=stmt.executeQuery("select * from information");
while(rs.next())
System.out.println(rs.getString(2));
my.closeConnection();
sqlconn.close();
}catch(Exception e){
System.err.println(e.getMessage());
}
}
}偶的一段码!可以用.做为给你的参考!
解决方案 »
- 字符串解析 求助
- 用变量代替类的属性并且调用
- eclipse生成javadoc出错谁知道问题所在
- Thinking in Java中一道最简单的例题
- 请问为什么代码通过了编译,果实却运行不了?
- 关于多线程的小问题(求解)
- 真是摸不到头脑的问题!
- ===有搞LDAP的java高手吗?有问题请教啊!!!!!!!===
- 请问,如何实现并处理JTree节点Multi-Selected?
- 子类调用父类私有方法
- 在JBuilder9里面运行能得到applet画出来的图,但是相应的网页却只有title几个字,没有图,为什么???
- 请交各位java高手,我一直在用vc做项目,现在想学习一下java,请问看些什么样的书最好?
javac -classpath .;%CLASSPATH%;{Oracle的jdbc驱动程序的类路径} xxx.java
这个东西就是oracle的jdbc驱动
找到后放到classpath里就可以编译通过了
Connection con = DriverManager.getConnection("jdbc:oracle:oci8:@你的oracle的SID","scott","tiger");这个是用classes12.jar这个包。
记得把这个包的路径加到classpath环境变量中去。
找到classes12.jar或者classes12.zip,将它放到:C:\j2sdk1.4.2\jre\lib\ext即可:)
祝你成功哦!
String url="jdbc:oracle:thin:@localhost:1521:orcl";//orcl为数据库的SID
String user="dongzi";
String password="yffgd";
return DriverManager.getConnection(url,user,password);http://xieweibbs.topcities.com