dbconnection.java

J2EE客户关系管理系统!!!!!!!!!!!!!!!!!!!!

package com.accp.DB;
import java.sql.*;

public class DBConnection {
	public static Connection getConnection(){
		String st = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
		String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=jb_crm_team0";
		Connection con = null;		
		try {
			Class.forName(st);
			con = DriverManager.getConnection(url,"sa",""); 
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return con;
	}
	
	public static void ConnectionClose(Connection con){
		if(con != null){
			try {
				con.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
}