dbconnection.java

来自「博克系统,struts+hibernate+dao模式」· Java 代码 · 共 99 行

package org.y2t12.common;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
/**
 * 连接数据库工具类
 * @author Administrator
 *
 */
public class DBConnection {

	private static Connection con = null;

	private static final String DATABASE_DRIVER_NAME = "com.microsoft.jdbc.sqlserver.SQLServerDriver";

	private static final String DATABASE_URL = "jdbc:microsoft:sqlserver://127.0.0.1:1433;databaseName=bolg";

	private static final String USER_NAME = "sa";

	private static final String USER_PASSWORD = "821023";

	public static Connection getConnection(){
		try {
			Class.forName(DATABASE_DRIVER_NAME);
			con = DriverManager.getConnection(DATABASE_URL,USER_NAME,USER_PASSWORD);
		} catch (ClassNotFoundException e) {
			System.out.println("不能找到类");
			e.printStackTrace();
		} catch (SQLException e) {
			System.out.println("数据库连接失败");
			e.printStackTrace();
		}
		return con;
	}
	
	public static void close(ResultSet rs, Statement st, Connection con) {
		close(rs);
		close(st, con);
	}

	public static void close(Statement st, Connection con) {
		close(st);
		close(con);

	}

	public static void close(Connection con) {
		if (con != null) {
			try {
				con.close();
				con = null;
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		con = null;
	}

	public static void close(Statement st) {
		if (st != null) {
			try {
				st.close();
				st = null;
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		st = null;
	}

	public static void close(ResultSet rs) {
		if (rs != null) {
			try {
				rs.close();
				rs = null;
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		rs = null;
	}
	
	public static void close(PreparedStatement ps) {
		if (ps != null) {
			try {
				ps.close();
				ps = null;
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		ps = null;
	}
}