Java连接数据库

以下三个文件放在同一个包中，新建一个properties文件 driver=com.microsoft.jdbc.sqlserver.SQLServerDriver url=jdbc:microsoft:sqlserver://topwin-server:1433;DatabaseName=dqsas user=sa password=sa package  jdbc; import  java.util.ResourceBundle; public   class  DBconfig  ... {    static String path="jdbc.dbconfig";    static ResourceBundle r= ResourceBundle.getBundle(path);    public static String getValue(String key)    ...{        return r.getString(key);    }}

 根据properties文件创建连接

package  jdbc; import  java.sql. * ; import  javax.swing. * ; public   class  DBconnection  ... {    public static Connection getCon()...{        String driver=DBconfig.getValue("driver");        String url=DBconfig.getValue("url");        String user=DBconfig.getValue("user");        String password=DBconfig.getValue("password");        Connection con=null;        try ...{            Class.forName(driver);            con = DriverManager.getConnection(url, user, password);        } catch (SQLException ex) ...{            JOptionPane.showMessageDialog(null,"数据库连接失败"+ex.getMessage());        } catch (ClassNotFoundException ex1) ...{            JOptionPane.showMessageDialog(null,"数据库连接失败"+ex1.getMessage());        }        return con;    }}