SQLServer数据库连接（二）

属性文件连接数据库

public class DBConnection {
?private static ReadProperties readPro = null;

?// 加载驱动
?static {
??try {
???readPro = ReadProperties.getInstance();
???Class.forName(readPro.getProperty("driver"));
??} catch (ClassNotFoundException e) {
???e.printStackTrace();
??}
?}

?// 连接数据库
?public Connection getConnection() throws SQLException {
??return DriverManager.getConnection(readPro.getProperty("url"),readPro
????.getProperty("username"),readPro.getProperty("password"));
?}
?
?// 查询方法
?public Result excuteQuery(Connection con,String sql,Object[] params)
???throws SQLException {
??Result r = null;
??PreparedStatement pstmt = null;
??ResultSet rs = null;
??try {
???pstmt = con.prepareStatement(sql);
???for (int i = 0; i < params.length; i++) {
????pstmt.setObject(i + 1,params[i]);
???}
???rs = pstmt.executeQuery();
???r = ResultSupport.toResult(rs);
??} finally {
???pstmt.close();
???con.close();
??}
??return r;
?}

?// 增删改方法?public int excuteUpdate(Connection con,Object[] params)???throws SQLException {??int num = 0;??PreparedStatement pstmt = con.prepareStatement(sql);??for (int i = 0; i < params.length; i++) {???pstmt.setObject(i + 1,params[i]);??}??num = pstmt.executeUpdate();??pstmt.close();??con.close();??return num;?}}

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!