SSM简单整合

来源:互联网 发布:淘宝运营浏览器插件 编辑:程序博客网 时间:2024/06/05 18:34

开发环境:JDK1.6 TOMCAT 7.0 MYSQL5.5 MyEclipse10


目录如下:


数据库如下:

User类:

package com.zh.pojo;public class User {private Integer id;private String username;private String password;private Integer age;public Integer getId() {return id;}public void setId(Integer id) {this.id = id;}public String getUsername() {return username;}public void setUsername(String username) {this.username = username;}public String getPassword() {return password;}public void setPassword(String password) {this.password = password;}public Integer getAge() {return age;}public void setAge(Integer age) {this.age = age;}}
UserServiceImpl类:

package com.zh.service.impl;import javax.annotation.Resource;import org.springframework.stereotype.Service;import com.zh.dao.IUserDao;import com.zh.pojo.User;import com.zh.service.IUserService;@Service("userService")public class UserServiceImpl implements IUserService {@Resource    private IUserDao userDao;@Overridepublic User getUserById(int id) { return userDao.findUserById(id);}}
IUserDao类:

package com.zh.dao;import com.zh.pojo.User;public interface IUserDao {User findUserById(Integer id);}
UserMapper.xml:

<?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.zh.dao.IUserDao">    <resultMap id="BaseResultMap" type="com.zh.pojo.User">        <id column="id" property="id" jdbcType="INTEGER"/>        <result column="username" property="username" jdbcType="VARCHAR"/>        <result column="password" property="password" jdbcType="VARCHAR"/>        <result column="age" property="age" jdbcType="INTEGER"/>    </resultMap>    <sql id="Base_Column_List">        id, username, password, age    </sql>    <select id="findUserById" resultMap="BaseResultMap" parameterType="java.lang.Integer">        select        <include refid="Base_Column_List"/>        from user_t        where id = #{id}    </select></mapper>
UserController:

package com.zh.controller;import javax.annotation.Resource;import javax.servlet.http.HttpServletRequest;import org.springframework.stereotype.Controller;import org.springframework.ui.Model;import org.springframework.web.bind.annotation.RequestMapping;import com.zh.pojo.User;import com.zh.service.IUserService;@Controller  @RequestMapping("/user")  public class UserController {@Resource      private IUserService userService;            @RequestMapping("/index")      public String toIndex(HttpServletRequest request,Model model){          int userId = Integer.parseInt(request.getParameter("id"));          User user = this.userService.getUserById(userId);          model.addAttribute("user", user);          return "index";      }  }
jdbcConfig.properties:

classDriverName=com.mysql.jdbc.Driverurl=jdbc:mysql://localhost:3306/admin?useUnicode=true&characterEncoding=utf-8username=rootpassword=rootminPoolSize=1maxPoolSize=300maxIdleTime=60acquireIncrement=5initialPoolSize=1idleConnectionTestPeriod=60

applicationContext.xml:

<?xml version="1.0" encoding="UTF-8"?><beans xmlns="http://www.springframework.org/schema/beans"       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p"       xmlns:context="http://www.springframework.org/schema/context"       xmlns:mvc="http://www.springframework.org/schema/mvc"       xsi:schemaLocation="http://www.springframework.org/schema/beans                        http://www.springframework.org/schema/beans/spring-beans-3.1.xsd                        http://www.springframework.org/schema/context                        http://www.springframework.org/schema/context/spring-context-3.1.xsd                        http://www.springframework.org/schema/mvc                        http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">    <context:component-scan base-package="com.zh" />    <!--导入配置文件-->    <bean id="mysqlSource" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">        <property name="location" value="classpath:jdbcConfig.properties"></property>    </bean>    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">        <property name="driverClassName" value="${classDriverName}" />        <property name="url" value="${url}" />        <property name="username" value="${username}" />        <property name="password" value="${password}" />    </bean>    <!--spring mybatis的整合-->    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">        <property name="dataSource" ref="dataSource"/>        <property name="mapperLocations" value="classpath:*.xml" />    </bean>    <!-- DAO接口所在包名,Spring会自动查找其下的类 -->    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">        <property name="basePackage" value="com.zh.dao" />        <!--这里就是value,不要有疑问,真的-->        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" />    </bean>    <!-- (事务管理)transaction manager, use JtaTransactionManager for global tx -->    <bean id="transactionManager"          class="org.springframework.jdbc.datasource.DataSourceTransactionManager">        <property name="dataSource" ref="dataSource" />    </bean></beans>

springmvcConfig.xml

<?xml version="1.0" encoding="UTF-8"?><beans xmlns="http://www.springframework.org/schema/beans"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context"xmlns:aop="http://www.springframework.org/schema/aop" xmlns:mvc="http://www.springframework.org/schema/mvc"xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd  http://www.springframework.org/schema/aophttp://www.springframework.org/schema/aop/spring-aop-4.0.xsd  http://www.springframework.org/schema/mvchttp://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd "><context:annotation-config /><context:component-scan base-package="com.zh.controller"></context:component-scan><beanclass="org.springframework.web.servlet.view.InternalResourceViewResolver"><property name="prefix" value="/WEB-INF/jsp/" /><property name="suffix" value=".jsp" /></bean><mvc:annotation-driven><mvc:message-converters register-defaults="true"><beanclass="com.alibaba.fastjson.support.spring.FastJsonHttpMessageConverter"></bean></mvc:message-converters></mvc:annotation-driven><mvc:default-servlet-handler /></beans>

web.xml

<?xml version="1.0" encoding="UTF-8"?><web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xmlns="http://xmlns.jcp.org/xml/ns/javaee"xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd"id="WebApp_ID" version="3.1"><display-name>OASystem</display-name><welcome-file-list><welcome-file>index.jsp</welcome-file></welcome-file-list><filter><filter-name>CharacterEncodingFilter</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>CharacterEncodingFilter</filter-name><url-pattern>/*</url-pattern></filter-mapping><context-param><param-name>contextConfigLocation</param-name><param-value>WEB-INF/applicationContext.xml</param-value></context-param><context-param><param-name>log4jConfigLocation</param-name><param-value>classpass:log4j.properties</param-value></context-param><listener><listener-class>org.springframework.web.context.ContextLoaderListener</listener-class></listener><servlet><servlet-name>springmvc</servlet-name><servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class><init-param><param-name>contextConfigLocation</param-name><param-value>WEB-INF/springmvcConfig.xml</param-value></init-param><load-on-startup>1</load-on-startup></servlet><servlet-mapping><servlet-name>springmvc</servlet-name><url-pattern>/</url-pattern></servlet-mapping><servlet-mapping><servlet-name>default</servlet-name><url-pattern>*.js</url-pattern></servlet-mapping><servlet-mapping><servlet-name>default</servlet-name><url-pattern>*.css</url-pattern></servlet-mapping></web-app>

index.jsp:

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html>  <head>    <title>test</title>  </head>  <body>    ${user.username}  </body></html>





这样就搭建完成了,启动tomcat,在浏览器中输入localhost:8080/ssm/user/index?id=1


所有lib包:

lib打包下载

DEMO下载