java实现记账本功能_家庭记账本的记账功能实现

packagecom.zzw.dao.Impl;importjava.sql.ResultSet;importjava.sql.SQLException;importcom.zzw.dao.IUserDao;importcom.zzw.entity.Bill;importcom.zzw.entity.User;importcom.zzw.utils.DBUtil;public class UserDaoImpl implementsIUserDao{//注册

public booleanRegister(User user) {

String sql="insert into user(uname,upwd,usex) values(?,?,?)";

Object [] params={user.getUname(),user.getUpwd(),user.getUsex()};returnDBUtil.executeUpdate(sql, params);

}//查询账户是否存在

public booleanisExist(String uname) {return Query(uname)==null? false:true;

}//登录

public booleanLogin(String uname,String upwd) {return Query(uname,upwd)==null? false:true;

}//根据账号查询用户全部信息

publicUser Query(String uname) {

User user= null;

ResultSet rs= null;try{

String sql="select * from user where uname =?";

Object [] params={uname};

rs=DBUtil.executeQuery(sql, params);if(rs.next()) {

String name=rs.getString("uname");

String pwd=rs.getString("upwd");

String sex=rs.getString("usex");

user= newUser(name,pwd,sex);

}

}catch(SQLException e) {

e.printStackTrace();

}catch(Exception e) {

e.printStackTrace();

}finally{try{//先开的后关，后开的先关

if(rs!=null)rs.close();if(DBUtil.pstmt!=null)DBUtil.pstmt.close();if(DBUtil.connection !=null)DBUtil.connection.close();

}catch(SQLException e) {

e.printStackTrace();

}finally{

}

}returnuser;

}//根据账户密码确定是否存在

publicUser Query(String uname,String upwd) {

User user= null;

ResultSet rs= null;try{

String sql="select * from user where uname =? and upwd=?";

Object [] params={uname,upwd};

rs=DBUtil.executeQuery(sql, params);if(rs.next()) {

String name=rs.getString("uname");

String pwd=rs.getString("upwd");

String sex=rs.getString("usex");

user= newUser(name,pwd,sex);

}

}catch(SQLException e) {

e.printStackTrace();

}catch(Exception e) {

e.printStackTrace();

}finally{try{//先开的后关，后开的先关

if(rs!=null)rs.close();if(DBUtil.pstmt!=null)DBUtil.pstmt.close();if(DBUtil.connection !=null)DBUtil.connection.close();

}catch(SQLException e) {

e.printStackTrace();

}finally{

}

}returnuser;

}//记账

public booleanAddBill(Bill bill) {

String sql="insert into bill(btype,bmoney,bdate,bremark) values(?,?,?,?)";

Object [] params={bill.getBtype(),bill.getBmoney(),bill.getBdate(),bill.getBremark()};returnDBUtil.executeUpdate(sql, params);

}

}