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 >
<settings >
<setting name ="logImpl" value ="log4j" />
</settings >
<typeAliases >
<package name ="com.hyq.modules.entity" />
</typeAliases >
</configuration >
spring-mvc.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:p ="http://www.springframework.org/schema/p"
xmlns:mvc ="http://www.springframework.org/schema/mvc" xmlns:tx ="http://www.springframework.org/schema/tx"
xsi:schemaLocation ="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc.xsd" >
<context:annotation-config />
<context:component-scan base-package ="com.hyq.modules" >
<context:exclude-filter type ="annotation"
expression ="org.springframework.stereotype.Service" />
</context:component-scan >
<mvc:annotation-driven />
<bean class ="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter" />
<bean id ="viewResolver"
class ="org.springframework.web.servlet.view.InternalResourceViewResolver" >
<property name ="prefix" value ="/WEB-INF/pages/" />
<property name ="suffix" value =".jsp" />
</bean >
</beans >
spring-mybatis.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:p ="http://www.springframework.org/schema/p"
xmlns:mvc ="http://www.springframework.org/schema/mvc" xmlns:tx ="http://www.springframework.org/schema/tx"
xsi:schemaLocation ="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc.xsd" >
<context:annotation-config />
<context:component-scan base-package ="com.hyq.modules.service" />
<context:property-placeholder location ="classpath:db.properties" />
<bean id ="dataSource" class ="com.mchange.v2.c3p0.ComboPooledDataSource"
destroy-method ="close" >
<property name ="driverClass" value ="${jdbc.driverClassName}" />
<property name ="jdbcUrl" value ="${jdbc.url}" />
<property name ="user" value ="${jdbc,user}" />
<property name ="password" value ="${jdbc.password}" />
<property name ="acquireIncrement" value ="5" />
<property name ="acquireRetryAttempts" value ="30" />
<property name ="acquireRetryDelay" value ="1000" />
<property name ="autoCommitOnClose" value ="false" />
<property name ="initialPoolSize" value ="30" />
<property name ="maxIdleTime" value ="6000" />
<property name ="maxPoolSize" value ="600" />
<property name ="idleConnectionTestPeriod" value ="360" />
</bean >
<bean id ="sqlSessionFactory" class ="org.mybatis.spring.SqlSessionFactoryBean" >
<property name ="dataSource" ref ="dataSource" />
<property name ="configLocation" value ="classpath:mybatis-config.xml" />
<property name ="mapperLocations" value ="classpath:com/hyq/modules/mapper/*.xml" > </property >
</bean >
<bean class ="org.mybatis.spring.mapper.MapperScannerConfigurer" >
<property name ="basePackage" value ="com.hyq.modules.dao" />
<property name ="sqlSessionFactoryBeanName" value ="sqlSessionFactory" > </property >
</bean >
<bean id ="transactionManager"
class ="org.springframework.jdbc.datasource.DataSourceTransactionManager" >
<property name ="dataSource" ref ="dataSource" />
</bean >
<tx:annotation-driven transaction-manager ="transactionManager" />
</beans >
数据源db.properties配置文件:
jdbc.driverClassName =com .mysql .jdbc .Driver
jdbc.url =jdbc:mysql://localhost:3306 /数据库名
jdbc.user =root
jdbc.password =密码
日志打印log4j.properties文件配置:
log4j.rootLogger =debug, console
log4j.appender .console =org.apache .log 4j.ConsoleAppender
log4j.appender .console .Target =System.out
log4j.appender .console .layout =org.apache .log 4j.PatternLayout
log4j.appender .console .layout .ConversionPattern =%d %5 p %c - %m%n
log4j.logger .org .mybatis =error
log4j.logger .org .myrobot .persist =debug
log4j.logger .org .myrobot .dao =debug
log4j.logger .org .myrobot .controller =error
log4j.logger .com .ibatis =error
log4j.logger .com .ibatis .common .jdbc .SimpleDataSource =error
log4j.logger .com .ibatis .common .jdbc .ScriptRunner =error
log4j.logger .com .ibatis .sqlmap .engine .impl .SqlMapClientDelegate =error
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 > ssm</display-name >
<filter >
<filter-name > CharacterFilter</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 > CharacterFilter</filter-name >
<url-pattern > /*</url-pattern >
</filter-mapping >
<context-param >
<param-name > contextConfigLocation</param-name >
<param-value > classpath:spring-*.xml</param-value >
</context-param >
<listener >
<listener-class > org.springframework.web.context.ContextLoaderListener</listener-class >
</listener >
<servlet >
<servlet-name > spring-mvc</servlet-name >
<servlet-class > org.springframework.web.servlet.DispatcherServlet</servlet-class >
<init-param >
<param-name > contextConfigLocation</param-name >
<param-value > classpath:spring-mvc.xml</param-value >
</init-param >
<load-on-startup > 1</load-on-startup >
</servlet >
<servlet-mapping >
<servlet-name > spring-mvc</servlet-name >
<url-pattern > /</url-pattern >
</servlet-mapping >
</web-app >
User实体:
、、、
UserController:
@Controller
@RequestMapping (value="/user" )
public class UserController {
@Resource (name="userService" )
private UserService userService;
@RequestMapping (value="form.do" )
public String form (Model model,String id){
User user = userService.findById(id);
model.addAttribute("user" , user);
return "userForm" ;
}
UserService:
@Service
@Transactional (readOnly=true )
public class UserService {
@Autowired
private UserDao userDao;
/**
* 根据id获取数据
* @param id
* @return
*/
public User findById (String id){
return userDao.getById(id);
}
}
UserDao:
@Repository
public interface UserDao {
/**
* 根据id找数据
* @param id
* @return
*/
public User getById (String id);
}
Mapper:
<?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.blm.modules.dao.UserDao" >
<select id ="getById" resultType ="user" >
select *
from `user`
where id = #{id}
</select >
</mapper >