java-easyui项目演练

1 首先写 index 里面的 easy-ui 布局( 页面的上下左右中)，其中的 center 通过类选择器定 位，并通过 west 中设一个 openTabs 的方法来与第二个界面 userList 关联。userList 的显 示只能在 id 选择器的 div-center 中 2 userList 中有三个界面一个是按钮，另外两个是表单。首先布局通过 div 分为两层一个 是按钮的层一个是 dg 数据表格 datagrid。而表达是通过对话框 dialog 来显示的。 当出发按钮增加，修改，查询，和表单按钮保存会对数据库里面的数据产生影 响 3 userList 中的功能实现和登录窗口的功能实现是一致的，通过 servlet 来 进行所想要的功能。所有 servlet 层中都有注解帮助 jsp 实现功能。Jsp 想要 实现功能就先写一个 url 然后在 servlet 中的注解里面寻找一致的 4 servlet 继承了 HttpServlet 类通过 doget 和 dopost 来获取表单或者 jsp 上页面的信息。使用 servlet 要有 vo 实体层（与数据库字段一致）， util 工具类（连接数据库），Dao 层（与数据库交互 sql 语句，里面的方法数 量与要执行的 jsp 上面的功能一样。里面的返回值是要实现方法通过 id 来进 行增删改还是要对数据库中的字段做什么改变影响到的字段来定。一般有初始 化 User 的 Dao 的实现层的增加和修改返回的是 flag 而通过 id 的返回值查询 和删除返回的则是 user） 5 serive 层业务逻辑层中的参数和 Dao 中接口的参数是一一对应的但是定方 法名是通过表单上出发的按钮功能名定义的。在 service 实现层中通过调用 Dao 层的方法 ud.xxx。（返回值 DaoImpl 层的返回值最好与 ServiceImpl 层的返回值相同。但是因为 List list =ud.findAllUserInfo(page, rows);与 List lists = us.findAllUserInfo(page, rows);已经 把返回值拿到了） 6 servlet 中没有返回值是每个方法定义一个返回值来接受 us service 层 中的返回值 boolean flag = us.saveUserInfo。通过 if 来进行 if(mapdata!=null) if(flag)而 if 里面的参数就是用来进行表单值的显 示通过 jsp 中的回调函数 function（user ） User user = new User(); UserService us = new UserServiceImpl(); user = us.queryUserByIdInfo(Integer.parseInt(id); if(user!=null) 一般出错是在 UserDaoImpl 里面的 sql 语句和 userList 里面的 #一级/还有括号问题 Index.jsp Insert title here function openTabs(text,url) if($(“#tabs“).tabs(exists,text) $(“#tabs“).tabs(select,text); else var myContent=“ $(“#tabs“).tabs(add, title:text, closable:true, content:myContent ) 访问次数 欢迎登录 1234567890 广告位 食品管理 食品管理 食品管理 content3 Login.jsp Insert title here /* $(function() $(“#login_btn“).click(function() var data= username: $(“#user“).val(); userpwd : $(“pwd“).val(); timedate :$(“date“).val(); $.post(login?m=login,data,function(date) if(“success“=date) windowd.location.href=“index.jsp“; else alert(“用户名或密码错误 “); return false; ) ) */ 用户名： 密 码: 每次登录都需要 10天以内 30天以内 Time.jsp Insert title here $(function() $(“#dd“).datebox(setValue,6/1/2012); /* 设置datebox 的值 */ var v = $(“#dd“).datebox(getValue); $(“#dd“).datebox( onSelect:function(v) alert(v.getFullYear()+“:“+(v.getMonth+1)+“:“+v.getDate(); ); ) 基本的 userList Insert title here $(function() /默认查询 $(“#dg“).datagrid( url : “/userservlet?m=findAllUser“, /* 格式 url要有空格 要跳出jsp 文件夹*/ fitColumns : true, nowrap:false, pagination : true, pagePosition:bottom, pageSize:10, columns: field:userid,title:用户编号 ,width:80,align:center,checkbox:true, field:username,title:用户姓名 ,width:80,align:center, field:userage,title:用户年龄 ,width:100,align:center, field:useraddress,title:用户地址 ,width:60,align:center, field:remark,title:用户备注 ,width:60,align:center ); $(“#btn_add“).click(function() $(“#dd“).dialog( closed : false, /* ：分号前面要有括号 */ ) $(“#res“).click(function() $(“#form1“).form(clear); ) ) $(“#saveBtn“).click(function() var data = username : $(“#username“).val(), userage : $(“#userage“).val(), userpwd : $(“#userpwd“).val(), useraddress : $(“#useraddress“).val(), remark : $(“#remark“).val() $.post(/userservlet?m=add,data,function(flag) if(flag=“true“) $(“#dg“).datagrid(reload); $(“#form1“).form(clear); /* id选 择器要有#号 */ $(“#dd“).dialog( closed : true ) $.messager.show( title:添加用户 , msg:添加用户成功, timeout:3000, showType:slide ); else $.messager.alert(添加书本, 添加书本 失败,error); ) /* 又可能多一个电脑也不报错 */ ) /* 删除事件 */ $(“#btn_delete“).click(function() if($(“#dg“).datagrid(getSelections).length=0) $.messager.alert(消息提示, 亲，请选择要删 除的用户,error); else var ids=;/定义一个数组 var array = $(“#dg“).datagrid(getSelections);/获取选中的对象 for(var i in array) ids.push(arrayi.userid);/便利将选 中的ID放到ids中 $.post(/userservlet?m=delete,ids : ids,function(flag) if(flag=“true“) $(“#dg“).datagrid(reload); $.messager.alert(消息提示, 恭 喜您删除成功,success); else $.messager.alert(消息提示, 删 除失败,error); ) ) $(“#btn_edit“).click(function() if($(“#dg“).datagrid(getSelected)=null) $.messager.alert(消息提示, 请选择修改的行 ,warning); else if($(“#dg“).datagrid(getSelections).length1) $.messager.alert(消息提示, 请选择一 行数据修改,warning); else $(“#edit_dialog“).dialog( closed : false, /* :两边都 要有空格 */ ) $(“#edit_res“).click(function() $(“#form2“).form(clear); /* #号在form */ ) var date = /* 等号两边要有空格 */ userid : $(“#dg“).datagrid(getSelected).userid $.post(/userservlet?m=queryUserById,date,function(use r) if(user!=null) $(“#form2“).form(load, userid : user.userid, username : user.username, userage : user.userage, userpwd : user.userpwd, remark : user.remark, useraddress : user.useraddress ) ,json) ) $(“#edit_saveBtn“).click(function() var date = /* 空格= */ username : $(“#edit_username“).val(), userid : $(“#edit_userid“).val(), userage : $(“#edit_userage“).val(), userpwd : $(“#edit_userpwd“).val(), useraddress : $(“#edit_useraddress“).val(), remark : $(“#edit_remark“).val(), $.post(/userservlet?m=edit,date,function(flag) if(flag=“true“) $(“#dg“).datagrid(reload); $(“#edit_dialog“).dialog( closed:true ) $(“#form2“).form(clear) $.messager.show( title:修改成功 , msg:修改用户成功, timeout:3000, showType:slide ) else $.messager.alert(修改用户, 修改用户 失败,error) ) ) ) 增加 修改 删除 用户名称： 用户年龄： 用 户密码： 用户地址： 用户备注： 用户名称： 用户年龄： 用户密码： 用户地址： 用户备注： User package vo; public class User private String userid; private String username; private int userage; private String userpwd; private String remark; private String useraddress; public User() super(); / TODO Auto-generated constructor stub JDBCutil package util; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class JDBCutil static Connection conn = null; public static final String Driver=“com.mysql.jdbc.Driver“; public static final String url=“jdbc:mysql:/localhost:3306/lzc“; public static final String user=“root“; public static final String password=“123456“; public JDBCutil() public static Connection getConnection() throws SQLException try Class.forName(Driver); conn=DriverManager.getConnection(url,user,password); System.out.println(conn); System.out.println(“数据库连接成功 “); catch (ClassNotFoundException e) / TODO Auto-generated catch block e.printStackTrace(); return conn; public static void main(String args) try System.out.println(getConnection(); catch (SQLException e) / TODO Auto-generated catch block e.printStackTrace(); /*public static void jdbcClose() if(conn!=null) try conn.close(); System.out.println(“关闭“); catch (SQLException e) / TODO Auto-generated catch block e.printStackTrace(); */ UserDao package Dao; import java.util.List; import vo.User; public interface UserDao List findAllUserInfo(int page,int rows); boolean addUserInfo(User user); boolean deleteUserInfo(int id); User queryUserByIdInfo(int id); boolean updateUser(User user); int getUserCountInfo(); UserDaoImpl package Dao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import java.util.List; import util.JDBCutil; import vo.User; public class UserDaoImpl implements UserDao static Connection conn = null; static PreparedStatement ps =null; static Statement s =null; static ResultSet rs =null; Override public List findAllUserInfo(int page, int rows) / TODO Auto-generated method stub List lists = new ArrayList(); String sql = “select * from t_user where flag=0 limit “+page+“,“+rows; /*不能有空格用+号连的参数，=”也没有空格*/ try conn = JDBCutil.getConnection(); s= conn.createStatement(); rs= s.executeQuery(sql); while(rs.next() User user = new User(); user.setUserid(rs.getInt(“userid“); user.setUsername(rs.getString(“username“); user.setUserage(rs.getInt(“userage“); user.setUseraddress(“useraddress“); /不 谢rs.get输出的一样 user.setRemark(rs.getString(“remark“); lists.add(user); catch (SQLException e) / TODO Auto-generated catch block e.printStackTrace(); return lists; Override public boolean addUserInfo(User user) / TODO Auto-generated method stub boolean flag= false; String sql = “insert into t_user(username,userage,useraddress,remark,userpwd,flag)values (?,?,?,?,?,0)“; try conn= JDBCutil.getConnection(); ps=conn.prepareStatement(sql); ps.setString(1, user.getUsername(); ps.setInt(2, user.getUserage(); ps.setString(3, user.getUseraddress(); ps.setString(4, user.getRemark(); ps.setString(5, user.getUserpwd(); int count =ps.executeUpdate(); if(count0) flag=true; catch (SQLException e) / TODO Auto-generated catch block e.printStackTrace(); return flag; Override public boolean deleteUserInfo(int id) / TODO Auto-generated method stub boolean flag=false; String sql = “update t_user set flag=1 where userid= “+id; try conn=JDBCutil.getConnection(); ps=conn.prepareStatement(sql); int count = ps.executeUpdate(); if(count0) flag = true; catch (SQLException e) / TODO Auto-generated catch block e.printStackTrace(); return flag; Override public User queryUserByIdInfo(int id) / TODO Auto-generated method stub User user = new User(); String sql = “select * from t_user where userid=“+id+“ and flag=0“; /*and前有空格*/ try conn =JDBCutil.getConnection(); s=conn.createStatement(); rs=s.executeQuery(sql); while(rs.next() user.setUserid(rs.getInt(“userid“); user.setUsername(rs.getString(“username“); user.setUserage(rs.getInt(“userage“); user.setUseraddress(“useraddress“); user.setRemark(rs.getString(“remark“); catch (SQLException e) / TODO Auto-generated catch block e.printStackTrace(); return user; Override public boolean updateUser(User user) / TODO Auto-generated method stub boolean flag = false; String sql = “update t_user set username=?,userage=?,userpwd=?,useraddress=?,remark=? where flag=0 and userid=“+user.getUserid(); try conn=JDBCutil.getConnection(); ps=conn.prepareStatement(sql); ps.setString(1, user.getUsername(); ps.setInt(2, user.getUserage(); ps.setString(3, user.getUserpwd(); ps.setString(4, user.getUseraddress(); ps.setString(5, user.getRemark(); int count =ps.executeUpdate(); if(count0) flag=true; catch (SQLException e) / TODO Auto-generated catch block e.printStackTrace(); return flag; Override public int getUserCountInfo() / TODO Auto-generated method stub int count = 0; try conn=JDBCutil.getConnection(); String sql=“select * from t_user where flag=0“; ps=conn.prepareStatement(sql); rs=ps.executeQuery(); while(rs.next() count+; catch (SQLException e) / TODO Auto-generated catch block e.printStackTrace(); return count; UserService package service; import java.util.List; import vo.User; public interface UserService List findAllUserInfo(int page,int rows); boolean saveUserInfo(User user); boolean deleteUserInfo(int id); User queryUserByIdInfo(int id); boolean updateUserInfo(User user); int getUserCountInfo(); UserServiceImpl package service; import java.util.List; import Dao.UserDao; import Dao.UserDaoImpl; import vo.User; public class UserServiceImpl implements UserService Override public List findAllUserInfo(int page, int rows) / TODO Auto-generated method stub UserDao ud = new UserDaoImpl(); List list = ud.findAllUserInfo(page, rows); return list; Override public boolean saveUserInfo(User user) / TODO Auto-generated method stub UserDao ud = new UserDaoImpl(); boolean flag = ud.addUserInfo(user); return flag; Override public boolean deleteUserInfo(int id) / TODO Auto-generated method stub UserDao ud = new UserDaoImpl(); boolean flag = ud.deleteUserInfo(id); return flag; Override public User queryUserByIdInfo(int id) / TODO Auto-generated method stub UserDao ud = new UserDaoImpl(); User user = new User(); user = ud.queryUserByIdInfo(id); return user; Override public boolean updateUserInfo(User user) / TODO Auto-generated method stub UserDao ud = new UserDaoImpl(); return ud.updateUser(user); Override public int getUserCountInfo() / TODO Auto-generated method stub UserDao ud = new UserDaoImpl(); return ud.getUserCountInfo(); UserServlet package servlet; import java.io.IOException; import javax.servlet.ServletContext; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.Cookie; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; WebServlet(“/login“) public class UserServlet extends HttpServlet Override protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException / TODO Auto-generated method stub this.doPost(req, resp); Override protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException / TODO Auto-generated method stub String btn = req.getParameter(“btn“); String name = req.getParameter(“user“); String pwd = req.getParameter(“pwd“); if(“登录“.equals( btn) if(“admin“.equals(name) int count=0; if(ctxt.getAttribute(“count“)=null) count=0; else count=Integer.parseInt(ctxt.getAttribute(“count“).toString(); count+; ctxt.setAttribute(“count“, count); String timeLength = req.getParameter(“date“); int days=0; if(timeLength!=null) days=Integer.parseInt(timeLength); if(days!=0) Cookie usernamecookie = new Cookie(“username“, name); Cookie userpwd = new Cookie(“userpwd“, pwd); usernamecookie.setMaxAge(days*24*3600); userpwd.setMaxAge(days*24*3600); resp.addCookie(usernamecookie); resp.addCookie(userpwd); req.getSession().setAttribute(“userName“, name); resp.sendRedirect(“index.jsp“); 过滤器否则 jsp页面不一定能跳转 UserFilter package filter; import java.io.IOException; import javax.servlet.Filter; import javax.servlet.FilterChain; import javax.servlet.FilterConfig; import javax.servlet.ServletException; import javax.servlet.ServletRequest; import javax.servlet.ServletResponse; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; public class UserFilter implements Filter Override public void destroy() / TODO Auto-generated method stub Override public void doFilter(ServletRequest arg0, ServletResponse arg1, FilterChain arg2) throws IOException, ServletException / TODO Auto-generated method stub HttpServletRequest req = (HttpServletRequest) arg0; HttpServletResponse resp=(HttpServletResponse) arg1; req.setCharacterEncoding(“utf-8“); resp.setCharacterEncoding(“utf-8“); arg2.doFilter(arg0, arg1); Override public void init(FilterConfig arg0) throws ServletException / TODO Auto-generated method stub Web.xml javaee index.html index.htm index.jsp default.html default.htm default.jsp userFilter filter.UserFilter userFilter /* UserServletInfo package servlet; import java.io.IOException; 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.google.gson.Gson; import service.UserService; import service.UserServiceImpl; import vo.User; WebServlet(“/userservlet“) public class UserSerlvetInfo extends HttpServlet private User user; Override protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException / TODO Auto-generated method stub String m = req.getParameter(“m“); if(“findAllUser“.equals(m) UserService us = new UserServiceImpl(); int page=(Integer.parseInt(req.getParameter(“page“)- 1)*Integer.parseInt(req.getParameter(“rows“); int rows =Integer.parseInt(req.getParameter(“rows“); List lists = u