logindao.java

分为经理和出纳2个权限

package com.yiboit.cfss.login;

import java.sql.*;

import com.yiboit.cfss.db.ManageConnection;

public class LoginDAO {

	/**
	 * 根据指定的用户名查找用户信息
	 * 
	 * @param username
	 * @return
	 */
	public ShopUser getShopUserById(String username, String password) throws SQLException {
		ShopUser result = null;

		Connection conn = null;

		try {
			conn = ManageConnection.getConnection();
			String sql = "select * from shop_user where username = ? and password = ?";
			PreparedStatement pstmt = conn.prepareStatement(sql);
			pstmt.setString(1, username);
			pstmt.setString(2, password);
			
			ResultSet rs = pstmt.executeQuery();

			if (rs.next()) {
				result = new ShopUser(username, rs.getString("password"), rs
						.getString("flag"));
			} 
		} catch (SQLException e) {
			e.printStackTrace();
			throw e;
		} finally {
			if (conn != null) {
				try {
					conn.close();
				} catch (SQLException e) {
				}
			}
		}

		return result;
	}
}