这是我写的一个学生信息管理系统，使用的时候注意包路径和文件名，最好是导入到Eclipse工程中运行。作者: 姚志华 时间: 2011-10-8 09:22
时间原因,不能给你写一个,但可以给你个相似的,你可以看下
USER类:
public class User {
private int userid;
private String username;
private String password;
private String unum;
private String sex;
private String age;
private String tel;
private String purview;
private String address;
public int getUserid() {
return userid;
}
public void setUserid(int userid) {
this.userid = userid;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public String getUnum() {
return unum;
}
public void setUnum(String unum) {
this.unum = unum;
}
public String getSex() {
return sex;
}
public void setSex(String sex) {
this.sex = sex;
}
public String getAge() {
return age;
}
public void setAge(String age) {
this.age = age;
}
public String getTel() {
return tel;
}
public void setTel(String tel) {
this.tel = tel;
}
public String getPurview() {
return purview;
}
public void setPurview(String purview) {
this.purview = purview;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
userdao接口:
public int updateUserByUserID(User user);
public int addUser(User user);
public User queryUserById(int userid);
public int deleteUser(int id );
public List<User> queryAllUser(String username, int pageNumber, int pageSize);
public int queryAllUserCount(String username);
public int updatePassword(User user);实现类:public User loginUser(User user) {
PreparedStatement pstmt=null;
ResultSet rs=null;
String sql="select * from shop_user where username=? and password=?";
User users=new User();
public int addUser(User user) {
PreparedStatement pstmt=null;
String sql="insert into shop_user values(SEQ_SHOP_USER_USERID.Nextval,?,?,?,?,?,?,?,?)";
int row=0;
int i=0;
public User queryUserById(int userid) {
PreparedStatement pstmt=null;
ResultSet rs=null;
String sql="select * from shop_user where userid=?";
User users=null;
int index=0;
users=new User();
public int deleteUser(int id) {
int row=0;
PreparedStatement pstmt=null;
int i=0;
String sql="delete shop_user where userid=?";
try {
pstmt=ConnectionManager.getConnection().prepareStatement(sql);
pstmt.setInt(++i, id);
row=pstmt.executeUpdate();
public List<User> queryAllUser(String username, int pageNumber, int pageSize) {
List<User> list=new ArrayList<User>();
PreparedStatement pstmt=null;
ResultSet rs=null;
String sql="select t.* from(select a.*,rownum r from(select * from shop_user order by userid desc ) a where 1=1";
StringBuffer sb=new StringBuffer();
sb.append(sql);
if(username!=null){
sb.append(" and username like '%");
sb.append(username);
sb.append("%')");
}else{
sb.append(")");
}
sb.append(" t where r>=");
sb.append(pageSize*(pageNumber-1)+1);
sb.append(" and r<=");
sb.append(pageSize*pageNumber);
public int updatePassword(User user) {
int row=0;
String sql="update shop_user set password=? where username=?";
PreparedStatement pstmt=null;
int i=0;