java jdbc连接数据库

// 连接驱动    sqlserver
String DRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
//     服务器
String URL = "jdbc:sqlserver://localhost:1433;DatabaseName=数据库"; 
// 用户名  
    String USERNAME = "sa";  帐号
    // 密码  

    String PASSWORD = "sa";   密码

---------------------------------------------------------------------------------------------------------------------------------------------------------------------

// 连接驱动    mysql

String url = "jdbc:mysql://localhost/数据库?useUnicode=true&characterEncoding=utf-8";  
    String name = "com.mysql.jdbc.Driver";  
    String user = "root";  
    String password = "root"; 

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

String sql="";//sql语句
    try{
    ps = baseDao.loadConnection(name,url,user,password,sql);//连接数据库的对应参数 
    rs = ps.executeQuery();//执行语句，得到结果集  
    while (rs.next()) {  //赋值
//     ChargeFeeItem chargeFeeItem=new ChargeFeeItem();
//     chargeFeeItem.setActualAmount(rs.getString(1));
//     chargeFeeItem.setFeeItemOfSecID(rs.getString(2));
//     chargeFeeItems.add(chargeFeeItem);
    }
    baseDao.close();//关闭
} catch (Exception e) {
}

-----------------------------------------------------------------------------------------------------------------------------------------------------

public class BaseDao {
public PreparedStatement pst = null;  
    static Connection conn = null;  
    static ResultSet rs = null;  
    public PreparedStatement loadConnection(String DRIVER,String URL,String USERNAME,String PASSWORD,String sql){  
    try {  
    // 加载驱动  
    Class.forName(DRIVER);  
    try {
conn = DriverManager.getConnection(URL, USERNAME, PASSWORD);
pst = conn.prepareStatement(sql);//准备执行语句  
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}//获取连接  
    } catch (ClassNotFoundException e) {  
    e.printStackTrace();  
    }  
    return pst;
    }  
    /* 
     * 关闭数据库连接，注意关闭的顺序 
     */  
    public void close() throws SQLException {  
    try {
    if(rs != null) rs.close();
    if(pst != null) pst.close();
    if(conn != null) conn.close();
} catch (Exception e2) {
e2.printStackTrace();
    }
    }  
}