天气:阴天 心情:平常心 目前问题: 面临毕业, 找工作中
这是接着上一篇SSM+layui无分页数据显示的有分页数据的更新
主要功能展示图一:
一、我的项目目录结构图
具体实现步骤:
二: dao 文件 代码块 者里主要是写自已的一个方法 则
(注意:者个刀文件者里的代码可以省略,因为service 哪里有写 ,也可以通过 service 继承刀来实现,二者必须存在一个,也可以两者都写)
Hm:为自已写的一个Bean 的po 字段
public interface HorstroyDao {
public List<Hm> getuserlist();
}
三、到 mapping 这里主要是自已的XML文件,在这里写SQL语句
<!--这是有分页数据查询的历史数据 -->
<select id="getuserlist" resultType="com.gx.po.Hm">
<!-- 这查询历史数据的回填 -->
select pwcu.CultureName as cub,pwcuG.CultureName as
cug,pwms.MarryStateName as msb,pwmsG.MarryStateName as
msg,
pwna.NationalityName as nab,pwnaG.NationalityName as
nag,
mar.marriagenumberj,
boyname, girlsname,
boyidentitycard,girlsidentitycard
FROM sys_marry as mar,sys_boymessage
as sysB,pw_nationality as
pwna,pw_races as pwra,pw_occupation as pwocc,
pw_culture as
pwcu,pw_marrystate as pwms,pw_materials as pwmt,pw_user as pwu,sys_girlsmessage as
sysG,pw_culture as pwcuG,pw_races as
pwraG,pw_nationality as pwnaG,pw_occupation as pwoc