MyBatis3.1.1 增上改查源码实例
1. mybatis.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> <typeAlias type="com.ibatis.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/testdb"/><property name="username" value="csz"/><property name="password" value="csz"/></dataSource></environment></environments> <mappers><mapper resource="com/ibatis/bean/SqlMapper.xml"/></mappers></configuration>
2. User.java类
package com.ibatis.bean;import java.io.Serializable;public class User implements Serializable {private static final long serialVersionUID = 4054639727225043549L;int id;String username;String password;public User() {super();}public User(int id, String username, String password) {super();this.id = id;this.username = username;this.password = password;}public int getId() {return id;}public void setId(int id) {this.id = id;}public String getUsername() {return username;}public void setUsername(String username) {this.username = username;}public String getPassword() {return password;}public void setPassword(String password) {this.password = password;}}
3. SqlMapper.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.ibatis.mapper.ObjectMapper"><insert id="insertUser" parameterType="User"> insert into user(username, password) values(#{username}, #{password})</insert> <delete id="deleteUser" parameterType="int" > delete from user where id = #{id} </delete> <update id="updateUser" parameterType="User" > update user set password = #{password} where id = #{id} </update> <select id="selectUser" parameterType="int" resultType="User"> select * from user where id = #{id} </select></mapper>
4. ObjectMapper.java类
package com.ibatis.mapper;import com.ibatis.bean.User;public interface ObjectMapper {public int insertUser(User user);public int deleteUser(int id);public void updateUser(User user);public User selectUser(int id);}
5. FirstIbatisClass.java类
package com.ibatis.test;import java.io.InputStream;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.ibatis.bean.User;import com.ibatis.mapper.ObjectMapper;public class FirstIbatisClass {public static void main(String[] args) {InputStream inputStream = null;SqlSession session = null;try {inputStream = Resources.getResourceAsStream("mybatis.xml");SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);session = sqlSessionFactory.openSession();ObjectMapper mapper = session.getMapper(ObjectMapper.class);User user = new User();//insert////user.setId(2);//user.setUsername("bbb");//user.setPassword("bbb");//int n = mapper.insertUser(user);//if(n == 1) {//System.out.println("insert success");//} else {//System.out.println("insert fail");//}//delete//mapper.deleteUser(7);//update//user.setId(1);//user.setPassword("ddd");//mapper.updateUser(user);//selectuser = mapper.selectUser(1);System.out.println("password: " + user.getPassword());session.commit(); //如果是增删改操作，commit之后操作才能生效} catch (Exception e) {e.printStackTrace();} finally {if(session != null) {session.close();}}}}
项目的目录结构如下：
所需jar包：
mybatis-3.1.1.jar
mysql-connector-java-5.1.6-bin.jar
完整实例下载：
MyBatis3.1.1增删改查源码实例.rar