基于Java web的学生管理系统（源码+数据库）.zip

package com.swf.Impl; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import com.swf.Dao.IUserDao; import com.swf.Util.DBUtil; import com.swf.Mode.User; /** * 客户更新 * */ public class UserDaoImpl implements IUserDao { private DBUtil util = new DBUtil(); //@Override public int add(User user) { int count = util .update("insert into tbuser(id,name,sex,age,zzmm,tel,email,dz) values(?,?,?,?,?,?,?,?)", user.getId(),user.getName(),user.getSex(),user.getAge(),user.getZzmm(),user.getTel(), user.getEmail(),user.getDz()); return count; } //@Override public int update(User user) { int count = util .update("update tbuser set id=?,name=?,sex=?,age=?,zzmm=?,tel=?,email=?,dz=?where id=?", user.getId(),user.getName(),user.getSex(),user.getAge(),user.getZzmm(),user.getTel(), user.getEmail(),user.getDz(),user.getId()); return count; } //@Override public int delete(int stdid) { int count = util.update("delete from tbuser where id=?", stdid); return count; } //@Override public List<User> getUserAll() { List<User> userList = new ArrayList<User>(); ResultSet rs = util.query("select * from tbuser"); try { while (rs.next()) { User user = new User(); user.setId(rs.getString("id")); user.setName(rs.getString("name")); user.setSex(rs.getString("sex")); user.setAge(rs.getString("age")); user.setZzmm(rs.getString("zzmm")); user.setTel(rs.getString("tel")); user.setEmail(rs.getString("email")); user.setDz(rs.getString("dz")); userList.add(user); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { util.close(); } return userList; } public List<User> getUserAll(int userid) { List<User> userList = new ArrayList<User>(); ResultSet rs=util.query("select * from tbuser where id=?",userid); try { while (rs.next()) { User user = new User(); user.setId(rs.getString("id")); user.setName(rs.getString("name")); user.setSex(rs.getString("sex")); user.setAge(rs.getString("age")); user.setZzmm(rs.getString("zzmm")); user.setTel(rs.getString("tel")); user.setEmail(rs.getString("email")); user.setDz(rs.getString("dz")); userList.add(user); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { util.close(); } return userList; } // public User getUserByid(int userid) { User user = new User(); ResultSet rs=util.query("select * from tbuser where id=?",userid); try { while (rs.next()) { user.setId(rs.getString("id")); user.setName(rs.getString("name")); user.setSex(rs.getString("sex")); user.setAge(rs.getString("age")); user.setZzmm(rs.getString("zzmm")); user.setTel(rs.getString("tel")); user.setEmail(rs.getString("email")); user.setDz(rs.getString("dz")); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { util.close(); } return user; } public User checkLogin(String uname, String upwd) { // TODO Auto-generated method stub return null; } }