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;
    }
}