1. Cliquez sur Gestion des utilisateurs
2. Entrez les conditions de requête, interrogez la base de données et les données sont répercutées
#用户表CREATE TABLE Elec_User( UserID VARCHAR(50) NOT NULL, #主键ID JctID VARCHAR(50) NULL, #所属单位code JctUnitID VARCHAR(50) NULL, #所属单位的单位名称（联动） UserName VARCHAR(50) NULL, #用户姓名 LogonName VARCHAR(50) NULL, #登录名 LogonPwd VARCHAR(50) NULL, #密码# SexID VARCHAR(10) NULL, #性别 Birthday DATETIME NULL, #出生日期 Address VARCHAR(100) NULL, #联系地址 ContactTel VARCHAR(50) NULL, #联系电话 Email VARCHAR(50) NULL, #电子邮箱 Mobile VARCHAR(50) NULL, #手机 IsDuty VARCHAR(10) NULL, #是否在职 PostID VARCHAR(10) NULL, #职位（主要用于工作流审核） OnDutyDate DATETIME NULL, #入职时间 OffDutyDate DATETIME NULL, #离职时间 remark VARCHAR(500) NULL #备注 #IsDelete VARCHAR(10) NULL, #是否删除 #CreateEmpID VARCHAR(50) NULL,#创建人ID #CreateDate DATETIME NULL, #创建时间 #LastEmpID VARCHAR(50) NULL, #修改人ID #LastDate DATETIME NULL #修改时间 ) #用户职称附件表CREATE TABLE Elec_User_File( FileID VARCHAR(50) not null primary key, #主键ID UserID VARCHAR(50) NULL, #用户ID FileName VARCHAR(50) NULL, #文件名 FileURL VARCHAR(1000) NULL, #文件路径 ProgressTime TIMESTAMP NULL, #上传时间CONSTRAINT FOREIGN KEY(userID) REFERENCES Elec_User(userID) )
Créer les fichiers javabean correspondants basés sur la table utilisateur et table des pièces jointes : ElecUser.java et ElecUserFile.java, le code est légèrement
Parce qu'un utilisateur correspond à plusieurs pièces jointes, la table utilisateur et la pièce jointe la table est une paire De nombreuses relations .
1.ElecUser.hbm.xml
<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"><hibernate-mapping><class name="cn.elec.domain.ElecUser"
table="Elec_User"><id name="userID" type="string" column="userID"><generator class="uuid"></generator></id><property name="jctID" type="string" column="jctID"></property><property name="jctUnitID" type="string" column="jctUnitID"></property><property name="userName" type="string" column="userName"></property><property name="logonName" type="string" column="logonName">
</property><property name="logonPwd" type="string" column="logonPwd"></property><property name="sexID" type="string" column="sexID"></property><property name="birthday" type="date" column="birthday"></property><property name="address" type="string" column="address"></property><property name="contactTel" type="string" column="contactTel"></property><property name="email" type="string" column="email">
</property><property name="mobile" type="string" column="mobile"></property><property name="isDuty" type="string" column="isDuty"></property><property name="postID" type="string" column="postID"></property><property name="onDutyDate" type="date" column="onDutyDate"></property><property name="offDutyDate" type="date" column="offDutyDate"></property><property name="remark" type="string" column="remark">
</property><!-- 一个用户对应多个文件 --><set name="elecUserFiles" table="Elec_User_File" inverse="true"><key><column name="userID"></column></key><one-to-many class="cn.hust.elec.domain.ElecUserFile"/></set> </class></hibernate-mapping>2.ElecUserFile.hbm.xml
<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"><hibernate-mapping><class name="cn.elec.domain.ElecUserFile"
table="Elec_User_File"><id name="fileID" type="string" column="fileID"><generator class="uuid"></generator></id><property name="fileName" type="string" column="fileName"></property><property name="fileURL" type="string" column="fileURL"></property><property name="progressTime" type="timestamp" column="progressTime"></property><!-- 用户文件和用户是多对一的关系 -->
<many-to-one name="elecUser" class="cn.hust.elec.domain.ElecUser">
<column name="userID"></column></many-to-one></class></hibernate-mapping>3 Ajouter hibernate.cfg.xml :
<mapping resource="/cn/elec/domain/ElecUser.hbm.xml"></mapping><mapping resource="/cn/elec/domain/ElecUserFile.hbm.xml"></mapping>
1. Table utilisateur Dao : ElecUserDao.java
public interface IElecUserDao extends ICommonDao<ElecUser> {public static final String SERVICE_NAME="cn.elec.dao.imp.ElecUserDaoImpl";
}2. 🎜>
Afficher le code
public interface IElecUserFileDao extends ICommonDao<ElecUserFile> {public static final String SERVICE_NAME="cn.elec.dao.imp.ElecUserFileDaoImpl";
}
Afficher le code
@Repository(IElecUserDao.SERVICE_NAME)public class ElecUserDaoImpl extends ICommonDaoImpl<ElecUser> implements IElecUserDao{
}
Afficher le code
@Repository(IElecUserFileDao.SERVICE_NAME)public class ElecUserFileDaoImpl extends ICommonDaoImpl<ElecUserFile>
implements IElecUserFileDao{
}
Afficher le code
public interface IElecUserService {public static final String SERVICE_NAME="cn.elec.service.impl.ElecUserServiceImpl";
List<ElecUser> findUserlistByCondition(ElecUser elecUser);
}@Service(IElecUserService.SERVICE_NAME)
@Transactional(readOnly=true)public class ElecUserServiceImpl implements IElecUserService{//用户表Dao@Resource(name=IElecUserDao.SERVICE_NAME)private IElecUserDao elecUserDao;//附件表Dao@Resource(name=IElecUserFileDao.SERVICE_NAME)private IElecUserFileDao elecUserFileDao;//数据字典Dao@Resource(name=IElecSystemDDLDao.SERVICE_NAME)private IElecSystemDDLDao elecSystemDDLDao;/**
* @Name: findUserlistByCondition
* @Description: 根据查询条件返回查询结果
* @Parameters: ElecUser VO对象
* @Return: List<ElecUser>：用户集合*/@Overridepublic List<ElecUser> findUserlistByCondition(ElecUser elecUser) {
String condition="";
List<Object> paramsList = new ArrayList<Object>();//用户名String userName = elecUser.getUserName();if(StringUtils.isNotBlank(userName)){
condition+=" and o.userName like ?";
paramsList.add("%"+userName+"%");
}//所属单位String jctID = elecUser.getJctID();if(StringUtils.isNotBlank(jctID)){
condition+=" and o.jctID = ?";
paramsList.add(jctID);
}//查询的起始日期Date onDutyDateBegin = elecUser.getOnDutyDateBegin();if(onDutyDateBegin!=null){
condition+=" and o.onDutyDate >= ?";
paramsList.add(onDutyDateBegin);
}//查询的结束日期Date onDutyDateEnd = elecUser.getOnDutyDateEnd();if(onDutyDateBegin!=null){
condition+=" and o.onDutyDate <= ?";
paramsList.add(onDutyDateEnd);
}
Object[] params = paramsList.toArray();//排序（按入职时间顺序排序）Map<String, String> orderby = new LinkedHashMap<String, String>();
orderby.put("o.onDutyDate", "asc");
List<ElecUser> list = elecUserDao.findCollectionByConditionNoPage(condition, params, orderby);/**数据字典的转换
* 根据数据类型和数据编号，查询数据项的值 */this.convertSystemDDL(list);return list;
} //根据数据类型和数据编号，查询数据项的值private void convertSystemDDL(List<ElecUser> list) {if(list!=null&&list.size()>0){for(ElecUser user:list){//性别String sexID=elecSystemDDLDao.findDdlNameByKeywordAndDdlCode("性别",user.getSexID());
user.setSexID(sexID);//职位String postID=elecSystemDDLDao.findDdlNameByKeywordAndDdlCode("职位",user.getPostID());
user.setPostID(postID);
}
}
}
}1. Créer une classe UserAction
public class ElecUserAction extends BaseAction<ElecUser>{
ElecUser elecUser=this.getModel();
//注入用户管理service@Resource(name=IElecUserService.SERVICE_NAME)
IElecUserService elecUserService; //注入数据字典service@Resource(name=IElecSystemDDLService.SERVICE_NAME)
IElecSystemDDLService elecSystemDDLService; /**
* @Name: home
* @Description: 跳转到用户管理页面
* @Parameters: 无
* @Return: String：跳转到system/userIndex.jsp*/public String home(){//加载数据类型是所属单位的数据字典的集合，遍历在页面的下拉菜单中List<ElecSystemDDL> jctList = elecSystemDDLService.findSystemDDLListByKeyword("所属单位");
request.setAttribute("jctList", jctList);//组织页面中的查询条件，查询用户表，返回List<ElecUser>List<ElecUser> userList=elecUserService.findUserlistByCondition(elecUser);
request.setAttribute("userList", userList);return "home";
}
} dans struts.xmlJsp页面设计
<%@ page language="java" pageEncoding="UTF-8"%>
<%@taglib uri="/struts-tags" prefix="s"%>
<script language="javascript">
function deleteAll(){ var selectuser = document.getElementsByName("userID"); var flag = false; for(var i=0;i<selectuser.length;i++){ if(selectuser[i].checked){
flag = true;
}
} if(!flag){
alert("没有选择执行操作的用户！不能执行该操作"); return false;
} else{ var confirmflag = window.confirm("你确定执行批量删除吗？"); if(!confirmflag){ return false;
} else{
document.Form2.action = "elecUserAction_delete.do";
document.Form2.submit(); return true;
}
}
} //用户:全部选中/全部不选中
function checkAllUser(user){ var selectuser = document.getElementsByName("userID"); for(var i=0;i<selectuser.length;i++){
selectuser[i].checked = user.checked;
}
} </script>
<HTML>
<HEAD>
<title>用户管理</title>
<LINK href="${pageContext.request.contextPath }/css/Style.css?1.1.11" type="text/css" rel="stylesheet">
<script type="text/javascript" src="${pageContext.request.contextPath}/My97DatePicker/WdatePicker.js?1.1.11"></script>
<script language="javascript" src="${pageContext.request.contextPath }/script/function.js?1.1.11"></script>
</HEAD>
<body >
<form id="Form1" name="Form1" action="${pageContext.request.contextPath }/system/elecUserAction_home.do" method="post" style="margin:0px;">
<table cellspacing="1" cellpadding="0" width="90%" align="center" bgcolor="#f5fafe" border="0">
<TR height=10><td></td></TR>
<tr>
<td class="ta_01" colspan="4" align="center" background="../images/b-info.gif">
<font face="宋体" size="2"><strong>用户信息管理</strong></font>
</td>
</tr>
<tr>
<td class="ta_01" align="center" bgcolor="#f5fafe" height="22">姓名：</td>
<td class="ta_01" >
<s:textfield name="userName" size="21" id="userName"></s:textfield>
</td>
<td class="ta_01" align="center" bgcolor="#f5fafe" height="22">所属单位：</td>
<td class="ta_01" >
<s:select list="#request.jctList" name="jctID" id="jctID"
headerKey="" headerValue="请选择"listKey="ddlCode" listValue="ddlName"cssStyle="width:155px"></s:select>
</td>
</tr>
<tr>
<td class="ta_01" align="center" bgcolor="#f5fafe" height="22">入职时间：</td>
<td class="ta_01" colspan="3">
<s:date name="onDutyDateBegin" format="yyyy-MM-dd" var="begin"/>
<s:textfield name="onDutyDateBegin" value="%{begin}" id="onDutyDateBegin" maxlength="50" size="20" onclick="WdatePicker()"></s:textfield>
~
<s:date name="onDutyDateEnd" format="yyyy-MM-dd" var="end"/>
<s:textfield name="onDutyDateEnd" value="%{end}" id="onDutyDateEnd" maxlength="50" size="20" onclick="WdatePicker()"></s:textfield>
</td>
</tr>
</table>
</form>
<form id="Form2" name="Form2" action="/system/userAction_main.do" method="post">
<table cellSpacing="1" cellPadding="0" width="90%" align="center" bgColor="#f5fafe" border="0">
<Tbody>
<TR height=10><td></td></TR>
<tr>
<td>
<TABLE style="WIDTH: 105px; HEIGHT: 20px" border="0">
<TR>
<TD align="center" background="${pageContext.request.contextPath }/images/cotNavGround.gif"><img src="${pageContext.request.contextPath }/images/yin.gif" width="15"></TD>
<TD class="DropShadow" background="${pageContext.request.contextPath }/images/cotNavGround.gif">用户列表</TD>
</TR>
</TABLE>
</td>
<td class="ta_01" align="right">
<input style="font-size:12px; color:black; height=20;width=80" id="BT_Add" type="button" value="查询" name="BT_find"
onclick="document.forms[0].submit()"> <input style="font-size:12px; color:black; height=20;width=80" id="BT_Add" type="button" value="添加用户" name="BT_Add"
onclick="openWindow('${pageContext.request.contextPath }/system/elecUserAction_add.do','900','700')"> <input style="font-size:12px; color:black; height=20;width=80" id="BT_Delete" type="button" value="批量删除" name="BT_Delete"
onclick="return deleteAll()"> </td>
</tr>
<tr>
<td class="ta_01" align="center" bgColor="#f5fafe" colspan="2">
<table cellspacing="0" cellpadding="1" rules="all" bordercolor="gray" border="1" id="DataGrid1"style="BORDER-RIGHT:gray 1px solid; BORDER-TOP:gray 1px solid; BORDER-LEFT:gray 1px solid; WIDTH:100%; WORD-BREAK:break-all; BORDER-BOTTOM:gray 1px solid; BORDER-COLLAPSE:collapse; BACKGROUND-COLOR:#f5fafe; WORD-WRAP:break-word">
<tr style="FONT-WEIGHT:bold;FONT-SIZE:12pt;HEIGHT:25px;BACKGROUND-COLOR:#afd1f3">
<td align="center" width="5%" height=22 background="${pageContext.request.contextPath }/images/tablehead.jpg"><input type="checkbox" name="selectUserAll" onclick="checkAllUser(this)"></td>
<td align="center" width="15%" height=22 background="${pageContext.request.contextPath }/images/tablehead.jpg">登录名</td>
<td align="center" width="15%" height=22 background="${pageContext.request.contextPath }/images/tablehead.jpg">用户姓名</td>
<td align="center" width="7%" height=22 background="${pageContext.request.contextPath }/images/tablehead.jpg">性别</td>
<td align="center" width="15%" height=22 background="${pageContext.request.contextPath }/images/tablehead.jpg">联系电话</td>
<td align="center" width="15%" height=22 background="${pageContext.request.contextPath }/images/tablehead.jpg">入职时间</td>
<td align="center" width="8%" height=22 background="${pageContext.request.contextPath }/images/tablehead.jpg">职位</td>
<td width="10%" align="center" height=22 background="${pageContext.request.contextPath }/images/tablehead.jpg">编辑</td>
<td width="10%" align="center" height=22 background="${pageContext.request.contextPath }/images/tablehead.jpg">查看</td>
</tr>
<s:if test="#request.userList!=null && #request.userList.size()>0">
<s:iterator value="#request.userList">
<tr onmouseover="this.style.backgroundColor = 'white'" onmouseout="this.style.backgroundColor = '#F5FAFE';">
<td style="HEIGHT:22px" align="center" width="5%">
<input type="checkbox" name="userID" id="userID" value="<s:property value="userID"/>">
</td>
<td style="HEIGHT:22px" align="center" width="15%">
<s:property value="logonName"/>
</td>
<td style="HEIGHT:22px" align="center" width="15%">
<s:property value="userName"/>
</td>
<td style="HEIGHT:22px" align="center" width="7%">
<s:property value="sexID"/>
</td>
<td style="HEIGHT:22px" align="center" width="15%">
<s:property value="contactTel"/>
</td>
<td style="HEIGHT:22px" align="center" width="15%">
<s:date name="onDutyDate" format="yyyy-MM-dd"/>
</td>
<td style="HEIGHT:22px" align="center" width="8%">
<s:property value="postID"/>
</td>
<td align="center" style="HEIGHT: 22px" align="center" width="10%">
<a href="#" onclick="openWindow('userEdit.jsp?userID=<s:property value="userID"/>','900','700');">
<img src="${pageContext.request.contextPath }/images/edit.gif" border="0" style="CURSOR:hand"></a>
</td>
<td align="center" style="HEIGHT: 22px" align="center" width="10%">
<a href="#" onclick="openWindow('userEdit.jsp?userID=<s:property value="userID"/>&viewflag=1','900','700');">
<img src="${pageContext.request.contextPath }/images/button_view.gif" width="20" height="18" border="0" style="CURSOR:hand"></a>
</td>
</tr>
</s:iterator>
</s:if>
</table>
</td>
</tr>
</Tbody>
</table>
</form>
</body>
</HTML>
Ce qui précède est le contenu détaillé de. pour plus d'informations, suivez d'autres articles connexes sur le site Web de PHP en chinois!
Comment revenir à la page d'accueil à partir d'une sous-page HTML
utilisation du curseur Oracle
Comment habiller Douyin Xiaohuoren
Pilote de carte son pour ordinateur portable HP
Tutoriel de configuration du mot de passe de démarrage de Windows 10
Utilisation d'indexof en Java
Comment arrêter setInterval
Comment exécuter le projet phpstudy
![[Web front-end] Démarrage rapide de Node.js](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
