1 package com.userInfo.commons;
2
3 import java.sql.Connection;
4 import java.sql.DriverManager;
5 import java.sql.PreparedStatement;
6 import java.sql.ResultSet;
7 import java.sql.SQLException;
8
9 public class BaseDao {
10 private Connection conn=null;
11 private ResultSet rs=null;
12 private PreparedStatement ps=null;
13 public Connection getConn(){
14 try {
15 Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
16
17 conn=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=clubDB","用户名","密码");
18 } catch (SQLException e) {
19 // TODO Auto-generated catch block
20 e.printStackTrace();
21 }
22 catch (ClassNotFoundException e) {
23 // TODO Auto-generated catch block
24 e.printStackTrace();
25 }
26 return conn;
27 }
28 public void Allclose(){
29
30 try {
31 if(rs !=null){
32 rs.close();
33 }
34 if(ps !=null){
35 ps.close();
36 }
37 if(conn !=null){
38 conn.close();
39 }
40 } catch (SQLException e) {
41 // TODO Auto-generated catch block
42 e.printStackTrace();
43 }
44 }
45 public int executeUpdate(String sql,Object []params){
46 int rset=0;
47 this.getConn();
48 try {
49 ps=conn.prepareStatement(sql);
50 if(params !=null && params.length!=0){
51 for (int i = 0; i < params.length; i++) {
52 ps.setObject(i+1,params[i]);
53 }
54 }
55 rset=ps.executeUpdate();
56 } catch (SQLException e) {
57 // TODO Auto-generated catch block
58 e.printStackTrace();
59 }finally{
60 this.Allclose();
61 }
62 return rset;
63 }
64 public ResultSet executeQuery(String sql,Object[]params) throws SQLException{
65 this.getConn();
66 ps=conn.prepareStatement(sql);
67 if(params !=null && params.length !=0){
68 for (int i = 0; i < params.length; i++) {
69 ps.setObject(i+1, params[i]);
70 }
71 }
72 rs=ps.executeQuery();
73 return rs;
74 }
75 }
