java连接SqlServer的util

觉得写博客可以帮助自己记忆一些东西的。

package edu.cric.zl.jdbc;

import java.sql.*;

public class DBUtils {
	private String dbDriver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
	private String dbUrl = "jdbc:sqlserver://localhost:1433; DatabaseName=dbName";
	private String userName = "sa";
	private String passWord = "hello";
	private java.sql.Connection conn = null;
	private java.sql.Statement stmt = null;
	private java.sql.ResultSet rs = null;

	public DBUtils() {
		try {
			Class.forName(dbDriver);
		} catch (java.lang.ClassNotFoundException e) {
			e.printStackTrace();
		}
	}

	public Connection getConnection() throws java.sql.SQLException {
		if (conn == null || conn.isClosed())
			this.conn = java.sql.DriverManager.getConnection(dbUrl, userName,
					passWord);
		return this.conn;
	}

	public ResultSet excuteQuery(String sqlStr) {
		if (sqlStr == null || sqlStr.equals("")) {
			return null;
		}
		try {
			this.getConnection();
			this.stmt = this.conn.createStatement();
			this.rs = this.stmt.executeQuery(sqlStr);
		} catch (java.sql.SQLException e) {
			e.printStackTrace();
		}

		return this.rs;
	}

	public boolean excuteUpdate(String sqlStr)
	{
		if(sqlStr==null||sqlStr.equals(""))
		{
			return false;
		}		
		try {
			this.getConnection();
			this.stmt = this.conn.createStatement();
			stmt.executeUpdate(sqlStr);
		} catch (java.sql.SQLException e) {
			e.printStackTrace();
			return false;
		}finally{
			try{
				if(this.stmt!=null)
				{
					this.stmt.close();
				}
			}catch(java.sql.SQLException e)
			{
				e.printStackTrace();
			}
			try{
				if(this.conn!=null)
				{
					this.conn.close();
				}
			}catch(java.sql.SQLException e)
			{
				e.printStackTrace();
			}	
		}		
		return true;		
	}
	public boolean executeUpdates(String[] sqlStrs) {
		try {
			this.getConnection();
			this.conn.setAutoCommit(false);
			this.stmt=conn.createStatement();
			for (int i = 0; i < sqlStrs.length; i++) {
				this.stmt.addBatch(sqlStrs[i]);
			}
			stmt.executeBatch();
			this.conn.commit();
			this.conn.setAutoCommit(true);
		} catch (SQLException e) {
			try {
				if (conn != null) {
					conn.rollback();
				}
			} catch (SQLException ex) {
				ex.printStackTrace();
			}
			e.printStackTrace();
			return false;
		} finally {
			try {
				if (stmt != null)
					stmt.close();
			} catch (java.sql.SQLException e) {
				e.printStackTrace();
			}
			try {
				if (conn != null)
					conn.close();
			} catch (java.sql.SQLException e) {
				e.printStackTrace();
			}
		}
		return true;
	}

	
	public void closeStmt(){
		try{
			if(this.stmt!=null)
			{
				this.stmt.close();
			}
		}catch(java.sql.SQLException e)
		{
			e.printStackTrace();
		}
		
	}
	public void closeConnection()
	{
		try{
			if(this.conn!=null)
			{
				this.conn.close();
			}
		}catch(java.sql.SQLException e)
		{
			e.printStackTrace();
		}	
	}
	
}