basedao.java

企业宣传网站后台

package com.westaccp.jsp.company.dao.impl;

import java.sql.*;

public class BaseDao {

	public static final String DRIVER = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
	public static final String URL = "jdbc:microsoft:sqlserver://localhost:1433;databasename=company";
	public static final String USER_NAME = "sa";
	public static final String PASS_WORD = "";
	
public static Connection getCon() {
		Connection con = null;
		
		try {
			Class.forName(DRIVER);
			con = DriverManager.getConnection(URL, USER_NAME, PASS_WORD);
		} catch (Exception ex) {
			ex.printStackTrace();
		}
		
		return con;
	}
	
	public static void closeDB(ResultSet rs, PreparedStatement pstmt, Connection con) {
		if(rs != null) {
			try {
				rs.close();
				rs = null;
			} catch (Exception ex) {
				ex.printStackTrace();
			}
		}
		
		if(pstmt != null) {
			try {
				pstmt.close();
				pstmt = null;
			} catch (Exception ex) {
				ex.printStackTrace();
			}
		}
		
		if(con != null) {
			try {
				con.close();
				con = null;
			} catch (Exception ex) {
				ex.printStackTrace();
			}
		}
	}
}