resourcemanager.java

用户登录,增加,删除,修改,查询数据库,验证码的使用

package com.hanb.log.jdbc;

import java.sql.Driver;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
/*
 * Author :wang xin
 * on 5-十月-2006
 *
 * Mail:[e-mail]
 *
 */

import java.sql.*;

public class ResourceManager {
    public ResourceManager() {

    }

    private static String JDBC_DRIVER = "com.microsoft.jdbc.sqlserver.SQLServerDriver";

    private static String JDBC_URL =
            "jdbc:microsoft:sqlserver://localhost:10001;DatabaseName=CM;SelectMethod=cursor;";

    private static String JDBC_USER = "sa";

    private static String JDBC_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) {
                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(Statement 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();
        }

    }
}