项目结构
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:mybatis="http://mybatis.org/schema/mybatis-spring"
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://mybatis.org/schema/mybatis-spring http://mybatis.org/schema/mybatis-spring.xsd
http://www.alibaba.com/schema/stat http://www.alibaba.com/schema/stat.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd">
<bean class="com.alibaba.druid.pool.DruidDataSource" id="dataSource">
<property name="driverClassName" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://localhost:3306/cdxx?useUnicode=true&characterEncoding=utf8"/>
<property name="username" value="root"/>
<property name="password" value="root"/>
</bean>
<bean class="org.mybatis.spring.SqlSessionFactoryBean" id="sqlSessionFactory">
<property name="dataSource" ref="dataSource"/>
</bean>
<bean class="org.mybatis.spring.SqlSessionTemplate" id="sqlSessionTemplate">
<constructor-arg index="0" ref="sqlSessionFactory"/>
</bean>
<bean class="com.rr.tt.server.impl.UserServerImpl" id="userServer">
<property name="userMapper" ref="userMapper"/>
</bean>
<mybatis:scan base-package="com.rr.tt.mapper"/>
<bean class="org.springframework.jdbc.datasource.DataSourceTransactionManager" id="transactionManager">
<constructor-arg ref="dataSource"/>
</bean>
<tx:annotation-driven transaction-manager="transactionManager"></tx:annotation-driven>
</beans>
User
package com.rr.tt.entity;
import java.util.Date;
public class User {
private int id;
private String name;
private String pwd;
private Date date;
private int age;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPwd() {
return pwd;
}
public void setPwd(String pwd) {
this.pwd = pwd;
}
public Date getDate() {
return date;
}
public void setDate(Date date) {
this.date = date;
}
public int getAge() {
return age;
}
public void setAge(int age) {
this.age = age;
}
@Override
public String toString() {
return "User{" +
"id=" + id +
", name='" + name + '\'' +
", pwd='" + pwd + '\'' +
", date=" + date +
", age=" + age +
'}';
}
}
UserMapper
package com.rr.tt.mapper;
import com.rr.tt.entity.User;
import org.apache.ibatis.annotations.*;
import java.util.List;
/**
* @author rongbaba
*/
@Mapper
public interface UserMapper {
@Update("update t_user set name=#{name} where id=#{id}")
int update(User user);
@Delete("delete from t_user where id=#{id}")
int delete(int id);
@Insert("insert into t_user values (default ,#{name},#{pwd},#{birthday},#{age})")
int insert(User user);
@Select("select * from t_user")
List<User> selectall();
}
Test
package com.rr.tt;
import com.rr.tt.entity.User;
import com.rr.tt.server.UserServer;
import org.springframework.beans.factory.BeanFactory;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import java.util.List;
public class Test {
public static void main(String[] args) {
BeanFactory beanFactory=new ClassPathXmlApplicationContext
("ApplicationContext.xml");
UserServer userServer=beanFactory.getBean("userServer",UserServer.class);
List<User> users=userServer.selectall();
for (User user:users
) {
System.out.println(user);
}
}
}