MyBatis
我们在resources下创建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: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-3.2.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd"
>
<!--自动扫描-->
<context:component-scan base-package="com.github.houshuai"/>
<!-- 第一种方式:加载一个properties文件-->
<bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="location" value="classpath:jdbc.properties"/>
</bean>
<!--<!–第二种方式:加载多个properties文件–>-->
<!--<bean id="configProperties" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">-->
<!--<property name="locations">-->
<!--<list>-->
<!--<value>classpath:jdbc.properties</value>-->
<!--<value>classpath:log4j.properties</value>-->
<!--</list>-->
<!--</property>-->
<!--<property name="fileEncoding" value="UTF-8"/>-->
<!--</bean>-->
<!--配置数据“库-->
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName" value="${driverClasss}"/>
<property name="url" value="${jdbcUrl}"/>
<property name="username" value="${username}"/>
<property name="password" value="${password}"/>
<!--初始化连接大小-->
<property name="initialSize" value="${initialSize}"/>
<!-- 连接池最大数量 -->
<property name="maxActive" value="${maxActive}"/>
<!-- 连接池最大空闲 -->
<property name="maxIdle" value="${maxIdle}"/>
<!-- 连接池最小空闲 -->
<property name="minIdle" value="${minIdle}"/>
<!-- 获取连接最大等待时间 -->
<property name="maxWait" value="${maxWait}"/>
</bean>
<!--mybatis和Spring完美整合 ,不需要mybatis的配置映射文件-->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource"/>
<!--自动扫描mapping.xml文件-->
<property name="mapperLocations" value="classpath:mapping/*.xml"/>
</bean>
<!--DAO接口所在包名,Spring会自动查到旗下的类-->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.github.houshuai.dao"/>
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
</bean>
<!--(事务管理)transction manager , use JtaTranscationManager for global tx-->
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"/>
</bean>
<!--(事务管理)transcation manager ,use JtaTransctaionManager for global tx-->
<tx:annotation-driven transaction-manager="transactionManager"/>
</beans>
对应的jdbc.propeties 配置元素如下:
driverClasss=com.mysql.jdbc.Driver
jdbcUrl=jdbc:mysql://localhost:3306/togetherlife_user?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull
username=root
password=houshuai
#定义初始连接数
initialSize=0
#定义最大连接数
maxActive=20
#定义最大空闲
maxIdle=20
#定义最小空闲
minIdle=1
#定义最长等待时间
maxWait=60000
注意jdbcUrl:需要改为自己本地对应的MySql的datasource的name。
对应的Sql的建表语句为:
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `t_user`
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
`id` bigint(11) NOT NULL auto_increment,
`user_name` varchar(255) default NULL COMMENT '用户名',
`user_phone` varchar(20) default NULL COMMENT '手机号',
`user_email` varchar(255) default NULL COMMENT '邮箱地址',
`user_pwd` varchar(32) default NULL COMMENT '加盐后用户密码',
`pwd_salt` varchar(6) default NULL COMMENT 'MD5盐',
`create_time` datetime default NULL COMMENT '创建时间',
`modify_time` datetime default NULL COMMENT '最后修改时间',
`is_delete` tinyint(4) default NULL COMMENT '是否删除,0-未删除;1-已删除',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='用户登录表';
-- ----------------------------
-- Records of t_user
-- ----------------------------
INSERT INTO `t_user` VALUES ('1', '赵大宝', '13285250574', '1045221654@qq.com', '05126a423a9379d529e4ee61a212fa55', 'KJUYT5', '2016-07-15 23:38:56', '2016-07-15 23:39:09', '0');
INSERT INTO `t_user` VALUES ('2', '张三丰', '15985250574', '1198224554@qq.com', '98bd3a1bebde01ad363d3c5a0d1e56da', '656JHU', '2016-07-15 23:39:01', '2016-07-15 23:39:13', '0');
INSERT INTO `t_user` VALUES ('3', '王尼玛', '13685250574', '1256221654@qq.com', '5470db9b63c354f6c8d628b80ae2f3c3', '89UIKQ', '2016-07-15 23:39:05', '2016-07-15 23:39:16', '0');
我们Mybatis对应的映射数据库操作的Xml :这里定位的名字为mapping/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.github.houshuai.dao.UserDao">
<resultMap id="UserBaseMap" type="com.github.houshuai.modle.User">
<id column="id" property="id" jdbcType="BIGINT"/>
<result column="user_name" property="userName" jdbcType="VARCHAR"/>
<result column="user_phone" property="userPhone" jdbcType="VARCHAR"/>
<result column="user_email" property="userEmail" jdbcType="VARCHAR"/>
<result column="user_pwd" property="userPwd" jdbcType="VARCHAR"/>
<result column="pwd_salt" property="pwdSalt" jdbcType="VARCHAR"/>
<result column="create_time" property="createTime" jdbcType="DATE"/>
<result column="modify_time" property="modifyTime" jdbcType="DATE"/>
<result column="is_delete" property="isDelete" jdbcType="SMALLINT"></result>
</resultMap>
<select id="selectUserById" parameterType="java.lang.Long" resultMap="UserBaseMap">
SELECT * FROM t_user
WHERE id = #{userId}
</select>
<select id="selectUserByPhoneOrEmail" resultMap="UserBaseMap">
SELECT * FROM t_user
WHERE user_email = #{emailOrPhone} OR user_phone = #{emailOrPhone}
AND user_state = #{state}
</select>
<select id="selectAllUser" resultMap="UserBaseMap">
SELECT * FROM t_user
</select>
</mapper>
Spring-mvc的对应配置
我们创建一个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"
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-3.2.xsd">
<!--此Bean应用于SpringMvc-->
<!--自动扫描 @controller-->
<context:component-scan base-package="com.github.houshuai.controller"/>
<!--避免IE执行AJAX 返回Json出现下载文件-->
<bean id="mappingJacksonHttpMessageConvertor"
class="org.springframework.http.converter.json.MappingJackson2HttpMessageConverter">
<property name="supportedMediaTypes">
<list>
<value>text/html;charset=UTF-8</value>
</list>
</property>
</bean>
<!--定义跳转的文件的前后缀,视图模式配置-->
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/WEB-INF/jsp/"/>
<property name="suffix" value=".jsp"/>
</bean>
<!--文件上传配置-->
<bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver">
<!--默认编码-->
<property name="defaultEncoding" value="UTF-8"/>
<!--上传文件大小限制为31M,31*1024*1024-->
<property name="maxUploadSize" value="32505856"/>
<!--内存中最大值-->
<property name="maxInMemorySize" value="4096"/>
</bean>
</beans>
Log的配置
我们创建一个log4j.properties来设置我们的log输出位置和输出格式
log4j.rootLogger=INFO,Console,File
#控制台日志
log4j.appender.Console=org.apache.log4j.ConsoleAppender
log4j.appender.Console.Target=System.out
log4j.appender.Console.layout=org.apache.log4j.PatternLayout
log4j.appender.Console.layout.ConversionPattern=[%p][%t][%d{yyyy-MM-dd HH\:mm\:ss}][%C] - %m%n
#普通文件日志
log4j.appender.File=org.apache.log4j.RollingFileAppender
log4j.appender.File.File=logs/ssm.log
log4j.appender.File.MaxFileSize=10MB
#输出日志,如果换成DEBUG表示输出DEBUG以上级别日志
log4j.appender.File.Threshold=ALL
log4j.appender.File.layout=org.apache.log4j.PatternLayout
log4j.appender.File.layout.ConversionPattern=[%p][%t][%d{yyyy-MM-dd HH\:mm\:ss}][%C] - %m%n
需要注意log4j.appender.File.File下的文件必须存在,否则会报错。