DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.1.168:1521:orcl", "test", "test");
Statement stmt = conn.createStatement();
ResultSet rset = stmt.executeQuery ("select * from testtab");
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.1.168:1521:orcl", "test", "test");
Statement stmt = conn.createStatement();
ResultSet rset = stmt.executeQuery ("select * from testtab");
jre(1.3)
dbms(oracle8.1.6i)
oracle自带了jdbc驱动程序操作:1.在classpath系统变量中加入jdbc类路经:
classpath=.;oralce安装目录\jdbc\lib\classes111.zip
2.在path系统变量中加入jdbc oci驱动程序路经
path=oralce安装目录\lib
3.在代码中加入代马
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection conn = DriverManager.getConnection("jdbc:oracle:oci8:@你为数据库建立的服务名",你的数据库用户名,密码);
Statement stmt = conn.createStatement();
ResultSet rset = stmt.executeQuery ("select * from testtab");上例中的中文根据实际情况而替换.
如果你这都看不懂,那说明你的技术准备不足,还是先看些书吧