dbmanager.java

Java实现权限管理

/*
 * DBManager.java
 *
 * Created on 2006年8月29日, 下午7:58
 *
 * To change this template, choose Tools | Options and locate the template under
 * the Source Creation and Management node. Right-click the template and choose
 * Open. You can then make changes to the template in the Source Editor.
 */

package cn.com.wap.role;

import java.sql.*;

/**
 * 
 * @author BENSON
 */
public class DBManager {

	public static void main(String args[]) {
		DBManager db = new DBManager();
		db.getConnection();
		db.getStatement();
	}

	private String classname = "org.gjt.mm.mysql.Driver";

	private String url = "jdbc:mysql://localhost:3306/WAP_TEST?useUnicode=true&characterEncoding=utf8";
	//private String url = "jdbc:mysql://218.206.73.85:3306/WAP_TEST?useUnicode=true&characterEncoding=utf8";

	private String user = "root";

//	private String pwd = "1q2w3e4r";
//	private String pwd = "9518bjjwzx";
	
	private String pwd = "9501";

	private Connection conn = null;

	public Statement stmt = null;

	public ResultSet rs = null;

	private PreparedStatement ps = null;

	private boolean initialized = false;

	/** Creates a new instance of DBManager */
	public DBManager() {
		if (!initialized) {
			createcon();
		}
		if (conn == null) {
			System.out.println("数据库链接失败！");
		}
	}

	public DBManager(String driver, String addr, String name, String pass) {
		classname = driver;
		url = addr;
		user = name;
		pwd = pass;
		if (!initialized) {
			createcon();
			if (conn == null)
				System.out.println("数据库连接失败！！");
		}
	}

	public void createcon() {
		try {
			// System.out.println(classname);
			Class.forName(classname);
			conn = DriverManager.getConnection(url, user, pwd);
			initialized = true;
		} catch (Exception e) {
			e.toString();
			e.printStackTrace();
		}
	}

	public Connection getConnection() {
		return conn;
	}

	public Statement getStatement() {
		try {
			if (conn != null) {
				stmt = conn.createStatement();
			} else {
				System.out.println("建立数据库链接失败");
			}
		} catch (Exception e) {
			e.toString();
			e.printStackTrace();
		}
		return stmt;
	}

	public PreparedStatement getPreparedStatement(String sql) {
		try {
			if (conn != null) {
				ps = conn.prepareStatement(sql);
			} else {
				System.out.println("建立数据库链接失败");
			}
		} catch (Exception e) {
			e.toString();
			e.printStackTrace();
		}
		return ps;
	}

	public ResultSet query(String sql) {
		ResultSet rs = null;
		try {
			if (conn != null) {
				stmt = conn.createStatement();
				rs = stmt.executeQuery(sql);
				System.out.println("OK!");
			} else {
				System.out.println("建立数据库链接失败");
			}
		} catch (Exception e) {
			e.toString();
			e.printStackTrace();
		}
		return rs;
	}

	public void close() {
		try {
			if (stmt != null) {
				stmt.close();
			}
			if (conn != null) {
				conn.close();
			}
			if (ps != null) {
				ps.close();
			}
		} catch (Exception e) {
			e.toString();
			e.printStackTrace();
		}
	}

	public boolean getStmt() {

		try {
			Class.forName("org.gjt.mm.mysql.Driver").newInstance();
			String url = "jdbc:mysql://localhost:3306/WAP_TEST?useUnicode=true&characterEncoding=utf8";
			// String url =
			// "jdbc:mysql://218.206.73.85:3306/WAP_TEST?useUnicode=true&characterEncoding=utf8";
			String user = "root";
			String pwd = "9501";
//			String pwd = "9518bjjwzx";
//			String pwd = "1q2w3e4r";
			conn = DriverManager.getConnection(url, user, pwd);
			stmt = conn.createStatement();
			System.out.println("DataBase.getstmt() is ok!");
			return true;

		} catch (Exception ex) {
			ex.printStackTrace();
			System.out.println("error");
			return false;
		}
	}

	public boolean execsql(String sql) {

		try {
			if (getStmt() == false) {
				return false;
			}

			stmt.executeUpdate(sql);
			// System.out.println("UpdateSQL...Ok!");
			return true;
		} catch (Exception ex) {
			ex.printStackTrace();
			// System.out.println("UpdateSQL...Error!");
			return false;
		}
	}

	public boolean executesqlret(String sql) {
		try {
			if (getStmt() == false)
				return false;
			stmt.executeQuery(sql);
			rs = stmt.executeQuery(sql);
			// System.out.println("QuerySQL...OK!");
			return true;
		} catch (Exception ex) {
			ex.printStackTrace();
			// System.out.println("QuerySQL...Error!");
			return false;
		}
	}
}