mybatis+spring整合

一  需要的包

二 目录

三 代码

user.java

package com.duobang.sm.pojo;
import org.apache.ibatis.type.Alias;
//配置别名
@Alias(value = "user")
public class User {
private int id;
private int password;
private String username;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public int getPassword() {
return password;
}
public void setPassword(int password) {
this.password = password;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
@Override
public String toString() {
return "User [>
}

usermapper.java

package com.duobang.sm.mapper;
import java.util.List;
import java.util.Map;
import org.apache.ibatis.annotations.MapKey;
import com.duobang.sm.pojo.User;
public interface UserMapper {
public User getUser(int id);
public void insertUser(User user);
public int updateUser(User user);
public int deleteUser(int id);
public List<User> getUserList();
@MapKey("username")
public Map<Integer, User> getUserMap();
}

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.duobang.sm.mapper.UserMapper">
<!-- 查询学生，根据id -->
<select >select * from user</sql>
</mapper>  

spring-config.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"
xsi:schemaLocation="http://www.springframework.org/schema/beans
  http://www.springframework.org/schema/beans/spring-beans.xsd">


<!-- 配置连接池 -->
<bean ></bean>
</beans>

mybatis-sonfig.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>
  <package name="com.duobang.sm.pojo"/>
</typeAliases>
<mappers>
<mapper resource="com/duobang/sm/mapper/UserMapper.xml"/>
</mappers>


</configuration>

Test.java

package com.duobang.sm.test;
import java.util.Arrays;
import java.util.List;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import com.duobang.sm.mapper.UserMapper;
import com.duobang.sm.pojo.User;
public class Test {
static ClassPathXmlApplicationContext context = new ClassPathXmlApplicationContext("spring-config.xml");


public static void main(String[] args) {
UserMapper mapper = context.getBean(UserMapper.class);
List<User> userList = mapper.getUserList();
System.out.println(Arrays.toString(userList.toArray()));
}
}