java jdbc连接sql server

最新推荐文章于 2024-09-27 00:45:01 发布

weixin_30808575

最新推荐文章于 2024-09-27 00:45:01 发布

阅读量38

点赞数

文章标签： java 数据库

原文链接：http://www.cnblogs.com/kele-ting/archive/2012/10/27/2742122.html

版权

 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 }