connectionmanager.java

来自「一个Java网络登陆数据库连接类」· Java 代码 · 共 73 行

package com.eshop.util;
import java.sql.*;

public class ConnectionManager {
	private static final String DRIVER_CLASS="com.microsoft.jdbc.sqlserver.SQLServerDriver";
	
	private static final String url="jdbc:sqlserver://localhost:1433;databasename=shopping";
	private static final String uid="sa";
	private static final String pwd="123456";
	
	/**
	 * 建立连接
	 * @return
	 */
	public static Connection getConn(){		
		Connection Conn=null;
		try{
			Class.forName(DRIVER_CLASS);
			Conn=DriverManager.getConnection(url,uid,pwd);			
		}catch(Exception e){
			e.printStackTrace();			
		}
		return Conn;
	}
	/**
	 * 关闭连接
	 * @param conn
	 */
	public static void closeConn(Connection conn){
		try {
			if (conn != null && !conn.isClosed()) {
				conn.close();
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
   /**
    * 关闭语句
    * @param pstmt
    */
	public static void closePreparedStatement(PreparedStatement pstmt){
		try{
			if(pstmt!=null){
				pstmt.close();
				pstmt=null;
			}
		}catch(SQLException e){
			e.printStackTrace();
		}
	}
	/**
	 * 关闭结果集
	 * @param rs
	 */
	public static void closeResultSet(ResultSet rs){
		try {
			if (rs != null) {
				rs.close();
				rs = null;
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	public static void main(String [] args){
		ConnectionManager.getConn();
		
		System.out.println("成功");
	}

}