http://blog.youkuaiyun.com/zhengqiqiqinqin/article/details/9049289
JDBC连接oracle10g数据库-韩顺平SQLHelper类
注意:使用时,大家一定要注意加入oracle的驱动包
- package oracle;
- import java.io.FileInputStream;
- import java.io.IOException;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.PreparedStatement;
- import java.sql.ResultSet;
- import java.sql.Statement;
- import java.util.HashMap;
- import java.util.Map;
- import java.util.Properties;
- public class SQLHelper {
- private static Connection conn;
- private static PreparedStatement ps;
- private static ResultSet rs;
- private static String driver;
- private static String url;
- private static String username;
- private static String password;
- public static void main(String[] args) {
- // 测试
- String sql = "select * from emp";
- ResultSet rst = SQLHelper.executeQuery(sql, null);
- try {
- while(rst.next()){
- System.out.println(rst.getString("ename"));
- }
- } catch (Exception e) {
- e.printStackTrace();
- }finally{
- SQLHelper.close(SQLHelper.getConn(),SQLHelper.getPs(),rst);
- }
- }
- public static Connection getConn() {
- return conn;
- }
- public static PreparedStatement getPs() {
- return ps;
- }
- static{
- try {
- Map<String,String> map = get();
- driver = map.get("driver");
- url = map.get("url");
- username = map.get("username");
- password = map.get("password");
- Class.forName(driver);
- } catch (ClassNotFoundException e) {
- e.printStackTrace();
- }
- }
- //初始化变量
- public static Map get(){
- Properties pp = new Properties();
- FileInputStream fis = null;
- Map<String,String> map = new HashMap<String, String>();
- try {
- fis = new FileInputStream("dbinfor.properties");
- pp.load(fis);
- driver = pp.getProperty("driver");
- url = pp.getProperty("url");
- username = pp.getProperty("username");
- password = pp.getProperty("password");
- map.put("driver", driver);
- map.put("url", url);
- map.put("username", username);
- map.put("password", password);
- } catch (Exception e) {
- e.printStackTrace();
- }
- return map;
- }
- //增删改方法
- public static void executeUpdate(String sql,String []parameters){
- try {
- conn = DriverManager.getConnection(url, username, password);
- ps = conn.prepareStatement(sql);
- if(parameters!=null){
- for(int i=0;i<parameters.length;i++){
- ps.setString(i+1, parameters[i]);
- }
- }
- ps.executeUpdate();
- } catch (Exception e) {
- e.printStackTrace();
- throw new RuntimeException(e.getMessage());
- }finally{
- SQLHelper.close(conn, ps, rs);
- }
- }
- //查询方法
- public static ResultSet executeQuery(String sql,String []parameters){
- try {
- conn = DriverManager.getConnection(url, username, password);
- ps = conn.prepareStatement(sql);
- if(parameters !=null){
- for(int i=0;i<parameters.length;i++){
- ps.setString(i+1, parameters[i]);
- }
- }
- //执行查询
- rs = ps.executeQuery();
- } catch (Exception e) {
- e.printStackTrace();
- throw new RuntimeException(e.getMessage());
- }finally{
- //关闭资源
- //SQLHelper.close(conn, ps, rs);
- }
- return rs;
- }
- //关闭资源
- public static void close(Connection conn,Statement stmt,ResultSet rs){
- if(rs!=null){
- try {
- rs.close();
- } catch (Exception e) {
- e.printStackTrace();
- }
- rs = null;
- }
- if(stmt!=null){
- try {
- stmt.close();
- } catch (Exception e) {
- e.printStackTrace();
- }
- stmt = null;
- }
- if(conn!=null){
- try {
- conn.close();
- } catch (Exception e) {
- e.printStackTrace();
- }
- conn=null;
- }
- }
- }