package com.db;

import java.util.List;
import javax.servlet.http.HttpServletRequest;

public class Register {
        private String message;
    public Register() {
    }

    //注冊用戶
    public boolean register(HttpServletRequest request) {
        String username = request.getParameter("username");
        String password = request.getParameter("password");
        String sex = request.getParameter("sex");
        String email = request.getParameter("email");
        String adress = request.getParameter("adress");

        String sql = "insert into userTable (username,password,sex,email,adress,restime) values"+
                     "('"+username+"','"+password+"','"+sex+"','"+email+"','"+adress+"',getDate())";
        if(this.checkUser(username)){
            this.setMessage("對不起，此用戶已經存在！");
            return false;
        }
        return DataSource.update(sql)>0;

    }
    //檢驗用戶重名
    public boolean checkUser(String username) {
        String sql = "select password from usertable where username='" +username + "'";
        List list = DataSource.queryData(sql);
        return list != null && list.size() > 0;
    }

    public String getMessage() {
        return message;
    }

    public void setMessage(String message) {
        this.message = message;
    }

}