userservice.java

用eclipse3.3和myeclipse6.o开发的简单登录系统用到的数据库为DB2 8.2

package cn.itcareers.service;

import java.sql.*;

import cn.itcareers.database.JdbcBean;
import cn.itcareers.exception.UserIllegalException;
import cn.itcareers.exception.UserNotFoundException;
import cn.itcareers.model.User;

public class UserService {
	public User getUserByName(String username) throws UserNotFoundException {
		User user = null;
		String sql = "select * from user where name='" + username + "'";
		JdbcBean bean = new JdbcBean();
		ResultSet rs = bean.query(sql);
		try {
			if (rs.next()) {
				user = new User();
				user.setName(rs.getString("name"));
				user.setPassword(rs.getString("password"));
				user.setEmail(rs.getString("email"));
			} else {
				throw new UserNotFoundException();
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			bean.close();
		}
		return user;
	}

	public User getUserByNameAndPassword(String username, String userpwd)
			throws UserNotFoundException, UserIllegalException {
		User user = this.getUserByName(username);
		if (!user.getPassword().equals(userpwd)) {
			throw new UserIllegalException();
		} else {
			return user;
		}
	}

}