SSM框架练习

SSM框架

在数据库中建立一张名为t_user的表，表中包含的字段如下表所示。 其中user_id是使用了序列。

model层

package lmz.ssmtest.model; public class User { private int userId; private String userName; private int userAge; public User() { super(); } public User(int userId, String userName) { super(); this.userId = userId; this.userName = userName; } public User(int userId, String userName, int userAge) { super(); this.userId = userId; this.userName = userName; this.userAge = userAge; } public int getUserId() { return userId; } public void setUserId(int userId) { this.userId = userId; } public String getUserName() { return userName; } public void setUserName(String userName) { this.userName = userName; } public int getUserAge() { return userAge; } public void setUserAge(int userAge) { this.userAge = userAge; } @Override public String toString() { return "User [userId=" + userId + ", userName=" + userName + ", userAge=" + userAge + "]"; } }

mapper层 UserMapper接口：

package lmz.ssmtest.mapper; import lmz.ssmtest.model.User; public interface UserMapper { // 删除操作是对id进行删除 boolean delete(int id); // 更新操作时，可以对实体类中的所有对象进行更新 boolean update(User user); void add(User user); // 通过id进行查询 User findById(int id); }

UserMapper接口的实现类：

<?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"> <!-- 配置映射器。oracle --> <mapper namespace="lmz.ssmtest.mapper.UserMapper"> <delete id="delete" parameterType="int"> delete from t_user where user_id=#{userId} </delete> <insert id="add" parameterType="User"> insert into t_user( user_id,user_name,user_age) values(SEQ_USER_ID.nextval,#{userName},#{userAge}) </insert> <update id="update" parameterType="User"> update t_user set user_name=#{userName},user_age=#{userAge} where user_id=#{userId} </update> <select id="findById" parameterType="int" resultType="User"> select user_id userId,user_name userName,user_age userAge from t_user where user_id=#{userId} </select> </mapper>

service层 service接口

package lmz.ssmtest.service; import lmz.ssmtest.model.User; public interface UserService { boolean delete(int id); boolean update(User user); void add(User user); User findById(int id); }

service接口的实现类

package lmz.ssmtest.service.impl; import javax.annotation.Resource; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import lmz.ssmtest.mapper.UserMapper; import lmz.ssmtest.model.User; import lmz.ssmtest.service.UserService; @Service @Transactional public class UserServiceImpl implements UserService{ @Resource private UserMapper mapper; @Override public boolean delete(int id) { return mapper.delete(id); } @Override public boolean update(User user) { return mapper.update(user); } @Override public void add(User user) { mapper.add(user); } @Override public User findById(int id) { return mapper.findById(id); } }

修改mybatis-config.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> <typeAliases> <typeAlias alias="User" type="lmz.ssmtest.model.User" /> </typeAliases> <!-- 实体接口映射资源。本例使用的是oracle --> <mappers> <mapper resource="lmz/ssmtest/mapper/UserMapper.xml"/> </mappers> </configuration>

修改spring-com.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:tx="http://www.springframework.org/schema/tx" 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/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd"> <!-- 基于xml配置文件配置bean --> <!-- 定义一个数据源 --> <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver" /> <property name="url" value="jdbc:oracle:thin:@localhost:1521/orcl" /> <property name="username" value="springdemo" /> <property name="password" value="123456" /> </bean> <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="dataSource" ref="dataSource"></property> <property name="configLocation" value="classpath:config/mybatis-config.xml" /> </bean> <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> <property name="basePackage" value="lmz.ssmtest.mapper"></property> <property name="sqlSessionFactory" ref="sqlSessionFactory"></property> </bean> <!-- 配置事务管理器 --> <bean id="txManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> <property name="dataSource" ref="dataSource"></property> </bean> <!-- 使用声明式事务 --> <tx:annotation-driven transaction-manager="txManager" /> </beans>

web.xml全局配置文件

<?xml version="1.0" encoding="UTF-8"?> <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" version="2.5"> <context-param> <param-name>contextConfigLocation</param-name> <param-value>classpath*:config/spring-*.xml</param-value> </context-param> <servlet> <servlet-name>springMVC</servlet-name> <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class> <init-param> <param-name>contextConfigLocation</param-name> <param-value>classpath*:config/spring-mvc.xml</param-value> </init-param> <load-on-startup>1</load-on-startup> </servlet> <servlet-mapping> <servlet-name>springMVC</servlet-name> <url-pattern>*.do</url-pattern> </servlet-mapping> <!-- spring环境加载监听器，用于加载spring配置文件及初始化spring运行环境 --> <listener> <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class> </listener> <!-- 自省清理监听器，用于清理spring运行时可能产生的内存泄漏 --> <listener> <listener-class>org.springframework.web.util.IntrospectorCleanupListener</listener-class> </listener> <filter> <filter-name>encodingFilter</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> <init-param> <param-name>forceEncoding</param-name> <param-value>true</param-value> </init-param> </filter> <filter-mapping> <filter-name>encodingFilter</filter-name> <url-pattern>/*</url-pattern> </filter-mapping> <!-- 登陆访问控制过滤器 --> <filter> <display-name>LoginFilter</display-name> <filter-name>LoginFilter</filter-name> <filter-class>com.neuedu.web.filter.LoginFilter</filter-class> </filter> <!-- 过虑所有需要控制的页面的访问，使这些页面只能通过controller进行访问 --> <filter-mapping> <filter-name>LoginFilter</filter-name> <url-pattern>/jsp/*</url-pattern> </filter-mapping> <welcome-file-list> <welcome-file>index.jsp</welcome-file> </welcome-file-list> </web-app>

测试

package ftest; import org.junit.Test; import org.junit.runner.RunWith; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.test.context.ContextConfiguration; import org.springframework.test.context.junit4.SpringJUnit4ClassRunner; import lmz.ssmtest.mapper.UserMapper; import lmz.ssmtest.model.User; @RunWith(SpringJUnit4ClassRunner.class) @ContextConfiguration("/config/spring-com.xml") public class UserTest { @Autowired private UserMapper mapper; @Test public void testAdd() { User user = new User(1, "admin", 20); mapper.add(user); } @Test public void testUpdate() { User user = new User(1, "nmnm", 22); mapper.update(user); } }