jsp+servlet+sql2005根据mvc三层模式设计的库存管理

package dao.impl; import comm.BaseDao; import comm.BaseManager; import dao.LoginInfo; import entity.Users; import entity.UsersView; import java.sql.Connection; import java.util.ArrayList; import java.util.List; import java.util.Map; import javax.servlet.jsp.jstl.sql.Result; public class LoginInfoImpl implements LoginInfo { public UsersView getLogin(String username) { UsersView usersv = new UsersView(); BaseDao dao = new BaseDao(); List list = new ArrayList(); Result result = null; Connection conn = BaseManager.getConnection(); String sql = "select * from Users_View where username=?"; list.add(username); dao.setConn(conn); dao.setList(list); dao.setSql(sql); result = dao.getExecuteQuery(); for (int i = 0; i < result.getRowCount(); i++) { Map map = result.getRows()[i]; usersv.setId(Integer.parseInt(map.get("id").toString())); usersv.setUsername((String) map.get("username")); usersv.setPassword((String) map.get("password")); usersv.setTypeid(Integer.parseInt(map.get("typeid").toString())); usersv.setUname((String) map.get("uname")); usersv.setSex((String) map.get("sex")); usersv.setType((String) map.get("type")); usersv.setCertificate((String) map.get("certificate")); usersv.setHelp(Integer.parseInt(map.get("help").toString())); } return usersv; } public boolean getPwd(Users users) { boolean ok = false; List list = new ArrayList(); BaseDao dao = new BaseDao(); Connection conn = BaseManager.getConnection(); String sql = "update Users set [password] = ? where [id] = ?"; list.add(users.getPassword()); list.add(users.getId()); dao.setConn(conn); dao.setList(list); dao.setSql(sql); int count = dao.executeUpdate(); if (count > 0) { ok = true; } else { ok = false; } return ok; } public boolean getUsers(Users users) { boolean ok = false; List list = new ArrayList(); Connection conn = BaseManager.getConnection(); String sql = "Update Users set uname=?,sex=?,certificate=? where id=?"; BaseDao dao = new BaseDao(); dao.setConn(conn); list.add(users.getUname()); list.add(users.getSex()); list.add(users.getCertificate()); list.add(users.getId()); dao.setList(list); dao.setSql(sql); int count = dao.executeUpdate(); if (count > 0) { ok = true; } else { ok = false; } return ok; } public boolean getInsertUser(Users users) { boolean ok = false; List list = new ArrayList(); BaseDao dao = new BaseDao(); Connection conn = BaseManager.getConnection(); String sql = "INSERT INTO Users ([username],[password],[uName],[sex],[certificate],[typeid],[help]) VALUES (?,?,?,?,?,?,?)"; list.add(users.getUsername()); list.add(users.getPassword()); list.add(users.getUname()); list.add(users.getSex()); list.add(users.getCertificate()); list.add(users.getTypeid()); list.add(users.getHelp()); dao.setConn(conn); dao.setList(list); dao.setSql(sql); int count = dao.executeUpdate(); if (count > 0) { ok = true; } else { ok = false; } return ok; } public List getAllUsers() { List list = new ArrayList(); Result result = null; BaseDao dao = new BaseDao(); Connection conn = BaseManager.getConnection(); String sql = "select * from Users"; dao.setConn(conn); dao.setSql(sql); result = dao.getExecuteQuery(); for (int i = 0; i < result.getRowCount(); i++) { Users users = new Users(); Map map = result.getRows()[i]; users.setId(Integer.parseInt(map.get("id").toString())); users.setUsername((String) map.get("username")); users.setPassword((String) map.get("password")); users.setUname((String) map.get("uname")); users.setSex((String) map.get("sex")); users.setCertificate((String) map.get("certificate")); users.setTypeid(Integer.parseInt(map.get("typeid").toString())); users.setHelp(Integer.parseInt(map.get("help").toString())); list.add(users); } return list; } public Users getUserById(Users users) { List list = new ArrayList(); BaseDao dao = new BaseDao(); Result result = null; Connection conn = BaseManager.getConnection(); String sql = "select * from Users where id = ?"; list.add(users.getId()); dao.setConn(conn); dao.setList(list); dao.setSql(sql); result = dao.getExecuteQuery(); for (int i = 0; i < result.getRowCount(); i++) { Map map = result.getRows()[i]; users.setId(Integer.parseInt(map.get("id").toString())); users.setUsername((String) map.get("username")); users.setPassword((String)map.get("password")); users.setUname((String)map.get("uname")); users.setSex((String)map.get("sex")); users.setCertificate((String)map.get("certificate")); users.setTypeid(Integer.parseInt(map.get("typeid").toString())); users.setHelp(Integer.parseInt(map.get("help").toString())); } return users; } }