daoutil.java

网上书店 。根据对网上书店系统的需求分析

package dao;

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

public class DaoUtil {

	//得到连接
	static final String url = "jdbc:sqlserver://127.0.0.1:1433;databasename=BookShop";

	static
	{
		//加载驱动
		try {
			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
	}
	
	/**
	 * 获取连接
	 * @return
	 * @throws SQLException
	 */
	public static Connection getConnection() throws SQLException
	{
		return DriverManager.getConnection(url, "sa", "accp");
	}
	
	/**
	 * 关闭连接
	 * @param conn
	 */
	public static void closeConnection(Connection conn)
	{
		if( conn==null )
			return;
		
		try {
			conn.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	
	public static void main(String[] args) throws SQLException {
		Connection conn = DaoUtil.getConnection();
		if(conn!=null)
		{
			System.out.println("连接成功！");
			DaoUtil.closeConnection(conn);
		}
	}
}