oracle数据库jdbc连接

来源：互联网发布：电脑怎么共享手机网络编辑：程序博客网时间：2024/06/11 20:52

package jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class JdbcOracle {
private String dbUser = "system";

private String dbPassword = "password";

private String dbUrl = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";

Connection c = null;

Statement st = null;

ResultSet rs = null;

public JdbcOracle() {
  try {
   Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
   c=DriverManager.getConnection(dbUrl, dbUser, dbPassword);
   st=c.createStatement();
  } catch (InstantiationException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  } catch (IllegalAccessException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  } catch (ClassNotFoundException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
}
public ResultSet executeQuery(String sql){
  rs=null;
  try {
   rs=st.executeQuery(sql);
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
  return rs;

}
public void closeConn(){
  try {
   st.close();
   c.close();
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }

}

public static void main(String[] args) {
  JdbcOracle jdbcOracle=new JdbcOracle();
  ResultSet rs=null;
  rs=jdbcOracle.executeQuery("select * from user");
  try {
   while (rs.next()) {
    System.out.println(rs.getString("userName"));
    System.out.println(rs.getString("password"));

   }
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }

}
}