dbhelper.java

来自「实现在线的增删改查和一些基本的功能！这是一个简单的网页！」· Java 代码 · 共 53 行

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

public class DBHelper {
	private static String driver="com.microsoft.sqlserver.jdbc.SQLServerDriver";
	private static String url="jdbc:sqlserver://localhost:1433;databasename=Book";
	private static String username="sa";
	private static String password="svse";
	private static Connection conn;
	
	public static Connection getCon(){
		try {
			Class.forName(driver);
			conn = DriverManager.getConnection(url, username,password);
		} catch (ClassNotFoundException e) {
			
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return conn;
	}
	//测试数据库的连接
	public static void main (String[] args ){
		Connection conn=getCon();
		if(conn!=null){
			System.out.println("数据库成功");
		}else{
			System.out.println("数据库连接失败");
		}
	}
	//关闭数据库的连接 
	public static void closeConn(Connection conn){
		if(null!=conn)
		try {
			conn.close();
		} catch (SQLException e) {
			
			e.printStackTrace();
		}
		
	}
		
	
			
	
	

}