dbutil.java

来自「java做的个人通讯录 仅供初学者参考！」· Java 代码 · 共 54 行

package Exam;

import java.sql.*;

public class DBUtil {
	public java.sql.Connection getConnection() {
		java.sql.Connection con=null;
		try {
			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
			con=java.sql.DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:1433;databaseName=Exam","sa","");
			
		}
		catch(SQLException sqle) {
			sqle.printStackTrace();
		}
		catch(java.lang.ClassNotFoundException cnfe) {
			cnfe.printStackTrace();
		}
		return con;
		
	}
	public void close(java.sql.PreparedStatement ps,java.sql.ResultSet rs,java.sql.Connection con) {
		try {
			if(rs != null) {
			   rs.close();
		    }
		    if(ps != null) {
			   ps.close();
		    }
		    if(con != null) {
			   con.close();
		    }
		}
		catch(SQLException sqle) {
			sqle.printStackTrace();
		}
		
	}
	public void close(java.sql.PreparedStatement ps,java.sql.Connection con) {
		try {
			
		    if(ps != null) {
			   ps.close();
		    }
		    if(con != null) {
			   con.close();
		    }
		}
		catch(SQLException sqle) {
			sqle.printStackTrace();
		}
	}
}