UserDao

package com.cissst.dao;

import java.util.List;

import org.apache.ibatis.session.SqlSession;

import com.cissst.entity.Users;

import com.cissst.utils.MyBatisUtils;

public class UserDao {

public static Users findUserById(int userId){

SqlSession session=MyBatisUtils.getSqlSession();

Users users=session.selectOne(\"findUserById\

MyBatisUtils.closeConn(session);

return users;

}

public static boolean delUserInfo(int userId){

SqlSession session=MyBatisUtils.getSqlSession();

int flag=session.insert(\"delUserInfo\

session.commit();

if(flag!=0){

return true;

}

return false;

}

public static boolean updateUserInfo(Users users){

SqlSession session=MyBatisUtils.getSqlSession();

int flag=session.update(\"updateUserInfo\

session.commit();

if(flag!=0){

return true;

}

return false;

}

public static boolean saveUserInfo(Users user) {

SqlSession session=MyBatisUtils.getSqlSession();

int flag=session.insert(\"saveUserInfo\

session.commit();

if(flag!=0){

return true;

}

return false;

}

public static ListfindWithPage(){

Listlist=null;

try{

SqlSession session=MyBatisUtils.getSqlSession();

list=session.selectList(\"selectUserTable\");

MyBatisUtils.closeConn(session);

}catch (Exception e) {

}

return list;

}

}

UserDaoMapper

\"http://mybatis.org/dtd/mybatis-3-mapper.dtd\">

select * from tb_users where id=#{userId}

select * from tb_users where username=#{uname} and

password=#{upass}

update tb_users set usernumber=#{userNumber},

username=#{username},password=#{password},sex=#{sex},

address=#{address},tel=#{tel},qq=#{qq},age=#{age},remark=#{remark}

where id=#{id}

delete from tb_users

where id=#{userId}

insert into

tb_users(usernumber,username,password,sex,address,age,tel,qq,remark)

values(#{userNumber},#{username},#{password},#{sex},#{address},#{age},#{tel},#{qq},#{remark})

select * from tb_users

Users.java

package com.cissst.entity;

public class Users {

private Integer id;

private String userNumber;

private String username;

private String password;

private String sex;

private String age;

private String address;

private String tel;

private String qq;

private String remark;

public String getUserNumber() {

return userNumber;

}

public Users(String userNumber, String username, String password, String sex, String age,

String address, String tel, String qq, String remark) {

this.userNumber = userNumber;

this.username = username;

this.password = password;

this.sex = sex;

this.age = age;

this.address = address;

this.tel = tel;

this.qq = qq;

this.remark = remark;

}

public Users() {

}

public void setUserNumber(String userNumber) {

this.userNumber = userNumber;

}

public Integer getId() {

return id;

}

public void setId(Integer id) {

this.id = id;

}

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 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 getAddress() {

return address;

}

public void setAddress(String address) {

this.address = address;

}

public String getTel() {

return tel;

}

public void setTel(String tel) {

this.tel = tel;

}

public String getQq() {

return qq;

}

public void setQq(String qq) {

this.qq = qq;

}

public String getRemark() {

return remark;

}

public void setRemark(String remark) {

this.remark = remark;

}

}

UserServlet.java

package com.cissst.servlet;

import java.io.IOException;

import java.text.SimpleDateFormat;

import java.util.Date;

import java.util.HashMap;

import java.util.List;

import java.util.Map;

import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import com.cissst.dao.UserDao;

import com.cissst.entity.Users;

import com.google.gson.Gson;

@WebServlet(\"/userServlet\")

public class UserServlet extends HttpServlet{

Users users=null;

private static final long serialVersionUID = 1L;

protected void doGet(HttpServletRequest req, HttpServletResponse throws ServletException, IOException {

this.doPost(req, resp);

}

protected void doPost(HttpServletRequest req, HttpServletResponse throws ServletException, IOException {

String m=req.getParameter(\"m\");//获得页面中传递的参数值

resp.setCharacterEncoding(\"utf-8\");

resp) resp)

if(\"find\".equals(m)){

Listlist=UserDao.findWithPage();

for(Users u:list){

if(\"1\".equals(u.getSex())){

u.setSex(\"男\");

}else if(\"0\".equals(u.getSex())){

u.setSex(\"女\");

}else{

u.setSex(\"什么都不是\");

}

}

resp.getWriter().print(new Gson().toJson(list));

}else if(\"saveUserInfo\".equals(m)){

//编写后台自定生成编号

SimpleDateFormat format=new

SimpleDateFormat(\"yyyyMMddhhmmss\");

String userNumber=format.format(new Date());

Users users=new Users(userNumber, req.getParameter(\"username\"),

req.getParameter(\"password\"), req.getParameter(\"sex\"), req.getParameter(\"age\"), req.getParameter(\"address\"), req.getParameter(\"remark\"));

req.getParameter(\"tel\"),

req.getParameter(\"qq\"),

if(UserDao.saveUserInfo(users)){

resp.getWriter().print(true);

}else{

resp.getWriter().print(false);

}

}else if(\"deleteUserInfo\".equals(m)){

String ids[]=req.getParameterValues(\"arrayIds[]\");

if(ids.length>0){

for(String delId:ids){

int id=Integer.valueOf(delId);

if(UserDao.delUserInfo(id)){

resp.getWriter().print(true);

}else{

resp.getWriter().print(false);

}

}

}

}else if(\"findUserById\".equals(m)){

users=UserDao.findUserById(Integer.valueOf(req.getParameter(\"fId\")));

resp.getWriter().print(new Gson().toJson(users));

}else if(\"updateUserInfo\".equals(m)){

users.setUsername(req.getParameter(\"username\"));

users.setAddress(req.getParameter(\"address\"));

users.setAge(req.getParameter(\"age\"));

users.setPassword(req.getParameter(\"password\"));

users.setQq(req.getParameter(\"qq\"));

users.setSex(req.getParameter(\"sex\"));

users.setTel(req.getParameter(\"tel\"));

users.setRemark(req.getParameter(\"remark\"));

if(UserDao.updateUserInfo(users)){

resp.getWriter().print(true);

}else{

resp.getWriter().print(false);

}

}else if(\"login\".equals(m)){

Mapmap=new HashMap();

map.put(\"uname\

map.put(\"upass\

if(UserDao.login(map)){

resp.getWriter().print(true);

}else{

resp.getWriter().print(false);

}

}

}

}

userList.html

href=\"../jqueryui/themes/default/easyui.css\">

href=\"../jqueryui/themes/icon.css\">

pagination=\"true\" pagePosition=\"true\">

Index.html

href=\"jqueryui/themes/default/easyui.css\">

login.html

href=\"jqueryui/themes/default/easyui.css\">

web.xml

xmlns=\"http://java.sun.com/xml/ns/javaee\"

xsi:schemaLocation=\"http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd\" version=\"3.0\">

id=\"WebApp_ID\"

login.html