1 package com.bie.system.dao.impl; 2  3 import java.sql.Connection; 4 import java.sql.PreparedStatement; 5 import java.sql.ResultSet; 6 import java.util.ArrayList; 7 import java.util.List; 8  9 import com.bie.po.UserInfo;10 import com.bie.system.dao.UserInfoDao;11 import com.bie.utils.DbUtils;12 13 /***14  * 2.2：实现查询的接口15  * @author biehongli16  *17  */18 public class UserInfoDaoImpl implements UserInfoDao{19 20     @Override21     public List<UserInfo> selectUser(String sql, Object[] arr) {22         Connection con=null;23         PreparedStatement ps=null;24         ResultSet rs=null;25         List<UserInfo> list=null;26         try{27             con=DbUtils.getCon();//连接数据库28             ps=con.prepareStatement(sql);//预编译29             //为查询条件设置值，如为第一个设置为什么，为第二个设置为什么30             if(arr!=null && arr.length>0){31                 for(int i=0;i<arr.length;i++){32                     ps.setObject(i+1, arr[i]);33                 }34             }35             //执行sql语句36             rs=ps.executeQuery();37             list=new ArrayList<UserInfo>();38             //根据查询条件，从数据库匹配适合的条件，然后设置这个条件的全部信息39             while(rs.next()){40                 UserInfo user=new UserInfo();41                 user.setUserId(rs.getInt("user_id"));42                 user.setUserAccount(rs.getString("user_account"));43                 user.setUserPw(rs.getString("user_pw"));44                 user.setUserNumber(rs.getString("user_number"));45                 user.setUserName(rs.getString("user_name"));46                 user.setUserAge(rs.getInt("user_age"));47                 user.setUserSex(rs.getString("user_sex"));48                 //user.setUserMark(rs.getString("user_mark"));49                 //根据判断看是否是管理员或者普通会员50                 if("0".equals(rs.getString("user_mark"))){51                     user.setUserMark("普通会员");52                 }53                 if("1".equals(rs.getString("user_mark"))){54                     user.setUserMark("管理员");55                 }56                 //将user对象封装到集合中57                 list.add(user);58             }59             //将封装到集合中的查询条件返回60             return list;61         }catch(Exception e){62             e.printStackTrace();63         }finally{64             //关闭资源，避免出现问题65             DbUtils.getClose(con, ps, rs);66         }67         return null;68     }69 70     71 }

 1 package com.bie.system.service.impl; 2  3 import java.util.ArrayList; 4 import java.util.List; 5  6 import com.bie.po.UserInfo; 7 import com.bie.system.dao.UserInfoDao; 8 import com.bie.system.dao.impl.UserInfoDaoImpl; 9 import com.bie.system.service.UserInfoService;10 import com.bie.utils.DbUtils;11 import com.bie.utils.MarkUtils;12 /***13  * 1.4:这是业务逻辑层的实现类，实现用户信息的接口14  * 15  * 切忌新手写好service业务逻辑层需要test测试(junit)16  * @author biehongli17  *18  */19 public class UserInfoServiceImpl implements UserInfoService{20 21     private UserInfoDao dao=new UserInfoDaoImpl();22     @Override23     public boolean insertUser(UserInfo user) {24         try{25             //System.out.println(user);//测试传来的UserInfo里面是否够存在用户信息26             if(user!=null && user.getUserAccount()!=null){27                 String sql="INSERT INTO user_info(user_account,user_pw,"28                         + "user_number,user_name,user_age,user_sex,user_mark)"29                         + " VALUES(?,?,?,?,?,?,?)";30                 List<Object> list=new ArrayList<Object>();31                 //可以理解位将实体类中get到的信息放到数据库中，因为set设置的信息就是为了查到数据库中32                 list.add(user.getUserAccount());//将设置好的账号信息保存到集合中33                 list.add(user.getUserPw());//将设置好的账号信息保存到集合中34                 list.add(user.getUserNumber());//将设置好的密码信息保存到集合中35                 list.add(user.getUserName());//将设置好的姓名信息保存到集合中36                 list.add(user.getUserAge());//将设置好的年龄信息保存到集合中37                 list.add(user.getUserSex());//将设置好的性别信息保存到集合中38                 //list.add(user.getUserMark());//将设置好的标识信息保存到集合中39                 //后台只可以添加管理员40                 user.setUserMark(MarkUtils.USER_MARK_MANAGER);41                 //将设置为默认的管理员添加到数据库42                 list.add(user.getUserMark());43                 44                 //将封装到集合list中的信息和sql语句传递到DbUtils封装好的 方法中45                 //这里sql转化位String语句，list转化位数组类型46                 int count=DbUtils.addAndUpdate(sql.toString(), list.toArray());47                 //System.out.println(count);//测试返回值是0还是148                 if(count>0){49                     return true;//成功返回true50                 }else{51                     return false;//失败返回false52                 }53             }54         }catch(Exception e){55             e.printStackTrace();56         }57         return false;58     }59 60     @Override61     public List<UserInfo> selectUser(UserInfo user) {62         //使用StringBuffer进行字符串的拼接，不使用String63         //StringBuffer sql=new StringBuffer("select * from user_info where 1=1 ");64         StringBuffer sql=new StringBuffer("select * from user_info where 1=1 ");65         //设置集合，用户存放用户信息设置值的时候使用66         List<Object> list=null;67         //判断用户的信息不为空的时候68         if(user!=null){69             list=new ArrayList<Object>();70             //按照账号查询，如果账号不为null且不为空71             if(user.getUserAccount()!=null && !user.getUserAccount().equals("")){72                 sql.append(" and user_account=?");73                 list.add(user.getUserAccount());74             }75             //按照姓名查询，如果姓名不为null且不为空76             if(user.getUserName()!=null && !user.getUserName().equals("")){77                 sql.append(" and user_name like ?");78                 //模糊查询这样拼接字符串79                 list.add("%"+user.getUserName()+"%");80             }81             //按照标识查询，如果标识不为null且不为空82             if(user.getUserMark()!=null && !user.getUserMark().equals("")){83                 sql.append(" and user_mark=?");84                 list.add(user.getUserMark());85             }86         }87         88         sql.append(" order by user_id desc");89         //返回的参数，sql语句是字符类型，集合转化为数组类型90         return dao.selectUser(sql.toString(), list.toArray());91     }92 93     94 }

 1 package com.bie.system.servlet; 2  3 import java.io.IOException; 4 import java.util.List; 5  6 import javax.servlet.ServletException; 7 import javax.servlet.annotation.WebServlet; 8 import javax.servlet.http.HttpServlet; 9 import javax.servlet.http.HttpServletRequest;10 import javax.servlet.http.HttpServletResponse;11 12 import com.bie.po.UserInfo;13 import com.bie.system.service.UserInfoService;14 import com.bie.system.service.impl.UserInfoServiceImpl;15 import com.my.web.servlet.RequestBeanUtils;16 /***17  * 2.3:点击用户管理，先调转到这个servlet,查询出数据库的信息，并且显示在页面上面18  * @author biehongli19  *20  */21 @WebServlet("/system/userinfoselect")22 public class UserInfoSelectServlet extends HttpServlet{23 24     private static final long serialVersionUID = 1L;25 26     @Override27     protected void doGet(HttpServletRequest request, HttpServletResponse response) 28             throws ServletException, IOException {29         this.doPost(request, response);30     }31 32     @Override33     protected void doPost(HttpServletRequest request, HttpServletResponse response) 34             throws ServletException, IOException {35         //将表单提交的数据封装到javabean的实体类中36         UserInfo user=RequestBeanUtils.requestToSimpleBean(request, UserInfo.class);37         //调用service业务逻辑层的代码38         UserInfoService service=new UserInfoServiceImpl();39         //调用业务逻辑层的查询方法selectUser，将返回的集合接受40         List<UserInfo> list=service.selectUser(user);41         //将上面的集合和user对象设置在域中，方便userinfo_list.jsp调用42         request.setAttribute("list", list);43         request.setAttribute("user", user);44         //将转发到userinfo_list.jsp这个页面45         request.getRequestDispatcher("/view/system/userinfo/userinfo_list.jsp").forward(request, response);46     }47     48     49 }

 1 <%@ page language="java" contentType="text/html; charset=UTF-8" 2     pageEncoding="UTF-8"%> 3 <% 4     //获取绝对路径路径  5     String path = request.getContextPath(); 6     String basePath = request.getScheme() + "://" 7                 + request.getServerName() + ":" + request.getServerPort() 8                 + path + "/"; 9 %> 10 <%@ taglib prefix="d" uri="http://displaytag.sf.net"%>11 <!DOCTYPE html>12 <html>13 <head>14 <base href="http://www.mamicode.com/" />15 <meta charset="UTF-8">16 <meta name="viewport" content="width=device-width, initial-scale=1.0" />17 <title>用户管理-用户查询</title>18 <link href="http://www.mamicode.com/resource/css/bootstrap.min.css" rel="stylesheet" />19 <script type="text/javascript" src="http://www.mamicode.com/resource/js/jquery.min.js"></script>20 <script type="text/javascript"21     src="http://www.mamicode.com/resource/js/bootstrap.min.js"></script>22 </head>23 <body>24     <div>25         <ul class="breadcrumb" style="margin: 0px;">26             <li>系统管理</li>27             <li>用户管理</li>28             <li>用户查询</li>29         </ul>30     </div>31     <form action="system/userinfoselect" class="form-inline" method="post">32         <div class="row alert alert-info" style="margin: 0px; padding: 5px;">33             <div class="form-group">34                 <label>账号:</label> 35                 <input type="text" name="userAccount" value="http://www.mamicode.com/${user.userAccount }" class="form-control" placeholder="请输入查询账号" />36                 <label>姓名:</label> 37                 <input type="text" name="userName" value="http://www.mamicode.com/${user.userName }" class="form-control" placeholder="请输入查询姓名" />38                 <select class="form-control" name="userMark">39                     <option value="">全部</option>40                     <option value="http://www.mamicode.com/0" ${user.userMark==‘0‘?‘selected‘:‘‘ }>普通会员</option>41                     <option value="http://www.mamicode.com/1" ${user.userMark==‘1‘?‘selected‘:‘‘ }>管理员</option>42                 </select> 43             </div>44             <input type="submit" class="btn btn-danger" value="http://www.mamicode.com/查询"> <a45                 href="http://www.mamicode.com/view/system/userinfo/userinfo_add.jsp" class="btn btn-success">添加用户</a>46         </div>47         <div class="row" style="padding: 15px;">48             <d:table name="list" pagesize="5" requestURI="system/userinfoselect" class="table table-hover table-condensed">49                 <d:column property="userId" title="用户编号"></d:column>50                 <d:column property="userAccount" title="用户账号"></d:column>51                 <d:column property="userPw" title="用户密码"></d:column>52                 <d:column property="userNumber" title="用户学号"></d:column>53                 <d:column property="userName" title="用户姓名"></d:column>54                 <d:column property="userAge" title="用户年龄"></d:column>55                 <d:column property="userSex" title="用户性别"></d:column>56                 <d:column property="userMark" title="用户标识"></d:column>57                 58             </d:table>59             <!-- <table class="table table-hover table-condensed">60                 <tr>61                     <th>用户编号</th>62                     <th>用户账号</th>63                     <th>用户密码</th>64                     <th>用户姓名</th>65                     <th>用户性别</th>66                     <th>用户年龄</th>67                     <td>操作</td>68                 </tr>69                 <tr>70                     <td>1001</td>71                     <td>admin123</td>72                     <td>123456</td>73                     <td>高富帅</td>74                     <td>男</td>75                     <td>20</td>76                     <td><a href="http://www.mamicode.com/view/system/userinfo/userinfo_update.jsp">修改</a> 删除</td>77                 </tr>78             </table> -->79         </div>80     </form>81 </body>82 </html>

  1 <%@ page language="java" contentType="text/html; charset=UTF-8"  2     pageEncoding="UTF-8"%>  3 <%  4     //获取绝对路径路径   5     String path = request.getContextPath();  6     String basePath = request.getScheme() + "://"  7                 + request.getServerName() + ":" + request.getServerPort()  8                 + path + "/";  9 %>  10 <!DOCTYPE html> 11 <html> 12 <head> 13 <base href="http://www.mamicode.com/" /> 14 <meta charset="UTF-8"> 15 <meta name="viewport" content="width=device-width, initial-scale=1.0" /> 16 <title>用户管理-用户添加</title> 17 <link href="http://www.mamicode.com/resource/css/bootstrap.min.css" rel="stylesheet" /> 18 <script type="text/javascript" src="http://www.mamicode.com/resource/js/jquery.min.js"></script> 19 <script type="text/javascript" 20     src="http://www.mamicode.com/resource/js/bootstrap.min.js"></script> 21 </head> 22 <body> 23     <div> 24         <ul class="breadcrumb" style="margin: 0px;"> 25             <li>系统管理</li> 26             <li>用户管理</li> 27             <li>用户添加</li> 28         </ul> 29     </div> 30 <form action="system/userinfoinsert" class="form-horizontal" method="post"> 31         <h5 class="page-header alert-info" 32             style="margin: 0px; padding: 10px; margin-bottom: 10px;">基本信息</h5> 33         <!-- 开始1 --> 34         <div class="row"> 35             <div class="col-xs-5"> 36                 <div class="form-group "> 37                     <label class="col-xs-3 control-label">用户学号</label> 38                     <div class="col-xs-9 "> 39                         <input type="text" name="userNumber" class="form-control" placeholder="请输入用户学号" /> 40                     </div> 41                 </div> 42             </div> 43             <div class="col-xs-5"> 44                 <div class="form-group "> 45                     <label class="col-xs-3 control-label">用户姓名</label> 46                     <div class="col-xs-9 "> 47                         <input type="text" name="userName" class="form-control" placeholder="请输入用户姓名" /> 48                     </div> 49                 </div> 50             </div> 51         </div> 52         <!--结束1 --> 53         <!-- 开始2 --> 54         <div class="row"> 55             <div class="col-xs-5"> 56                 <div class="form-group "> 57                     <label class="col-xs-3 control-label">用户年龄</label> 58                     <div class="col-xs-9 "> 59                         <input type="text" name="userAge" class="form-control" placeholder="请输入用户年龄" /> 60                     </div> 61                 </div> 62             </div> 63             <div class="col-xs-5"> 64                 <div class="form-group "> 65                     <label class="col-xs-3 control-label">用户性别</label> 66                     <div class="col-xs-3 "> 67                         <select class="form-control" name="userSex"> 68                             <option>保密</option> 69                             <option>男</option> 70                             <option>女</option> 71                         </select> 72                     </div> 73                 </div> 74             </div> 75  76         </div> 77         <!--结束2 --> 78  79  80         <h5 class="page-header alert-info" 81             style="margin: 0px; padding: 10px; margin-bottom: 10px;">账号信息</h5> 82         <!-- 开始5 --> 83         <div class="row"> 84             <div class="col-xs-5"> 85                 <div class="form-group "> 86                     <label class="col-xs-3 control-label">用户账号</label> 87                     <div class="col-xs-9"> 88                         <input type="text" name="userAccount" class="form-control" placeholder="请输入用户账号" /> 89                     </div> 90                 </div> 91             </div> 92             <div class="col-xs-5"> 93                 <div class="form-group "> 94                     <label class="col-xs-3 control-label">用户密码</label> 95                     <div class="col-xs-9 "> 96                         <input type="text" name="userPw" class="form-control" placeholder="请输入用户密码" /> 97                     </div> 98                 </div> 99             </div>100         </div>101         <!--结束5 -->102 103         <div class="row">104             <div class="col-xs-3 col-xs-offset-4">105                 <input type="submit" class="btn btn-success" value="http://www.mamicode.com/保存用户" /> <input106                     type="reset" class="btn btn-danger" value="http://www.mamicode.com/重置信息" />107             </div>108 109         </div>110 111     </form>112 </body>113 </html>

 1 <%@ page language="java" contentType="text/html; charset=UTF-8" 2     pageEncoding="UTF-8"%> 3 <% 4     //获取绝对路径路径  5     String path = request.getContextPath(); 6     String basePath = request.getScheme() + "://" 7                 + request.getServerName() + ":" + request.getServerPort() 8                 + path + "/"; 9 %> 10 <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">11 <html>12 <head>13 <base href="http://www.mamicode.com/" />14 <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">15 <title>Insert title here</title>16 </head>17 <body>18 <script type="text/javascript">19     //此页面用来提示添加，修改，删除信息的成功或者失败的信息20     alert(‘${info}‘);//提示信息，错误or成功21     //跳转到user_info.jsp查询页面，后面会修改为servlet22     //window.location="view/system/userinfo/userinfo_list.jsp";23     //这句话的作用是当插入成功 的时候就可以显示在页面下24     window.location="system/userinfoselect";25 </script>26 </body>27 </html>

  1 basic.empty.showtable=true  2 basic.show.header=true  3   4 # page | list  5 sort.amount=list  6   7 export.amount=list  8 export.decorated=true  9  10 paging.banner.group_size=8 11 paging.banner.placement=bottom 12  13  14 css.tr.even=even 15 css.tr.odd=odd 16 css.th.sorted=sorted 17 css.th.ascending=order1 18 css.th.descending=order2 19 css.table= 20 css.th.sortable=sortable 21  22 # factory classes for extensions 23 factory.requestHelper=org.displaytag.util.DefaultRequestHelperFactory 24  25 # factory class for decorators 26 factory.decorator=org.displaytag.decorator.DefaultDecoratorFactory 27  28 # locale provider (Jstl provider by default) 29 locale.provider=org.displaytag.localization.I18nJstlAdapter 30  31 # locale.resolver (nothing by default, simply use locale from request) 32 #locale.resolver= 33  34 export.types=csv excel xml pdf 35  36 export.csv.class=org.displaytag.export.CsvView 37 export.excel.class=org.displaytag.export.ExcelView 38 export.xml.class=org.displaytag.export.XmlView 39 export.pdf.class=org.displaytag.export.PdfView 40  41 export.csv=false 42 export.csv.label=<span class="export csv">CSV </span> 43 export.csv.include_header=false 44 export.csv.filename= 45  46 export.excel=true 47 export.excel.label=<span class="export excel">Excel </span> 48 export.excel.include_header=true 49 export.excel.filename= 50  51 export.xml=false 52 export.xml.label=<span class="export xml">XML </span> 53 export.xml.filename= 54  55 export.pdf=false 56 export.pdf.label=<span class="export pdf">PDF </span> 57 export.pdf.include_header=true 58 export.pdf.filename= 59  60 export.rtf=false 61 export.rtf.label=<span class="export rtf">RTF </span> 62 export.rtf.include_header=true 63 export.rtf.filename= 64  65 # messages 66  67 basic.msg.empty_list=\u6ca1\u6709\u53ef\u4ee5\u663e\u793a\u7684\u6570\u636e. 68 basic.msg.empty_list_row=<tr class="empty"><td colspan="{0}">\u6ca1\u6709\u53ef\u4ee5\u663e\u793a\u7684\u6570\u636e.</td></tr> 69 error.msg.invalid_page=\u975e\u6cd5\u9875\u9762 70  71 export.banner=<div class="exportlinks">\u8f93\u51fa\u683c\u5f0f: {0}</div> 72 export.banner.sepchar= | 73  74 paging.banner.item_name= 75 paging.banner.items_name= 76  77 paging.banner.no_items_found=<span class="pagebanner">\u6ca1\u6709\u603b\u5171\u8bb0\u5f55.</span> 78 paging.banner.one_item_found=<span class="pagebanner">\u603b\u5171\u4e00\u6761\u8bb0\u5f55.</span> 79 paging.banner.all_items_found=<span class="pagebanner">\u603b\u5171{0}{1}\u6761\u8bb0\u5f55.</span> 80 paging.banner.some_items_found=<span class="pagebanner">\u603b\u5171{0}{1}\u6761\u6570\u636e</span> 81  82 paging.banner.full=<span class="pagelinks"><a href="http://www.mamicode.com/{1}">\u9996\u9875</a>&nbsp;<a href="http://www.mamicode.com/{2}">\u4e0a\u4e00\u9875</a>&nbsp;<a href="http://www.mamicode.com/{3}">\u4e0b\u4e00\u9875</a>&nbsp;<a href="http://www.mamicode.com/{4}">\u5c3e\u9875</a>&nbsp;<select class="pagelinks" name="page" onchange="location=page.value">{0}</select></span> 83 paging.banner.first=<span class="pagelinks">\u9996\u9875&nbsp;\u4e0a\u4e00\u9875&nbsp;<a href="http://www.mamicode.com/{3}">\u4e0b\u4e00\u9875</a>&nbsp;<a href="http://www.mamicode.com/{4}">\u5c3e\u9875</a>&nbsp;<select class="pagelinks" name="page" onchange="location=page.value">{0}</select></span> 84 paging.banner.last=<span class="pagelinks"><a href="http://www.mamicode.com/{1}">\u9996\u9875</a>&nbsp;<a href="http://www.mamicode.com/{2}">\u4e0a\u4e00\u9875</a>&nbsp;\u4e0b\u4e00\u9875&nbsp;\u5c3e\u9875&nbsp;<select class="pagelinks" name="page" onchange="location=page.value">{0}</select></span> 85 paging.banner.onepage=<span class="pagelinks">\u5171\u4e00\u9875</span> 86  87 paging.banner.page.selected=<option value="http://www.mamicode.com/#" selected>{0}</option> 88 #<strong>{0}</strong> 89 paging.banner.page.link=<option value="http://www.mamicode.com/{1}">{0}</option> 90 #&nbsp;<input size=‘2‘>&nbsp;<input type=‘button‘ value=http://www.mamicode.com/‘Go‘>"color: #008080;"> 91 #<a href="http://www.mamicode.com/{1}" title="Go to page {0}">{0}</a> 92 paging.banner.page.separator= 93 #,  94  95 # external sort and pagination 96 pagination.sort.param=sort 97 pagination.sortdirection.param=dir 98 pagination.pagenumber.param=page 99 pagination.searchid.param=searchid100 pagination.sort.asc.value=http://www.mamicode.com/asc101 pagination.sort.desc.value=http://www.mamicode.com/desc102 pagination.sort.skippagenumber=true103 104 # unused105 save.excel.banner=<a href="http://www.mamicode.com/{0}" rel="external">save ({1} bytes)</a>106 save.excel.filename=export.xls