执行到service 无法写入数据库,不报错。代码如下:
<?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="app.login.dao.UserDao">
<resultMap type="app.login.domain.User" id="userResult">
<result property="id" column="id" jdbcType="INTEGER" javaType="java.lang.Integer" />
<result property="username" column="username" />
<result property="password" column="password" />
</resultMap>
<select id="queryUserForLogin" parameterType="user" resultMap="userResult">
select * from user
where
username=#{username} and password=#{password}
</select>
<select id="selectAllUser" resultMap="userResult">
select * from user
</select>
<?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="app.login.domain.User"/>
<typeAlias alias="sysLog" type="app.log.domain.SysLog"/>
</typeAliases>
<mappers>
<mapper resource="app/login/domain/User.xml" />
<mapper resource="app/log/domain/SysLog.xml" />
</mappers>
</configuration>
ackage app.log.dao;
import java.util.List;
import app.log.domain.SysLog;
public interface ILogDao {
public abstract void insertLog(SysLog sysLog);
ackage app.log.dao;
import java.util.List;
import app.log.domain.SysLog;
public interface ILogDao {
public abstract void insertLog(SysLog sysLog);
public abstract void updateLog(SysLog sysLog);
public abstract void deleteLog(SysLog sysLog);
public abstract List<SysLog> findAll();
}
package app.log.service.impl;
import java.util.List;
import app.log.dao.ILogDao;
import app.log.domain.SysLog;
import app.log.service.ILogService;
public class LogService implements ILogService {
private ILogDao logDao;
@Override
public void addLog(SysLog sysLog) {
// TODO Auto-generated method stub
System.out.println("addLog service.....");
logDao.insertLog(sysLog);
System.out.println("addLog service over.....");
}
@Override
public void updateLog(SysLog sysLog) {
// TODO Auto-generated method stub
logDao.updateLog(sysLog);
}
@Override
public void deleteLog(SysLog sysLog) {
// TODO Auto-generated method stub
logDao.deleteLog(sysLog);
}
@Override
public List<SysLog> findAllUser() {
// TODO Auto-generated method stub
return logDao.findAll();
}
public ILogDao getLogDao() {
return logDao;
}
public void setLogDao(ILogDao logDao) {
this.logDao = logDao;
}
}
<?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:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop-3.0.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-3.0.xsd">
<!-- 数据库配置文件位置 -->
<context:property-placeholder location="classpath:jdbc.properties" />
<!-- 配置dbcp数据源 -->
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName" value="${jdbc.driverClassName}" />
<property name="url" value="${jdbc.url}" />
<property name="username" value="${jdbc.username}" />
<property name="password" value="${jdbc.password}" />
<!-- 队列中的最小等待数 -->
<property name="minIdle" value="${jdbc.minIdle}"></property>
<!-- 队列中的最大等待数 -->
<property name="maxIdle" value="${jdbc.maxIdle}"></property>
<!-- 最长等待时间,单位毫秒 -->
<property name="maxWait" value="${jdbc.maxWait}"></property>
<!-- 最大活跃数 -->
<property name="maxActive" value="${jdbc.maxActive}"></property>
<property name="initialSize" value="${jdbc.initialSize}"></property>
</bean>
<!-- 配置mybitasSqlSessionFactoryBean -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<property name="configLocation" value="classpath:mybatis.xml"></property>
</bean>
<bean id="userDao" class="org.mybatis.spring.mapper.MapperFactoryBean">
<property name="mapperInterface" value="app.login.dao.UserDao"/>
<property name="sqlSessionFactory" ref="sqlSessionFactory" />
</bean>
<bean id="userService" class=" app.login.service.impl.UserService">
<property name="userDao" ref="userDao"></property>
</bean>
<bean id="loginAction" class="app.login.action.LoginAction">
<property name="userService" ref="userService"></property>
</bean>
<bean id="logDao" class="org.mybatis.spring.mapper.MapperFactoryBean">
<property name="mapperInterface" value="app.log.dao.ILogDao"/>
<property name="sqlSessionFactory" ref="sqlSessionFactory" />
</bean>
<bean id="logService" class=" app.log.service.impl.LogService">
<property name="logDao" ref="logDao"></property>
</bean>
</beans>