package?Dao;
import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;

import?model.PageBean;
import?model.Account;


public?class?AccntDao?{
	public?ResultSet?userList（Connection?conPageBean?pageBean）throws?Exception{
		String?sql=“select?*?from?[tb_accnt]“;
		PreparedStatement?pstmt=con.prepareStatement（sql）;
		return?pstmt.executeQuery（）;
	}
	
	public?int?userCount（Connection?con）throws?Exception{
		String?sql=“select?count（*）?as?total?from?[tb_accnt]“;
		PreparedStatement?pstmt=con.prepareStatement（sql）;
		ResultSet?rs=pstmt.executeQuery（）;
		if（rs.next（））{
			return?rs.getInt（“total“）;
		}else{
			return?0;
		}
	}
	
	public?int?userDelete（Connection?conString?delId）throws?Exception{
		String?sql=“delete?from?[tb_accnt]?where?id=?“;
		PreparedStatement?pstmt=con.prepareStatement（sql）;
		pstmt.setString（1?delId）;
		return?pstmt.executeUpdate（）;
	}
	
	public?int?userAdd（Connection?conAccount?accnt）throws?Exception{
		String?sql=“insert?into?[tb_accnt]（accNameaccPwdageemailbirthday）?values（?????）“;
		PreparedStatement?pstmt=con.prepareStatement（sql）;
		pstmt.setString（1?accnt.getAccName（））;
		pstmt.setString（2?accnt.getAccPwd（））;
		pstmt.setInt（3?accnt.getAge（））;
		pstmt.setString（4?accnt.getEmail（））;
		pstmt.setString（5?accnt.getBirthday（））;
		return?pstmt.executeUpdate（）;
	}
	
	public?int?userModify（Connection?conAccount?accntString?modId）throws?Exception{
		String?sql=“update?[tb_accnt]set?accName=?accPwd=?age=?email=?birthday=??where?id=?“;
		PreparedStatement?pstmt=con.prepareStatement（sql）;
		pstmt.setString（1?accnt.getAccName（））;
		pstmt.setString（2?accnt.getAccPwd（））;
		pstmt.setInt（3?accnt.getAge（））;
		pstmt.setString（4?accnt.getEmail（））;
		pstmt.setString（5?accnt.getBirthday（））;
		pstmt.setString（6?modId）;
		return?pstmt.executeUpdate（）;
	}?
}