Jsp动态网站初步项目 --简单商品浏览界面（工具包DBConnection类）

package com.util;

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

//数据库连接类
public class DBConnection {
    private static String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
                                 
    private static String url = "jdbc:sqlserver://localhost:1433;DatabaseName=itemdb";
                              
    private static String user = "sa";
    private static String password = "20145104011";
    private static Connection con;
    public static Connection getConnection()
    {
    	 try {
			 //1注册数据驱动
			Class.forName(driverName);
			//2建立数据库连接
			con = DriverManager.getConnection(url,user,password);
			//System.out.println("secssful!");
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
    	 return con;
    }
}