dbconn.java

论坛短消息,用户登录、登出 查看个人的短消息 发送短消息 回复短消息 删除短消息

package com.hlfly.conn;

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

public class DBConn {
	
	public static Connection getConn(){
		Connection conn=null;
		try {
			
			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
			conn=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databasename=message","sa","123456");
			
		} catch (Exception e) {
			// TODO: handle exception
			e.printStackTrace();
		}
		return conn;
	}
	
	public static void CloseConn(Connection conn){
		
		if(conn!=null){
			try {
				
				conn.close();
				
			} catch (Exception e) {
				// TODO: handle exception
				e.printStackTrace();
			}
		}
		conn=null;
	}

}