package org.manager;

import java.sql.*;

import org.entity.*;
import org.util.*;

/**
 * 文件
 * @说明 
 * @author fei.teng
 * @version 1.0
 * @since
 */
public class UserManager {

	/**
	 * 用户注册
	 * @param user
	 * @return
	 */
	public static boolean register(Users user) {
		boolean isOk = false;
		String sql = "insert into t_users(username,userpass) values(?,?)";
		Connection conn = ConnectionManager.getConnection();
		if (null != conn) {
			PreparedStatement ps = null;
			try {
				ps = conn.prepareStatement(sql);
				ps.setString(1, user.getUsername());
				ps.setString(2, user.getUserpass());
				if (ps.executeUpdate() > 0) {
					isOk = true;
				}
			} catch (SQLException e) {
				e.printStackTrace();
			} finally {
				ConnectionManager.close(ps);
				ConnectionManager.close(conn);
			}
		}
		return isOk;
	}

	/**
	 * 用户登录
	 * @param username
	 * @param userpass
	 * @return
	 */
	public static Users login(String username, String userpass) {
		Users u = null;
		String sql = "select * from t_users where username=? and userpass=?";
		Connection conn = ConnectionManager.getConnection();
		if (null != conn) {
			PreparedStatement ps = null;
			ResultSet rs = null;
			try {
				ps = conn.prepareStatement(sql);
				ps.setString(1, username);
				ps.setString(2, userpass);
				rs = ps.executeQuery();
				if (rs.next()) {
					u = new Users();
					u.setId(rs.getInt("id"));
					u.setUsername(rs.getString("username"));
					u.setUserpass(rs.getString("userpass"));
				}
			} catch (SQLException e) {
				e.printStackTrace();
			} finally {
				ConnectionManager.close(rs);
				ConnectionManager.close(ps);
				ConnectionManager.close(conn);
			}
		}
		return u;
	}
}