package mypack;

import java.sql.*;

public class SQLQuery {   //處理業(yè)務(wù)邏輯的JavaBean
	public  static boolean validate(String username,String password){//驗(yàn)證用戶密碼是否正確
		boolean bool=false;
		try {
			Class.forName("com.mysql.jdbc.Driver");  //加載數(shù)據(jù)庫(kù)驅(qū)動(dòng)
			//建立與數(shù)據(jù)庫(kù)連接,在數(shù)據(jù)庫(kù)中檢查是否存在用戶名為：username，對(duì)應(yīng)密碼為password的用戶
			Connection conn=DriverManager.getConnection("jdbc:mysql://192.168.1.224:3306/test","root","root");
			//創(chuàng)建Statement對(duì)象
			Statement stmt=(Statement)conn.createStatement();
			//使用SQL語(yǔ)句操作數(shù)據(jù)庫(kù)
			ResultSet rs=(ResultSet)stmt.executeQuery("select*from userinfo where username='"+username+"'and password='"+password+"'");
			if(rs.next()) bool=true;
			else bool=false;
		} catch (Exception e) {
			e.printStackTrace();
		}
		return bool;
	}
	
	public static Userinfo userinfoQuery(String username){//返回用戶信息
		Userinfo ui=new Userinfo();//創(chuàng)建Userinfo對(duì)象，來(lái)保存從數(shù)據(jù)庫(kù)中獲取 的用戶信息
		try {
			Class.forName("com.mysql.jdbc.Driver");
			Connection conn=DriverManager.getConnection("jdbc:mysql://192.168.1.224:3306/test","root","root");
			Statement stmt=(Statement)conn.createStatement();
			ResultSet rs=(ResultSet)stmt.executeQuery("select*from userinfo where username='"+username+"'");
			while(rs.next()){
				ui.setName(rs.getString(2));
				ui.setAge(rs.getInt(4));
				ui.setGender(rs.getString(5));
				ui.setEmail(rs.getString(6));
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
		
		return ui;
				
	}

}