resourcemanager.java

来自「通过Tomcat实现服务器的功能然后进行实现 这是一个个人通讯管理系统」· Java 代码 · 共 69 行

package com.relationinfo.txl.jdbc;

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

public class ResourceManager {
	// 访问数据库的Driver名称
	private static String JDBC_DRIVER = "sun.jdbc.odbc.JdbcOdbcDriver";

	// 访问数据库的URL名称
	private static String JDBC_URL = "jdbc:odbc:addressbook";

	// 访问数据库的用户名
	private static String JDBC_USER = "sa";

	// 访问数据库的密码
	private static String JDBC_PASSWORD = "password";

	private static Driver driver = null;

	public static synchronized Connection getConnection() throws SQLException {
		if (driver == null) {
			try {
				Class jdbcDriverClass = Class.forName(JDBC_DRIVER);
				driver = (Driver) jdbcDriverClass.newInstance();
				DriverManager.registerDriver(driver);
			} catch (Exception e) {
				System.out.println("Failed to initialise JDBC driver");
				e.printStackTrace();
			}
		}

		return DriverManager.getConnection(JDBC_URL, JDBC_USER, JDBC_PASSWORD);
	}

	public static void close(Connection conn) {
		try {
			if (conn != null)
				conn.close();
		} catch (SQLException sqle) {
			sqle.printStackTrace();
		}
	}

	public static void close(PreparedStatement stmt) {
		try {
			if (stmt != null)
				stmt.close();
		} catch (SQLException sqle) {
			sqle.printStackTrace();
		}
	}

	public static void close(ResultSet rs) {
		try {
			if (rs != null)
				rs.close();
		} catch (SQLException sqle) {
			sqle.printStackTrace();
		}

	}

}