package com.tcd.service;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import com.tcd.model.userTable;

public class userService {
	/**
	 * ��֤�û��Ƿ�Ϸ�
	 */
	private Connection conn;
	private PreparedStatement pstmt;
	public userService(){
		conn = new com.tcd.conn.conn().getCon();
	}
	public boolean valiUser(userTable user){
		try {
			pstmt = conn.prepareStatement
					("select * from usertable where username=? and password=?");
			pstmt.setString(1, user.getUsername());
			pstmt.setString(2, user.getPassword());
			ResultSet rs = pstmt.executeQuery();
			if(rs.next()){
				return true;
			}else{
				return false;
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return false;
		}
}
	/**
	 * �û�ע�ᣬ��¼�ɹ�����true����¼ʧ�ܷ���false
	 * @param user
	 * @return
	 */
	public boolean addUser(userTable user){
		try {
			pstmt =conn.prepareStatement("insert into userTable (username,password) value(?,?)");
			pstmt.setString(1, user.getUsername());
			pstmt.setString(2, user.getPassword());
			pstmt.executeUpdate();
			return true;
		} catch (SQLException e) {
			e.printStackTrace();
			return false;
		}
	}
}