用单例连接oracle数据库

             1
            package
             dao;

             2
             3
            import
             java.sql.Connection;

             4
            import
             java.sql.DriverManager;

             5
            import
             java.sql.SQLException;

             6
             7
            public
            class
             DbUser {

             8
            private String driver="oracle.jdbc.driver.OracleDriver";
 9private String user="scott";
10private String url="jdbc:oracle:thin:@127.0.0.1:1521:orcl";
11private String password="ztoracle";
12privatestatic DbUser dbuser;
13private Connection conn;
14private DbUser(){
15try {
16            Class.forName(driver);
17         } catch (ClassNotFoundException e) {
18// TODO Auto-generated catch block19            e.printStackTrace();
20        }
21    }
22publicstatic DbUser getDbUser(){
23if(dbuser==null){
24             DbUser dbuser=new DbUser();
25        }
26return dbuser;
27    }
28public Connection getconnection(){
2930try {
31                 conn=DriverManager.getConnection(url, user, password);
32             } catch (SQLException e) {
33// TODO Auto-generated catch block34                e.printStackTrace();
35            }
3637return conn;
3839    }
40 }