Servlet实例
来源:互联网 发布:网络视频广告投放 编辑:程序博客网 时间:2024/04/30 14:40
DaoImpl
package com.zhiyou100.crm.dao.impl;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Timestamp;import java.util.ArrayList;import java.util.List;import com.zhiyou100.crm.dao.UserDao;import com.zhiyou100.crm.model.User;import com.zhiyou100.crm.util.DBUtil;public class UserDaoImpl implements UserDao { @Override public boolean isUsername(String username) { // TODO Auto-generated method stub DBUtil db= new DBUtil(); String sql="select * from user where username=?"; Object[] obj={username}; ResultSet rs=db.select(sql, obj); try { while(rs.next()){ return true; } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return false; } @Override public boolean isUsernamepassword(String username, String password) { // TODO Auto-generated method stub DBUtil db= new DBUtil(); String sql="select * from user where username=? and password=?"; Object[] obj={username,password}; ResultSet rs=db.select(sql, obj); try { while(rs.next()){ return true; } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return false; } @Override public int isSuperAdmin(String username) { // TODO Auto-generated method stub DBUtil db= new DBUtil(); String sql="select role_id from user where username=?"; Object[] obj={username}; ResultSet rs=db.select(sql, obj); try { int i=0; while(rs.next()){ i=rs.getInt("role_id"); } return i; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return 0; } @Override public List<User> list(int role_id) { // TODO Auto-generated method stub DBUtil db=new DBUtil(); String sql="select * from user where role_id=?"; Object[] obj={role_id}; ResultSet rs=db.select(sql, obj); try { List<User> list=new ArrayList<User>(); while(rs.next()){ int id=rs.getInt("user_id"); String username=rs.getString("username"); int dep_id=rs.getInt("department_id"); int roleid=rs.getInt("role_id"); String tel=rs.getString("mobile"); String email=rs.getString("email"); Timestamp tm=rs.getTimestamp("update_time"); User us=new User(id, username, dep_id, roleid, tel, email, tm); list.add(us); } return list; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return null; } @Override public boolean isNameExist(String username) { // TODO Auto-generated method stub DBUtil db=new DBUtil(); String sql="select * from user where username=?"; Object[] obj={username}; ResultSet rs=db.select(sql, obj); try { while(rs.next()){ return true; } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return false; } @Override public void add(User user) { // TODO Auto-generated method stub DBUtil db=new DBUtil(); String sql="insert into user(username,password,department_id,role_id,is_male," + "mobile,address,age,tel,id_num,email,qq,hobby,education,card_num,nation,marry,remark" + ") values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) "; Object[]obj={user.getUsername(),user.getPassword(),user.getDepartment_id(), user.getRole_id(),user.getIs_male(),user.getMobile(),user.getAddress(),user.getAge(), user.getTel(),user.getId_num(),user.getEmail(),user.getQq(),user.getHobby(),user.getEducation(), user.getCard_num(),user.getNation(),user.getMarry(),user.getRemark()}; db.update(sql, obj); } @Override public void delete(int user_id) { // TODO Auto-generated method stub DBUtil db=new DBUtil(); String sql="delete from user where user_id=?"; Object[] obj={user_id}; db.update(sql, obj); } @Override public User selectOneById(int id) { // TODO Auto-generated method stub DBUtil db=new DBUtil(); String sql="select * from user where user_id=?"; Object[] obj={id}; ResultSet rs=db.select(sql, obj); try { User us=null; while(rs.next()){ int user_id=rs.getInt(1); String username=rs.getString(2); String password=rs.getString(3); int department_id=rs.getInt(6); int is_male=rs.getInt(7); int role_id=rs.getInt(8); String mobile=rs.getString(9); String address=rs.getString(10); int age=rs.getInt(11); String tel=rs.getString(12); String id_num=rs.getString(13); String email=rs.getString(14); String qq=rs.getString(15); String hobby=rs.getString(16); int education=rs.getInt(17); String card_num=rs.getString(18); String nation=rs.getString(19); int marry=rs.getInt(20); String remark=rs.getString(22); us=new User(user_id, username, password, department_id, role_id, is_male, mobile, address, age, tel, id_num, email, qq, hobby, education, card_num, nation, marry, remark); } return us; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return null; } @Override public void update(User user) { // TODO Auto-generated method stub DBUtil db=new DBUtil(); String sql="update user set username=?, password=?,department_id=?,role_id=?,is_male=?" + ",mobile=?,address=?,age=?,tel=?,id_num=?,email=?,qq=?,hobby=?,education=?," + "card_num=?,nation=?,marry=?,remark=? where user_id=?"; Object[] obj={user.getUser_id(),user.getUsername(),user.getPassword(),user.getDepartment_id(), user.getRole_id(),user.getIs_male(),user.getMobile(),user.getAddress(),user.getAge() ,user.getTel(),user.getId_num(),user.getEmail(),user.getQq(),user.getHobby(),user.getEducation(), user.getCard_num(),user.getNation(),user.getMarry(),user.getRemark()}; db.update(sql, obj); } @Override public User getUser(String username) { // TODO Auto-generated method stub DBUtil db=new DBUtil(); String sql="select * from user where username=?"; Object[] obj={username}; ResultSet rs=db.select(sql, obj); try { User user=null; while(rs.next()){ int user_id=rs.getInt(1); String username2=rs.getString(2); int department_id=rs.getInt(6); int role_id=rs.getInt(8); String mobile=rs.getString(9); String email=rs.getString(14); Timestamp create_time=rs.getTimestamp(23); user=new User(user_id, username2, department_id, role_id, mobile, email, create_time); } return user; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return null; } @Override public List<User> selectKeyword(String keyword, String searchFiled) { // TODO Auto-generated method stub DBUtil db=new DBUtil(); String sql="select * from user where "+searchFiled+" like ?"; Object[] obj={"%"+keyword+"%"}; ResultSet rs=db.select(sql, obj); try { List<User> list=new ArrayList<User>(); while(rs.next()){ int id=rs.getInt("user_id"); String username=rs.getString("username"); int dep_id=rs.getInt("department_id"); int roleid=rs.getInt("role_id"); String tel=rs.getString("mobile"); String email=rs.getString("email"); Timestamp tm=rs.getTimestamp("update_time"); User us=new User(id, username, dep_id, roleid, tel, email, tm); list.add(us); } return list; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return null; }}
serviceImpl
package com.zhiyou100.crm.service.impl;import java.util.List;import com.zhiyou100.crm.dao.UserDao;import com.zhiyou100.crm.dao.impl.UserDaoImpl;import com.zhiyou100.crm.model.User;import com.zhiyou100.crm.service.UserService;public class UserServiceImpl implements UserService { @Override public int user_login(String username, String password) { // TODO Auto-generated method stub /** * 1、判断帐号是否存在 * 2、判断帐号密码是否匹配 * 3、判断是否是超级管理员 * */ UserDao ud=new UserDaoImpl(); /*boolean b1= ud.isUsername(username); boolean b2= ud.isUsernamepassword(username,password); int i=ud.isSuperAdmin(username);*/ if(ud.isUsername(username)){ //帐号存在 if(ud.isUsernamepassword(username,password)){ int i=ud.isSuperAdmin(username); if(i==1){ return 1; }else{ return 2; } }else{//帐号密码不匹配 return -1; } }else{ //帐号不存在 return 0; } } @Override public List<User> list(int role_id) { // TODO Auto-generated method stub UserDao ud=new UserDaoImpl(); List<User> list=ud.list(role_id); return list; } @Override public boolean add(User user) { // TODO Auto-generated method stub //判断 需要一个判断方法 根据username来判断 UserDao ud=new UserDaoImpl(); boolean flag=ud.isNameExist(user.getUsername()); if(flag==true){ //帐号存在 //添加失败,返回false return false; }else{//帐号不存在,执行添加操作并且返回true ud.add(user); return true; } } @Override public void removeById(int user_id) { // TODO Auto-generated method stub //业务逻辑层 UserDao ud=new UserDaoImpl(); ud.delete(user_id); } @Override public User selectOneById(int id) { // TODO Auto-generated method stub UserDao ud=new UserDaoImpl(); User us=ud.selectOneById(id); return us; } @Override public void update(User user) { // TODO Auto-generated method stub UserDao ud=new UserDaoImpl(); ud.update(user); } @Override public User getUser(String username) { // TODO Auto-generated method stub UserDao ud=new UserDaoImpl(); User user=ud.getUser(username); return user; } @Override public List<User> selectKeyword(String keyword, String searchFiled) { // TODO Auto-generated method stub UserDao ud=new UserDaoImpl(); List<User> list=ud.selectKeyword(keyword,searchFiled); return list; }}
ListServlet
/** * Servlet implementation class ListServlet */ //主要是注意这里,一个name 一个url@WebServlet(name = "user/ListServlet", urlPatterns = { "/user/ListServlet" })public class ListServlet extends HttpServlet { private static final long serialVersionUID = 1L; /** * @see HttpServlet#HttpServlet() */ public ListServlet() { super(); // TODO Auto-generated constructor stub } /** * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */ protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub UserService us=new UserServiceImpl(); List<User> list=us.list(2); request.setAttribute("list",list); request.getRequestDispatcher("/WEB-INF/view/user/list.jsp").forward(request, response); } /** * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub doGet(request, response); }}
阅读全文
0 0
- Servlet实例
- servlet实例
- Servlet 实例
- Servlet 实例
- Servlet 实例
- Servlet 实例
- Servlet 实例
- Servlet 实例
- Servlet实例
- Servlet实例
- 【实例】实例解读Servlet;
- 简单的servlet实例
- Servlet简单实例
- Servlet统计图实例
- AJAX+servlet实例入门
- 详解servlet实例
- Filter Servlet实例应用
- jsp servlet 实例
- EEPROM和flash的区别
- 最简单的MVP模式,简洁易懂。
- 为什么未来是全栈工程师的世界?
- C#数据结构--线性表--List
- 使用inline-block进行列表布局的时候,发现垂直方向上也会有空隙
- Servlet实例
- 禁止浏览器自动填充到表单
- 简单工厂模式和工厂方法模式适用场景
- Chrome调试合成jsp页面js代码
- jsp页面获取session中的值
- logstash5.0版本之后导入es数据指定ik分词器详解
- SQL学习
- ThinkPHP3.2.3将session放置到指定文件夹中
- Java关于23种设计模式的有趣见解