SSM框架整合之练习篇
程序员文章站
2022-04-16 08:15:24
SSM的练习 : 1开发环境 数据库:mysql5.5以上版本。 Jdk:1.7 开发环境:Eclipse mars2 Spring:4.2.4 Mybatis:3.2.7 Tomcat:7 2数据库 数据库使用mysql 数据库。 1、创建crm数据库 2、将参考资料中的sql脚本导入到数据库中 ... ......
ssm的练习 : 1开发环境 数据库:mysql5.5以上版本。 jdk:1.7 开发环境:eclipse mars2 spring:4.2.4 mybatis:3.2.7 tomcat:7 2数据库 数据库使用mysql 数据库。 1、创建crm数据库 2、将参考资料中的sql脚本导入到数据库中 3工程搭建 工程使用springmvc、spring、mybatis框架整合完成。 dao层:sqlmapconfig.xml(空) applicationcontext-dao.xml:数据库连接池、sqlsessionfactory、mapper的扫描器。 service层: 配置包扫描器,扫描所有带@service注解的类。事务管理器、切面。 表现层: springmvc.xml:包扫描器@controller、配置注解驱动、视图解析器。 jsp:bootstrap web.xml:配置spring监听器,前端控制器。 3.1sqlmapconfig.xml <?xml version="1.0" encoding="utf-8" ?> <!doctype configuration public "-//mybatis.org//dtd config 3.0//en" "http://mybatis.org/dtd/mybatis-3-config.dtd"> <configuration> </configuration> 3.2applicationcontext-dao.xml <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/xmlschema-instance" xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:context="http://www.springframework.org/schema/context" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:task="http://www.springframework.org/schema/task" xsi:schemalocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.2.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.2.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.2.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.2.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.2.xsd http://www.springframework.org/schema/task http://www.springframework.org/schema/task/spring-task-4.2.xsd"> <!-- 配置 读取properties文件 jdbc.properties --> <context:property-placeholder location="classpath:jdbc.properties" /> <!-- 配置 数据源 --> <bean id="datasource" class="com.alibaba.druid.pool.druiddatasource"> <!-- 驱动 --> <property name="driverclassname" value="${jdbc.driver}" /> <!-- url --> <property name="url" value="${jdbc.url}" /> <!-- 用户名 --> <property name="username" value="${jdbc.username}" /> <!-- 密码 --> <property name="password" value="${jdbc.password}" /> </bean> <!-- 配置 mybatis的工厂 --> <bean class="org.mybatis.spring.sqlsessionfactorybean"> <!-- 数据源 --> <property name="datasource" ref="datasource" /> <!-- 配置mybatis的核心 配置文件所在位置 --> <property name="configlocation" value="classpath:sqlmapconfig.xml" /> <!-- 配置pojo别名 --> <property name="typealiasespackage" value="cn.baidu.core.bean"></property> </bean> <!-- 配置 1:原始dao开发 接口实现类 mapper.xml 三个 2:接口开发 接口 不写实现类 mapper.xml 二个 (userdao、productdao 、branddao。。。。。。。) 3:接口开发、并支持扫描 cn.baidu.core.dao(userdao。。。。。) 写在此包下即可被扫描到 --> <bean class="org.mybatis.spring.mapper.mapperscannerconfigurer"> <property name="basepackage" value="cn.baidu.core.dao" /> </bean> </beans> jdbc.properties jdbc.driver=com.mysql.jdbc.driver jdbc.url=jdbc:mysql://localhost:3306/crm?characterencoding=utf-8 jdbc.username=root jdbc.password=root 3.3applicationcontext-service.xml <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/xmlschema-instance" xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:context="http://www.springframework.org/schema/context" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:task="http://www.springframework.org/schema/task" xmlns:dubbo="http://code.alibabatech.com/schema/dubbo" xsi:schemalocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.2.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.2.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.2.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.2.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.2.xsd http://www.springframework.org/schema/task http://www.springframework.org/schema/task/spring-task-4.2.xsd http://code.alibabatech.com/schema/dubbo http://code.alibabatech.com/schema/dubbo/dubbo.xsd"> <!-- 配置 扫描 @service --> <context:component-scan base-package="cn.baidu.core.service"/> </beans> 3.4applicationcontext-trans.xml <?xml version="1.0" encoding="utf-8"?> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:context="http://www.springframework.org/schema/context" xmlns:p="http://www.springframework.org/schema/p" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:xsi="http://www.w3.org/2001/xmlschema-instance" xsi:schemalocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.2.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.2.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.2.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.2.xsd http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-4.2.xsd"> <!-- 事务管理器 --> <bean id="transactionmanager" class="org.springframework.jdbc.datasource.datasourcetransactionmanager"> <!-- 数据源 --> <property name="datasource" ref="datasource" /> </bean> <!-- 通知 --> <tx:advice id="txadvice" transaction-manager="transactionmanager"> <tx:attributes> <!-- 传播行为 --> <tx:method name="save*" propagation="required" /> <tx:method name="insert*" propagation="required" /> <tx:method name="add*" propagation="required" /> <tx:method name="create*" propagation="required" /> <tx:method name="delete*" propagation="required" /> <tx:method name="update*" propagation="required" /> <tx:method name="find*" propagation="supports" read-only="true" /> <tx:method name="select*" propagation="supports" read-only="true" /> <tx:method name="get*" propagation="supports" read-only="true" /> </tx:attributes> </tx:advice> <!-- 切面 --> <aop:config> <aop:advisor advice-ref="txadvice" pointcut="execution(* cn.baidu.core.service.*.*(..))" /> </aop:config> </beans> 3.5springmvc.xml <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/xmlschema-instance" xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:context="http://www.springframework.org/schema/context" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:task="http://www.springframework.org/schema/task" xsi:schemalocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.2.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.2.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.2.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.2.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.2.xsd http://www.springframework.org/schema/task http://www.springframework.org/schema/task/spring-task-4.2.xsd"> <!-- 加载属性文件 --> <context:property-placeholder location="classpath:resource.properties"/> <!-- 配置扫描 器 --> <context:component-scan base-package="cn.baidu.core.web.controller"/> <!-- 配置处理器映射器 适配器 --> <mvc:annotation-driven/> <!-- 配置视图解释器 jsp --> <bean id="jspviewresolver" class="org.springframework.web.servlet.view.internalresourceviewresolver"> <property name="prefix" value="/web-inf/jsp/"/> <property name="suffix" value=".jsp"/> </bean> </beans> 3.6web.xml <?xml version="1.0" encoding="utf-8"?> <web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/xmlschema-instance" xsi:schemalocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"> <welcome-file-list> <welcome-file>customer.action</welcome-file> </welcome-file-list> <!-- 上下文的位置 --> <context-param> <param-name>contextconfiglocation</param-name> <param-value>classpath:applicationcontext-*.xml</param-value> </context-param> <!-- spring的监听器 --> <listener> <listener-class>org.springframework.web.context.contextloaderlistener</listener-class> </listener> <!-- post提交过滤器 utf-8 --> <filter> <filter-name>encoding</filter-name> <filter-class>org.springframework.web.filter.characterencodingfilter</filter-class> <init-param> <param-name>encoding</param-name> <param-value>utf-8</param-value> </init-param> </filter> <filter-mapping> <filter-name>encoding</filter-name> <url-pattern>*.action</url-pattern> </filter-mapping> <!-- 前端控制器 --> <servlet> <servlet-name>crm</servlet-name> <servlet-class>org.springframework.web.servlet.dispatcherservlet</servlet-class> <init-param> <param-name>contextconfiglocation</param-name> <!-- 此处不配置 默认找 /web-inf/[servlet-name]-servlet.xml --> <param-value>classpath:springmvc.xml</param-value> </init-param> <load-on-startup>1</load-on-startup> </servlet> <servlet-mapping> <servlet-name>crm</servlet-name> <!-- 1:*.do *.action 拦截以.do结尾的请求 (不拦截 jsp png jpg .js .css) 2:/ 拦截所有请求 (不拦截.jsp) 建议使用此种 方式 (拦截 .js.css .png) (放行静态资源) 3:/* 拦截所有请求(包括.jsp) 此种方式 不建议使用 --> <url-pattern>*.action</url-pattern> </servlet-mapping> </web-app> 3.7加入jsp及分页标签 tld文件需要放到web-inf目录下, tomcat的规定。当tomcat启动时会自动加载。 jsp中使用标签: 4查询条件初始化 4.1需求 初始化查询条件下拉列表。 4.2sql select * from base_dict where dict_type_code='006' 4.3dao <?xml version="1.0" encoding="utf-8" ?> <!doctype mapper public "-//mybatis.org//dtd mapper 3.0//en" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="com.baidu.crm.dao.basedictdao"> <select id="getbasedictlist" parametertype="string" resulttype="basedict"> select * from base_dict where dict_type_code=#{typecode} </select> </mapper> 4.4service @service public class basedictserviceimpl implements basedictservice { @autowired private basedictdao basedictdao; @override public list<basedict> getbasedictlist(string typecode) { list<basedict> list = basedictdao.getbasedictlist(typecode); return list; } } 4.5controller 规则:子容器可以访问父容器的对象,父容器不能访问子容器的对象。 public class customercontroller { @autowired private basedictservice basedictservice; @value("${customer.source.code}") private string customersourcecode; @value("${customer.industry.code}") private string customerindustrycode; @value("${customer.level.code}") private string customerlevelcode; @requestmapping("/list") public string showcustomerlist(model model) { //查询字典表初始化下拉列表 list<basedict> custsourcelist = basedictservice.getbasedictlist(customersourcecode); list<basedict> custindustrylist = basedictservice.getbasedictlist(customerindustrycode); list<basedict> custlevellist = basedictservice.getbasedictlist(customerlevelcode); //把列表传递给jsp页面 model.addattribute("fromtype", custsourcelist); model.addattribute("industrytype", custindustrylist); model.addattribute("leveltype", custlevellist); return "customer"; } } 5客户列表展示 5.1需求 展示商品列表,并且可以根据查询条件过滤查询结果,并且实现分页处理。 5.2sql select a.cust_id, a.cust_name, a.cust_user_id, a.cust_create_id, b.dict_item_name cust_source, c.dict_item_name cust_industry, d.dict_item_name cust_level, a.cust_linkman, a.cust_phone, a.cust_mobile, a.cust_zipcode, a.cust_address, a.cust_createtime from customer a left join base_dict b on a.cust_source = b.dict_id left join base_dict c on a.cust_industry = c.dict_id left join base_dict d on a.cust_level = d.dict_id where cust_name like '%马%' and cust_source = 6 and cust_industry = 2 and cust_level = 22 5.3dao <select id="getcustlist" parametertype="queryvo" resulttype="customer"> select a.cust_id, a.cust_name, a.cust_user_id, a.cust_create_id, b.dict_item_name cust_source, c.dict_item_name cust_industry, d.dict_item_name cust_level, a.cust_linkman, a.cust_phone, a.cust_mobile, a.cust_zipcode, a.cust_address, a.cust_createtime from customer a left join base_dict b on a.cust_source = b.dict_id left join base_dict c on a.cust_industry = c.dict_id left join base_dict d on a.cust_level = d.dict_id <where> <if test="custname!=null and custname!=''"> and cust_name like '%${custname}%' </if> <if test="custsource!=null and custsource!=''"> and cust_source = #{custsource} </if> <if test="custindustry!=null and custindustry!=''"> and cust_industry = #{custindustry} </if> <if test="custlevel!=null and custlevel!=''"> and cust_level = #{custlevel} </if> </where> limit #{start},#{rows} </select> 增加count后的dao <mapper namespace="com.baidu.crm.dao.customerdao"> <sql id="cust_query_where"> <where> <if test="custname!=null and custname!=''"> and cust_name like '%${custname}%' </if> <if test="custsource!=null and custsource!=''"> and cust_source = #{custsource} </if> <if test="custindustry!=null and custindustry!=''"> and cust_industry = #{custindustry} </if> <if test="custlevel!=null and custlevel!=''"> and cust_level = #{custlevel} </if> </where> </sql> <select id="getcustlist" parametertype="queryvo" resulttype="customer"> select a.cust_id, a.cust_name, a.cust_user_id, a.cust_create_id, b.dict_item_name cust_source, c.dict_item_name cust_industry, d.dict_item_name cust_level, a.cust_linkman, a.cust_phone, a.cust_mobile, a.cust_zipcode, a.cust_address, a.cust_createtime from customer a left join base_dict b on a.cust_source = b.dict_id left join base_dict c on a.cust_industry = c.dict_id left join base_dict d on a.cust_level = d.dict_id <include refid="cust_query_where"/> limit #{start},#{rows} </select> <select id="getcustlistcount" parametertype="queryvo" resulttype="int"> select count(*) from customer a left join base_dict b on a.cust_source = b.dict_id left join base_dict c on a.cust_industry = c.dict_id left join base_dict d on a.cust_level = d.dict_id <include refid="cust_query_where"/> </select> </mapper> 5.4service 根据查询条件查询数据库得到客户列表。分页条件。 接收查询条件queryvo接收,使用page接收页码。 1、通过page计算start。 2、调用dao查询客户列表。 3、做count处理。计算出此查询条件*查询到多少条记录。 返回结果:page对象。 条件:queryvo @service public class customerserviceimpl implements customerservice { @autowired private customerdao customerdao; @override public page<customer> getcustlist(queryvo queryvo) { queryvo.setstart((queryvo.getpage() - 1) * queryvo.getrows()); list<customer> custlist = customerdao.getcustlist(queryvo); page<customer> page = new page<customer>(); //设置客户列表 page.setrows(custlist); page.setpage(queryvo.getpage()); page.setsize(queryvo.getrows()); //计算查询总记录数 int total = customerdao.getcustlistcount(queryvo); page.settotal(total); return page; } } 5.5controller 5.5.1分析 1、接收页面提交的查询参数: 保证jsp页面提交的表单中的input 的name属性和queryvo中的属性一致 2、调用service查询客户列表 3、把客户列表传递给页面。 @requestmapping("/list") public string showcustomerlist(model model, queryvo queryvo) throws exception { string custname = queryvo.getcustname(); if (custname != null && !"".equals(custname)) { custname = new string(custname.getbytes("iso8859-1"), "utf-8"); queryvo.setcustname(custname); } //查询字典表初始化下拉列表 list<basedict> custsourcelist = basedictservice.getbasedictlist(customersourcecode); list<basedict> custindustrylist = basedictservice.getbasedictlist(customerindustrycode); list<basedict> custlevellist = basedictservice.getbasedictlist(customerlevelcode); //查询客户列表 page<customer> page = customerservice.getcustlist(queryvo); //把page放到request中 model.addattribute("page", page); //把列表传递给jsp页面 model.addattribute("fromtype", custsourcelist); model.addattribute("industrytype", custindustrylist); model.addattribute("leveltype", custlevellist); //页面回显 model.addattribute("custname", queryvo.getcustname()); model.addattribute("custsource", queryvo.getcustsource()); model.addattribute("custindustry", queryvo.getcustindustry()); model.addattribute("custlevel", queryvo.getcustlevel()); return "customer"; } 6修改客户信息 6.1需求 1、点击客户列表中的“修改”按钮弹出客户信息修改对话框,并初始化客户信息 2、点击“保存修改”按钮将修改后的结果保存到数据库中 6.2展示客户信息 6.2.1分析 请求的url: customer/edit.action 参数:cust_id客户id 返回值:响应json数据,直接由customer转换而来。需要使用@responsebody注解。 6.2.2dao层 根据客户id查询客户信息。 <select id="getcustomerbyid" parametertype="long" resulttype="customer"> select * from customer where cust_id = #{custid} </select> 6.2.3service层 @override public customer getcustomerbyid(long custid) { customer customer = customerdao.getcustomerbyid(custid); return customer; } 6.2.4controller 要求返回json数据 请求的url: customer/edit.action 参数:cust_id客户id 返回值:响应json数据 @requestmapping("/edit") @responsebody public customer getcustomerbyid(long id) { customer customer = customerservice.getcustomerbyid(id); return customer; } 6.3提交修改 6.3.1分析 请求的url:customer/update.action 请求的方法:post 参数:表单中的数据。 返回结果:ok 6.3.2dao层 <update id="updatecustomerbyid" parametertype="customer"> update customer <set> <if test="cust_name!=null"> cust_name=#{cust_name}, </if> <if test="cust_user_id!=null"> cust_user_id=#{cust_user_id}, </if> <if test="cust_create_id!=null"> cust_create_id=#{cust_create_id}, </if> <if test="cust_source!=null"> cust_source=#{cust_source}, </if> <if test="cust_industry!=null"> cust_industry=#{cust_industry}, </if> <if test="cust_level!=null"> cust_level=#{cust_level}, </if> <if test="cust_linkman!=null"> cust_linkman=#{cust_linkman}, </if> <if test="cust_phone!=null"> cust_phone=#{cust_phone}, </if> <if test="cust_mobile!=null"> cust_mobile=#{cust_mobile}, </if> <if test="cust_zipcode!=null"> cust_zipcode=#{cust_zipcode}, </if> <if test="cust_address!=null"> cust_address=#{cust_address}, </if> <if test="cust_createtime!=null"> cust_createtime=#{cust_createtime}, </if> </set> where cust_id = #{cust_id} </update> 6.3.3service层 @override public void updatecustomerbyid(customer customer) { customerdao.updatecustomerbyid(customer); } 6.3.4controller 接收参数:customer接收。 响应结果:ok字符串。使用@responsebody 请求的url:customer/update.action @requestmapping(value="/update", method=requestmethod.post) @responsebody public string updatecustomer(customer customer) { customerservice.updatecustomerbyid(customer); //直接向浏览器响应字符串需要使用@responsebody return "ok"; } 7删除客户 7.1需求 点击客户列表中的删除按钮,提示“警告信息” 点击确定后删除用户信息,并刷新页面。 分析: 请求的url:customer/delete.action 参数:id(客户id) 响应的内容:ok(字符串需要使用@responsebody)
上一篇: 教你4步写好文章标题