mybatis中单表的CRUD

smith88

1.所需jar包
    mybatis-3.1.1.jar
   mysql-connector-java-5.1.18-bin.jar
2.jdbc.properties
driverClass=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/test
username=root
password=root

3.User.java
package com.mybatils.model;
public class User {
private int uid ;
public int getUid() {
return uid;
}
public void setUid(int uid) {
this.uid = uid;
}
private String username;
private String passwd ;
private String nickname;
private int type ;
private int status;
public int getType() {
return type;
}
public void setType(int type) {
this.type = type;
}
public int getStatus() {
return status;
}
public void setStatus(int status) {
this.status = status;
}
public String getNickname() {
return nickname;
}
public void setNickname(String nickname) {
this.nickname = nickname;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPasswd() {
return passwd;
}
public void setPasswd(String passwd) {
this.passwd = passwd;
}
}

4.User.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.mybatils.model.User">
<insert id="add" parameterType="com.mybatils.model.User">
insert into m_user (
username,passwd,nickname,type,status
)
values (#{username},#{passwd},#{nickname},#{type},#{status})
</insert>
<delete id="delete" parameterType="int">
delete from m_user where uid=#{uid}
</delete>
<update id="update" parameterType="com.mybatils.model.User">
update m_user set username=#{username},nickname=#{nickname} where uid=#{uid}
</update>
<select id="loadById" parameterType="int" resultType="com.mybatils.model.User">
select * from m_user where uid=#{uid}
</select>
<select id="list" resultType="com.mybatils.model.User">
select * from m_user
</select>
</mapper>
5.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>
<properties resource="jdbc.properties" />
<environments default="development">
<environment id="development">
<transactionManager type="JDBC" />
<dataSource type="POOLED">
<property name="driver" value="${driverClass}" />
<property name="url" value="${url}" />
<property name="username" value="${username}" />
<property name="password" value="${password}" />
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="com/mybatils/model/User.xml"/>
</mappers>
</configuration>


6.UserTest.java

package com.mybatils.client;
import java.io.IOException;
import java.io.Reader;
import java.util.List;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
public class UserTest {
/**
* @param args
*/
public static void main(String[] args) {
//add();
//delete();
//update();
//load();
//list();
}
public static void list(){
String resource = "mybatis-config.xml";
Reader reader;
SqlSession session = null;
List<com.mybatils.model.User> users =null;
try {
reader = Resources.getResourceAsReader(resource);
SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(reader);
session= factory.openSession();
users = session.selectList("com.mybatils.model.User.list");
session.commit();
} catch (IOException e) {
e.printStackTrace();
}finally{
if(session!=null)
session.close();
}
for(com.mybatils.model.User u :users){
System.out.print(u.getNickname());
System.out.println("" + u.getUsername());
}

}
public static void load(){
String resource = "mybatis-config.xml";
Reader reader;
SqlSession session = null;
com.mybatils.model.User u =null;
try {
reader = Resources.getResourceAsReader(resource);
SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(reader);
session= factory.openSession();
u =session.selectOne("com.mybatils.model.User.loadById", 5);
session.commit();
} catch (IOException e) {
e.printStackTrace();
}finally{
if(session!=null)
session.close();
}
System.out.println(u.getNickname());
System.out.println(u.getUsername());
}
public static void update(){
String resource = "mybatis-config.xml";
Reader reader;
SqlSession session = null;
try {
com.mybatils.model.User u = new com.mybatils.model.User();
u.setUsername("aaa");
u.setNickname("测试一");
u.setUid(5);
reader = Resources.getResourceAsReader(resource);
SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(reader);
session= factory.openSession();
session.update("com.mybatils.model.User.update", u);
session.commit();
} catch (IOException e) {
e.printStackTrace();
}finally{
if(session!=null)
session.close();
}
}
public static void delete(){
String resource = "mybatis-config.xml";
Reader reader;
SqlSession session = null;
try {
reader = Resources.getResourceAsReader(resource);
SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(reader);
session= factory.openSession();
session.delete("com.mybatils.model.User.delete", 10);
session.commit();
} catch (IOException e) {
e.printStackTrace();
}finally{
if(session!=null)
session.close();
}
}
public static void add(){
String resource = "mybatis-config.xml";
Reader reader;
SqlSession session = null;
com.mybatils.model.User u = new com.mybatils.model.User();
u.setUsername("akkk");
u.setPasswd("1112");
u.setNickname("不是  ");
u.setType(0);
u.setStatus(1);
try {
reader = Resources.getResourceAsReader(resource);
SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(reader);
session= factory.openSession();
session.insert("com.mybatils.model.User.add", u);
session.commit();
} catch (IOException e) {
e.printStackTrace();
}finally{
if(session!=null)
session.close();
}
}
}