//reg.java

//import required classes
import java.sql.*;

public class reg
{
	public int newID = 0;
	public boolean result = false;
	public boolean reg(String username,String password,String confirm,String email)
	{
		try{
			if(!this.checkUser(username))
			return false;
			if(!this.checkPwd(password))
			return false;
			if(!this.verifyPwd(password,confirm))
			return false;
			if(!this.checkEmail(email))
			return false;
			if(!this.userNotExit(username))
			return false;
			this.getNewID();
			this.result = this.register(username,password,confirm,email);
			return this.result;
			}catch(Exception e){
				System.out.println(e.toString());
				return false;
			}
		}//End boolean reg

		public boolean checkUser(String user)
		{
			try{
				if(user.indexOf("'")!=-1)
				{
					System.out.println("姓名中含有非法字符！");
					return false;
				}else
				return true;
				}catch(Exception e){
					System.out.println(e.toString());
					return false;
				}
			}

			public boolean checkPwd(String pwd)
			{
				try{
					if(pwd.indexOf("'")!=-1)
					{
						System.out.println("密碼中含有非法字符！");
						return false;
					}else
					return true;
					}catch(Exception e){
						System.out.println(e.toString());
						return false;
					}
				}

				public boolean verifyPwd(String pwd,String confirm)
				{
					try{
						if(!pwd.equals(confirm))
						{
							System.out.println("兩次輸入的密碼不一致！");
							return false;
						}else
						return true;
						}catch(Exception e){
							System.out.println(e.toString());
							return false;
						}
					}

					public boolean checkEmail(String email)
					{
						try{
							if(email.indexOf("'")!=-1)
							{
								System.out.println("E-mail中含有非法字符！");
								return false;
							}else
							return true;
							}catch(Exception e){
								System.out.println(e.toString());
								return false;
							}
						}

						public boolean userNotExit(String user)
						{
							try{
								DBConn userDBConn = new DBConn();
								userDBConn.executeQuery("select * from tbl_user where name='" + user + "'");
								if(userDBConn.rs_next())
								{
									System.out.println("用戶名已存在，請選擇其它的用戶名！");
									return false;
								}else
								return true;
								}catch(Exception e){
									System.out.println(e.toString());
									return false;
								}
							}

							public int getNewID()
							{
								try{
									DBConn newIDDBConn = new DBConn();
									newIDDBConn.executeQuery("select * from tbl_user order by id desc limit 1");
									if(newIDDBConn.rs_next())
									{
										this.newID = newIDDBConn.rs_getInt("id") + 1;
										System.out.println(this.newID);
										}else{
											this.newID = 1;
										}
										return this.newID;
										}catch(Exception e){
											System.out.println(e.toString());
											return -1;
										}
									}

									public int getID()
									{
										return this.newID;
									}

									public boolean register(String username,String password,String confirm,String email)
									{
										try{
											DBConn regDBConn = new DBConn();
											String strSQL = "insert into tbl_user(id,name,pwd,email) values('" + this.newID +"','" + username + "','" + password + "','" + email + "')";
											regDBConn.execute(strSQL);
											return true;
											}catch(Exception e){
												System.out.println(e.toString());
												return false;
											}
										}

										public static void main(String args[])
										{
											try{

												reg newreg = new reg();

												System.out.println(newreg.reg("sssssssss","ssssss","ssssss","imagebear@163.com"));

												DBConn myconn = new DBConn();
												myconn.executeQuery("select * from tbl_user");
												while(myconn.rs_next())
												{
													System.out.println(myconn.rs_getInt("id") + " " + myconn.rs_getString("name") + " " + myconn.rs_getString("pwd") + " " + myconn.rs_getString("email"));
												}
												System.out.println(newreg.getID());
												}catch(Exception e){
													System.err.println(e.toString());
												}
											}
										};