daouser.java

网上购书系统

package datamanage.dao;

import java.sql.ResultSet;
import java.sql.*;
import datamanage.po.PoUser;
import datamanage.ConnectDatebase;
import datamanage.po.*;


public class DaoUser {
    public DaoUser() {
    }
    public boolean findUser(PoUser user){
        String strsql="select * from t_user where 1=1";
        String strwhere=" ";
        if (user.getUserId()!=null) {
            strwhere=" and userid="+user.getUserId();
        }
        if (user.getUserName()!=null) {
            strwhere=strwhere + " and userName='"+user.getUserName()+"'";
        }
        if (user.getUserPwd()!=null) {
            strwhere=strwhere+" and userPwd='"+user.getUserPwd()+"'";
        }
        strsql=strsql+strwhere;
        ConnectDatebase cdb=new ConnectDatebase();
       ResultSet rs= cdb.query(strsql);
    try {
        if (rs == null || !rs.next()) {
            return false;
        }
    } catch (Exception ex) {
        ex.printStackTrace();
    }
        return true;
    }

    public boolean addUser(PoUser user){
        String name = user.getUserName();
        String pwd = user.getUserPwd();
        String sql = "insert into T_user values('"+name+"','"+pwd+"')";
        ConnectDatebase cdb = new ConnectDatebase();
        if(cdb.add(sql)==false)
        {
            return false;
        }
        return true;
    }
    /*
    public boolean modify(int userid ,POUsers user){
    }
    public boolean delete(int userid){
    }
    public List getAllUser(){
    }*/
}