dbhelper.java

房屋出租,jsp房屋出租系统,可以注册添加出租/修改/删除信息,用户可搜索房源

package com.svse.util;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class DBHelper {
	private static final String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
	private static final String url = "jdbc:sqlserver://localhost:1433;databasename=svse";
	private static final String username = "sa";
	private static final String pwd ="sa";
	
	private static Connection conn;
	
	/***********************
	 * @author Denis Zhou
	 * @remark 获得数据连接
	 * @return
	 * @throws ClassNotFoundException
	 * @throws SQLException
	 */
	public static Connection getConn() throws ClassNotFoundException, SQLException
	{
		Class.forName(driver);
		conn = DriverManager.getConnection(url,username,pwd);
		return conn;
	}
	
	/**********************
	 * @author Denis Zhou
	 * @remark 关闭数据连接
	 * @param conn
	 * @throws SQLException
	 */
	public static void closeConn(Connection conn) throws SQLException
	{
		if(null != conn)
		{
			conn.close();
		}
	}
	
	/************************
	 * @author Denis Zhou
	 * @remark 测试数据库连接是否正确
	 * @param args
	 */
	public static void main(String[] args) {
		try {
			conn = DBHelper.getConn();
			if(null != conn)
			{
				System.out.println("OK");
			}
			else
			{
				System.out.println("false");
			}
			DBHelper.closeConn(conn);
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
}