javaWeb-连接mysql数据库增删改查（精）(3)

{

return true; }

return false; } }

package com.user.bean; public class UserBean { private int id;

private String name;//电话 private String yx;//院系 private String zy;//专业 private int age;//年龄 private String dh; private String qq; private String sex; public int getId( { return id;

}

public void setId(int id { this.id = id;

}

public String getName( { return name;

}

public void setName(String name { this.name = name;

}

public String getYx( { return yx;

}

public void setYx(String yx { this.yx = yx;

}

public String getZy( { return zy;

}

public void setZy(String zy { this.zy = zy;

}

public int getAge( { return age;

}

public void setAge(int age { this.age = age;

}

public String getDh( { return dh;

}

public void setDh(String dh { this.dh = dh;

}

public String getQq( { return qq;

}

public void setQq(String qq { this.qq = qq;

}

public String getSex( { return sex; }

public void setSex(String sex { this.sex = sex; } }

package com.user.dao; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List;

import com.user.bean.UserBean; import com.util.DBUtils; public class UserDao { private DBUtils dbUtil; /**

* 查询所有的user * @return */

public List getAllUser( {

dbUtil = new DBUtils(;

List list = new ArrayList (; String sql = \ResultSet rs = dbUtil.exceteSQl(sql; try { while(rs.next( { int i =1;

UserBean userBean = new UserBean(; userBean.setId(rs.getInt(i++; userBean.setName(rs.getString(i++; userBean.setYx(rs.getString(i++; userBean.setZy(rs.getString(i++; userBean.setAge(rs.getInt(i++; userBean.setDh(rs.getString(i++; userBean.setQq(rs.getString(i++; userBean.setSex(rs.getString(i++; list.add(userBean; }

} catch (SQLException e { e.printStackTrace(; }finally{ dbUtil.close(; } return list; }

/**

* 根据id查询user * @param id * @return */

public UserBean selectUserById(int id{ dbUtil = new DBUtils(;

UserBean userBean = new UserBean(;

String sql = \ResultSet rs = dbUtil.exceteSQl(sql; try { if(rs.next( { int i =1;

userBean.setId(rs.getInt(i++; userBean.setYx(rs.getString(i++; userBean.setZy(rs.getString(i++; userBean.setAge(rs.getInt(i++; userBean.setDh(rs.getString(i++; userBean.setQq(rs.getString(i++; userBean.setSex(rs.getString(i++; }

} catch (SQLException e { e.printStackTrace(; }