dbconnection.java

用Java编写的简易的学生信息管理系统,有涉及到java web等

package com.db;

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 Connection conn = null;

	//private static String url = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=E:\\homework\\jsp\\StudentMess.mdb"; 
	private static String url ="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=D:\\chens\\StudentMessage\\StudentMess.mdb";
	private static String user = "sa";

	private static String passw = "";

	public static Connection getConection(String path) {
		try {
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			conn = DriverManager.getConnection("jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ="+path+"\\db\\StudentMess.mdb", user, passw);
		} catch (Exception ex) {
			System.out.println("数据库驱动加载出现错误！");
		}
		return conn;
	}

	public static void closeConnection(Connection conn) {
		try {
			if (!conn.isClosed()) {
				conn.close();
			}
		} catch (SQLException sqle) {
			sqle.printStackTrace();
		}
	}
	public static void closePs(PreparedStatement ps) {
		try {
			if (ps!=null){
				ps.close();
			}
		} catch (SQLException sqle) {
			sqle.printStackTrace();
		}
	}
	public static void closeStat(Statement stat) {
		try {
			if (stat!=null){
				stat.close();
			}
		} catch (SQLException sqle) {
			sqle.printStackTrace();
		}
	}
	public static void closeRs(ResultSet rs) {
		try {
			if (rs!=null){
				rs.close();
			}
		} catch (SQLException sqle) {
			sqle.printStackTrace();
		}
	}
}