posts - 0, comments - 77, trackbacks - 0, articles - 356
  BlogJava :: 首页 :: 新随笔 :: 联系 :: 聚合  :: 管理

java jdbc连接oracle9i

Posted on 2007-08-22 10:41 semovy 阅读(510) 评论(0)  编辑  收藏 所属分类: Oracle数据库方面
/*
 java jdbc连接oracle9i
 设置环境变量classpath=.;E:\oracle\ora90\jdbc\lib\classes12.zip;
*/
import java.sql.*;
public class Demo
{
 public static void main(String[] args)
 {
  try
  {
   DriverManager.registerDriver(new oracle.jdbc.OracleDriver());//取其中一个即可
   Class.forName("oracle.jdbc.driver.OracleDriver");
   
  }catch(Exception e)
  {
   System.out.println("No Driver!");
  }
  try
  {
   String url = "jdbc:oracle:thin:@127.0.0.1:1521:demo";
   String userName = "system";
   String password = "manager";
   Connection conn = DriverManager.getConnection(url,userName,password);
   Statement stmt = conn.createStatement();
   ResultSet rset = stmt.executeQuery("select * from test");
   while(rset.next())
   {
    System.out.println("user_id: "+rset.getString("user_id"));
    System.out.println("user_name: "+rset.getString("user_name"));
    System.out.println("note: "+rset.getString("note"));
   }
  }catch(SQLException e)
  {
   System.out.println("can't access the database!");
  }
 }
}

只有注册用户登录后才能发表评论。


网站导航: