import java.sql.*;
public class OracleDBTest
{
public static void main(String argv[])
{
try {
String driver = "oracle.jdbc.driver.OracleDriver";
Class.forName(driver);
Connection con =
DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:oradb", "scott", "tiger");
//DriverManager.getConnection("jdbc:oracle:thin:@Your_hostname:1521:oradb", "ora1", "oracle");
//Statement stmt = con.createStatement();
PreparedStatement pstmt = con.prepareStatement("select salary from employees");
ResultSet rs = pstmt.executeQuery();
int index = 0;
while (rs.next()){
System.out.println(index + ">>>>> " + rs.getDouble("salary"));
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
}catch (java.sql.SQLException e) {
e.printStackTrace();
} }
}
public class OracleDBTest
{
public static void main(String argv[])
{
try {
String driver = "oracle.jdbc.driver.OracleDriver";
Class.forName(driver);
Connection con =
DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:oradb", "scott", "tiger");
//DriverManager.getConnection("jdbc:oracle:thin:@Your_hostname:1521:oradb", "ora1", "oracle");
//Statement stmt = con.createStatement();
PreparedStatement pstmt = con.prepareStatement("select salary from employees");
ResultSet rs = pstmt.executeQuery();
int index = 0;
while (rs.next()){
System.out.println(index + ">>>>> " + rs.getDouble("salary"));
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
}catch (java.sql.SQLException e) {
e.printStackTrace();
} }
}
解决方案 »
- 求解hibernatesynchronizer 或者其他的代码生成器的推荐
- JTable中如何设置列的行数,及每个单元格宽与长
- struts2 dojo js太大如何压缩?
- 使用xml作为数据源,jsp:Menu类自由扩展菜单项怎么实现
- struts2值传递的问题
- ##Java中如何按照一定的比例来随机选择数组中的一个数##
- EL表达式能取地址传参的值吗
- 编写服务器程序的问题
- 想做易趣一样的平台,没有经验还请指教
- 哪能下载jakarta-struts 1.0.2?
- Initializing, config='org.apache.struts.taglib.html.LocalStrings', returnNull=true?
- 一个关于struts的离奇问题~~在线等
String url="jdbcracle:thin:@localhost:1521rcl";
//orcl为你的数据库的SID
String user="scott";
String password="tiger";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from test";
ResultSet rs=stmt.executeQuery(sql);
rs.close();
stmt.close();
conn.close();
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:199)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:187)
at java.lang.ClassLoader.loadClass(ClassLoader.java:289)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:274)
at java.lang.ClassLoader.loadClass(ClassLoader.java:235)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:141)
at jdbc.main(jdbc.java:8)
没找到
1.2如果是在普通的Application程序中使用,请将上述数据库驱动程序设置在系统变量CLASSPATH中(路径的设置应该具体到.jar文件,而不仅仅只到它的所在目录). [注]以上的设置只要执行其中的一个就可以正常使用.
import java.sql.*;
import java.util.Properties;public class ExecuteQuery{
public static void main( String args[]){
try{
//注册驱动
DriverManager.registerDriver(
new oracle.jdbc.OracleDriver());
//建立一个连接数据库的对象,相当一个用户
Properties prop = new Properties();
prop.setProperty("user", "Hanny_Yang");
prop.setProperty("password", "********");
//连接数据库
Connection conn = DriverManager.getConnection(
"jdbc:oracle:thin:@192.168.0.1:1521:test",
prop);
//建立查询语句
Statement state = conn.createStatement(
);
ResultSet result = state.executeQuery(
"select id, name, age from student order by id"
);
//把结果打印出来
System.out.println("id\tname\tage\t");
while(result.next()){
System.out.print(result.getInt("id") + "\t");
System.out.print(result.getString("name") + "\t");
System.out.println(result.getInt("age") + "\t");
}
//关闭
result.close();
state.close();
conn.close();
}catch(SQLException e){
System.out.println("Error code = " + e.getErrorCode());
System.out.println("Error message = " + e.getMessage());
}
}
}
这两本书结合起来看还可以,(至少我觉得受益匪浅)
java tutorial--JDBC Database Access
《java数据库编程宝典》
java.sql.SQLException: 指定了无效的 Oracle URL
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:285)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:203)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at jdbc.main(jdbc.java:9)
请按任意键继续 . . .
我的程序是这么写的
import java.sql.*;
public class jdbc
{
public static void main(String[] args)
{
try{
String driver = "oracle.jdbc.driver.OracleDriver";
Class.forName(driver);
Connection con = DriverManager.getConnection
("jdbc:oracle::thin:@127.0.0.1:1521:oradb","ora1","oracle");
PreparedStatement pstmt = con.prepareStatement
("select salary from employees");
ResultSet rs = pstmt.executeQuery();
int index = 0;
while(rs.next()){
System.out.println(index+"**********"+rs.getDouble("salary"));
}
}
catch(ClassNotFoundException e){e.printStackTrace();}
catch(java.sql.SQLException e){e.printStackTrace();}
}
}
在这个程序里Connection con = DriverManager.getConnection
("jdbc:oracle::thin:@127.0.0.1:1521:oradb","ora1","oracle");
语句中的oradb代表什么?我不太理解。