这个是我下的一个代码 有一些看不懂 请教各位大哥ClassPath=.;E:\j2sdk14\lib\tools.jar;E:\oracle\ora90\jdbc\lib\classes12.zip
测试的电脑已经装好Oracle客户端,而且用SQLplus可以连接上。
/*
* This sample shows how to list all the names from the EMP table
*
* It uses the JDBC THIN driver. See the same program in the
* oci8 samples directory to see how to use the other drivers.
*/// You need to import the java.sql package to use JDBC
import java.sql.*;class Test
{
public static void main (String args [])
throws SQLException
{
// Load the Oracle JDBC driver
DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
/* try{
Class.forName("oracle.jdbc.driver.OracleDriver");
}catch(Exception e){
System.out.println("No Driver!");
}
*/
// Connect to the database
// You must put a database name after the @ sign in the connection URL.
// You can use either the fully specified SQL*net syntax or a short cut
// syntax as <host>:<port>:<sid>. The example uses the short cut syntax.
String url = "jdbc:oracle:thin:@172.28.31.85:1521:YIKATONG";
String userName = "scott";
String password = "tiger"; if (args.length > 0) url = args[0];
if (args.length > 1) userName = args[1];
if (args.length > 2) password = args[2];
System.out.println(url);
System.out.println(userName);
System.out.println(password);
Connection conn =
DriverManager.getConnection (url, userName, password); // Create a Statement
Statement stmt = conn.createStatement (); // Select the ENAME column from the EMP table
ResultSet rset = stmt.executeQuery ("select * from Test"); // Iterate through the result and print the employee names
while (rset.next ())
System.out.println (rset.getString (1));
}
}
其中
String url = "jdbc:oracle:thin:@172.28.31.85:1521:YIKATONG";
String userName = "scott";
String password = "tiger";
URL中的IP是不是本机地址?用户名和密码是连接数据库的密码还是连接OracleManagementServer的用户名密码
测试的电脑已经装好Oracle客户端,而且用SQLplus可以连接上。
/*
* This sample shows how to list all the names from the EMP table
*
* It uses the JDBC THIN driver. See the same program in the
* oci8 samples directory to see how to use the other drivers.
*/// You need to import the java.sql package to use JDBC
import java.sql.*;class Test
{
public static void main (String args [])
throws SQLException
{
// Load the Oracle JDBC driver
DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
/* try{
Class.forName("oracle.jdbc.driver.OracleDriver");
}catch(Exception e){
System.out.println("No Driver!");
}
*/
// Connect to the database
// You must put a database name after the @ sign in the connection URL.
// You can use either the fully specified SQL*net syntax or a short cut
// syntax as <host>:<port>:<sid>. The example uses the short cut syntax.
String url = "jdbc:oracle:thin:@172.28.31.85:1521:YIKATONG";
String userName = "scott";
String password = "tiger"; if (args.length > 0) url = args[0];
if (args.length > 1) userName = args[1];
if (args.length > 2) password = args[2];
System.out.println(url);
System.out.println(userName);
System.out.println(password);
Connection conn =
DriverManager.getConnection (url, userName, password); // Create a Statement
Statement stmt = conn.createStatement (); // Select the ENAME column from the EMP table
ResultSet rset = stmt.executeQuery ("select * from Test"); // Iterate through the result and print the employee names
while (rset.next ())
System.out.println (rset.getString (1));
}
}
其中
String url = "jdbc:oracle:thin:@172.28.31.85:1521:YIKATONG";
String userName = "scott";
String password = "tiger";
URL中的IP是不是本机地址?用户名和密码是连接数据库的密码还是连接OracleManagementServer的用户名密码
解决方案 »
- 做个简单小程序遇到的问题,求解决思路
- WEB-INF下可不可以放框架集,可以的话应如何访问到!已经是第三贴了!帮忙@ @!
- 谁有spring in action中文版电子书啊?
- jsp中如何通过超链接传递session值???
- 怎样写java程序打war包
- 很菜的问题!那位能提供一个对首页访问次数计算的程序,在线等,急!只要好使立即结贴!
- 100高分求教 把Servlet作为Web的首页的解决方法 解决就结贴
- tomcat,servlet expert enter
- 写了一个DBTREE的JAVABEAN
- tomcat3.3.1并发进程数如何修改,解决问题马上给高分
- 初学的菜鸟求助BEAN 和 JSP 的连库问题
- 关于jsp中isELIgnored标签的问题
172.28.31.85:主机名--如果是本地可用localhost
YIKATONG:服务(SID)String userName = "scott";
String password = "tiger";
这是pl/sql登陆时的用户名和密码,不是oms的。