是java的,而不是JB的,网络上有很多。Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@localhost:1521:test";
String user="system";
String password="manager";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement();
String sql="select * from test";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {}
rs.close();
stmt.close();
conn.close();
String url="jdbc:oracle:thin:@localhost:1521:test";
String user="system";
String password="manager";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement();
String sql="select * from test";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {}
rs.close();
stmt.close();
conn.close();
解决方案 »
- hibernate级联删除的问题
- JSF运行时报错 http://java.sun.com/jsp/jstl/core cannot be resolved
- 求Hibernate書,最好是孫衛琴的完整版....
- JSP网页怎样接收到VC客户端WinInet编程SendRequest发送的数据
- 求助。struts2动态结果集不能用
- 在spring中使用hibernate,一个session问题.
- 请问学J2EE看哪本书好
- 江湖救急!!怎么调用已由wdsl文件生成的接口类?怎么把接收到的数据取出来!!!!!
- 用Eclipse启动Tomcat5.0后动行JSP时出现java.lang.NoClassDefFoundError: org/apache/commons/el/ExpressionEvaluatorImpl错误,如何解决?
- 不知道国内的J2EE程序员多不多?
- tomcat5.0.19我安装了,Down之后就不能再启动
- 请教:跑EJB3.0中的例子时遇到的JNDI问题
thin方式
Oracle OCI Thin Type 4 Driver
Class: oracle.jdbc.driver.OracleDriver
URL: jdbc:oracle:thin:@::先到Oracle技术网(http://otn.oracle.com/global/cn/software/tech/java/sqlj_jdbc/index.html)下载Oracle JDBC Drivers,同样地将下载后的zip文件的路径设置在环境变量classpath。然后通过以下的数据库连接类,在本地通过thin方式获得Oracle数据库连接。
*//**
* 在本地获得数据库连接
*/import java.util.*;
import java.sql.*;
import javax.sql.*;
import java.io.*;
import oracle.jdbc.driver.*;
import javax.naming.*;/**
* 通过thin方式获得Oracle数据库连接
*/
//javac OracleThin.java
//java OracleThin
public class OracleThin
{
final static String sDBDriver = "oracle.jdbc.driver.OracleDriver";
private String sConnStr = ""; /**
* @param ip,serviceName
*/
public OracleThin(String ip,String serviceName)
{
sConnStr = "jdbc:oracle:thin:@"+ip+":1521:"+serviceName;
} /**
* 通过thin方式获得Oracle数据库的连接.
* @param userId,password
*/
public Connection connectByJdbc(String userId,String password)
{
Connection conn = null;
try
{
Class.forName(sDBDriver);
conn = DriverManager.getConnection(sConnStr,userId,password);
Statement stmt = conn.createStatement();
ResultSet rsTemp = null;
rsTemp = stmt.executeQuery("Select User,SysDate,RowID From Dual");
while(rsTemp.next())
{
System.out.print(rsTemp.getString("User") + "\t" + rsTemp.getString("SysDate") + "\t" + rsTemp.getString("RowID"));
}
}
catch (Exception e)
{
System.out.println("Error:" + e.getMessage());
e.printStackTrace();
}
return conn;
} public static void main(String[] args)
{
String strServer = "localhost";
String strOracle = "ORCL";
String strUserName = "SYSTEM";
String strPassWord = "YuLimin";
if(args.length == 4)
{
strServer = args[0];
strOracle = args[1];
strUserName = args[2];
strPassWord = args[3];
}
System.out.println("Connect " + strServer + ":" + strOracle);
OracleThin oracleThin = new OracleThin(strServer,strOracle);
oracleThin.connectByJdbc(strUserName ,strPassWord);
}
}//这种方式运用起来比较灵活,简单,具有较强的移植性和适用性。
//只要注意连接字符串"jdbc:oracle:thin:@localhost:1521:ORCL"中具体参数的设置即可。