usermanager.java

来自「基于java的图文报表系统的设计与实现,报表的生成一直是企业级应用系统开发时专案」· Java 代码 · 共 100 行

package manager;

import java.sql.Connection;
import java.util.List;

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.ResultSetHandler;
import org.apache.commons.dbutils.handlers.BeanHandler;
import org.apache.commons.dbutils.handlers.BeanListHandler;

import pojo.UserBean;
import dbmaster.DbMaster;

public class UserManager {
	QueryRunner run = new QueryRunner();

	ResultSetHandler rsh = null;

	public List getUsers(String username) {
		Connection con = null;
		List list = null;
		try {
			con = DbMaster.createConn();

			String sql = "select * from userTable where username like '%"
					+ username + "%' and purview <> '1'";
			if (username.trim().length() == 0) {
				sql = "select * from userTable where purview <> '1'";
			}

			rsh = new BeanListHandler(UserBean.class);
			list = (List) run.query(con, sql, rsh);
		} catch (Exception e) {
			System.out.println("getUsers-->" + e);
		} finally {
			try {
				if (con != null) {
					con.close();
				}
			} catch (Exception e1) {
				System.out.println("getUsers-->" + e1);
			}
		}
		return list;
	}

	public UserBean getUserBeanByName(String username) {

		Connection con = null;
		UserBean userBean = new UserBean();
		try {
			con = DbMaster.createConn();

			String sql = "select * from yhb where yhxm like '"
					+ username + "'";

			rsh = new BeanHandler(UserBean.class);
			userBean = (UserBean) run.query(con, sql, rsh);

		} catch (Exception e) {
			System.out.println("getUserBeanByName-->" + e);
		} finally {
			try {
				if (con != null) {
					con.close();
				}
			} catch (Exception e1) {
				System.out.println("getUserBeanByName-->" + e1);
			}
		}
		return userBean;
	}

	public int delUser(String username) {
		int i = 0;
		Connection con = null;
		try {
			con = DbMaster.createConn();

			String sql = "delete from userTable where username like '"
					+ username + "'";
			System.out.println("i = run.update(con, sql)====qian===>"+sql);
			i = run.update(con, sql);
			System.out.println("i = run.update(con, sql)====hou===>"+i);
		} catch (Exception e) {
			System.out.println("delUser  ->" + e);
		} finally {
			try {
				if (con != null) {
					con.close();
				}
			} catch (Exception e2) {
				System.out.println(e2);
			}

		}
		return i;
	}
}