dbconnection.java

购物车,struts+jdbc 数据库sqlserver2

package org.y2t12.common;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class DBConnection {
	
	private static final String DB_DRIVER = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
	private static final String DB_URL = "jdbc:microsoft:sqlserver://127.0.0.1:1433;databaseName=pubs";
	private static final String DB_USER = "sa";
	private static final String DB_PASSWORD = "821023";
	
	public static Connection getConnection(){
		Connection con = null;
		
		try {
			Class.forName(DB_DRIVER);
			con = DriverManager.getConnection(DB_URL,DB_USER,DB_PASSWORD);
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		
		return con;
	}
	
	public static void close(Connection con){
		if(con != null){
			try {
				con.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
	
	public static void close(Statement st){
		if(st != null){
			try {
				st.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
	
	public static void close(PreparedStatement ps){
		if(ps != null){
			try {
				ps.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
	
	public static void close(ResultSet rs){
		if(rs != null){
			try {
				rs.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
	
	public static void close(Connection con,PreparedStatement ps){
		close(ps);
		close(con);
	}
	
	public static void close(Connection con,Statement st,ResultSet rs){
		close(rs);
		close(st);
		close(con);
	}
	
	public static void close(Connection con,PreparedStatement ps,ResultSet rs){
		close(rs);
		close(ps);
		close(con);
	}
}