mybatis增删改查综合案例

项目源码传送门：http://download.csdn.net/download/six_666666/10010095

项目框架                                                                                     数据库表

思路：

1、创建mybatis的主配置文件configuration.xml

2、创建工具类User.java

3、创建User.java的映射文件

4、创建测试类测试

代码部分

Configuration.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>

<!-- 为sql映射文件中的类型指定别名，如果不加alias，则整个包下的别名都是类名 -->

<typeAliases>

<typeAlias type="com.yw.bean.User" alias="User"/>

</typeAliases>

<environments default="development">

<environment id="development">

<transactionManager type="JDBC" />

<dataSource type="POOLED">

<property name="driver" value="com.mysql.jdbc.Driver" />

<property name="url" value="jdbc:mysql://localhost:3306/test" />

<property name="username" value="root" />

<property name="password" value="root" />

</dataSource>

</environment>

</environments>

<mappers>

<mapper resource="com/yw/bean/User.xml" />

</mappers>

</configuration>

User.java

package com.yw.bean;

public class User {

private String id;

private String name;

private String password;

private String address;

public String getId() {

return id;

}

public void setId(String id) {

this.id = id;

}

public String getName() {

return name;

}

public void setName(String name) {

this.name = name;

}

public String getPassword() {

return password;

}

public void setPassword(String password) {

this.password = password;

}

public String getAddress() {

return address;

}

public void setAddress(String address) {

this.address = address;

}

}

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.yw.bean.User">

<!-- 查询所有用户, resultType代表返回类型(一般写全限定类名，也可以在mybatis配置文件中指定别名)，parameterType代表参数类型 -->

<select id="selectAllUsers" resultType="User">

select * from user

</select>

<!-- 根据id查询用户 -->

<select id="findUserById" parameterType="int" resultType="User">

select * from user where id=#{id}

</select>

<!-- 根据id更新用户 -->

<update id="updateUserById" parameterType="User">

update user set name=#{name},address=#{address} where id=#{id}

</update>

<!-- 添加新用户 -->

<insert id="addUser" parameterType="User">

insert into user(id,name,password,address) values(#{id},#{name},#{password},#{address})

</insert>

<!-- 根据id删除用户 -->

<delete id="deleteUserById" parameterType="int">

delete from user where id=#{id}

</delete>

</mapper>

Test.java

package com.yw.test;

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;

import com.yw.bean.User;

public class Test {

private static SqlSessionFactory sqlSessionFactory;

private static Reader reader;

static {

try {

reader = Resources.getResourceAsReader("Configuration.xml");

sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);

} catch (Exception e) {

e.printStackTrace();

}

}

/**

* 查询所有User对象

* @param id

*/

public static void selectAllUsers() {

SqlSession session = sqlSessionFactory.openSession();

try {

List<User> listUsers = session.selectList("com.yw.bean.User.selectAllUsers");

for (User user:listUsers) {

System.out.println("ID：" + user.getId() + ",姓名：" + user.getName() + ",密码：" + user.getPassword() + ",住址：" + user.getAddress());

}

} finally {

session.close();

}

}

/**

* 根据id查询User对象

* @param id

*/

public static void findUserById(String id) {

SqlSession session = sqlSessionFactory.openSession();

try {

User user = (User) session.selectOne("com.yw.bean.User.findUserById", id);

System.out.println("ID：" + user.getId() + ",姓名：" + user.getName() + ",密码：" + user.getPassword() + ",住址：" + user.getAddress());

} finally {

session.close();

}

}

/**

* 根据id更新User对象

* @param id

*/

public static void updateUserById(String id,User user) {

SqlSession session = sqlSessionFactory.openSession();

try {

session.update("com.yw.bean.User.updateUserById",user);

session.commit();

} finally {

session.close();

}

}

/**

* 添加一条User对象

*/

public static void addUser(User user) {

SqlSession session = sqlSessionFactory.openSession();

try {

session.insert("com.yw.bean.User.addUser",user);

session.commit();

} finally {

session.close();

}

}

/**

* 删除一条User对象

*/

public static void deleteUserById(String id) {

SqlSession session = sqlSessionFactory.openSession();

try {

session.delete("com.yw.bean.User.deleteUserById",id);

session.commit();

} finally {

session.close();

}

}

public static void main(String[] args) {

selectAllUsers();//查询所以数据

findUserById("2"); // 根据id查询数据

User user=new User();

user.setId("2");

user.setName("Zam");

user.setAddress("ZJ-HZ");

updateUserById("2",user); // 根据id修改数据

User add_user=new User();

add_user.setId("1");

add_user.setName("TOM");

add_user.setPassword("3412312");

add_user.setAddress("ZJ-HZ");

addUser(add_user); //添加数据

deleteUserById("1");//根据id删除数据

}

}