JAVA 连接 oracle

最新推荐文章于 2024-10-16 10:13:45 发布

peterpansh

最新推荐文章于 2024-10-16 10:13:45 发布

阅读量635

点赞数

文章标签： java exception oracle string jdbc sql

本文链接：https://blog.csdn.net/czcty/article/details/1598520

版权

import java.sql.*;
class orcl
{
public static void main(String[] args)
{
  System.out.println("Hello World!");
  Connection conn = null ;
  try
  {
   //Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
   Class.forName("oracle.jdbc.driver.OracleDriver");
   //
   conn= DriverManager.getConnection("jdbc:oracle:thin:@210.12.242.12:1521:orcl","sa","111111");
      Statement stmt = conn.createStatement() ;
      String sql = "select * from COLUMNINFO" ;
      ResultSet rs = stmt.executeQuery(sql) ;

   while(rs.next())
    {
    // out.println('ok<br>');
    System.out.println(rs.getString("Ename"));
    }

   //关闭对象
       try {
              rs.close();
              stmt.close();
              conn.close();
            }
            catch (Exception ex) {
            }
//关闭结束

      }
   catch (Exception e)
  {
      System.out.println("error");
  }

}
}