mybatis03-增删改查

最新推荐文章于 2024-10-05 12:07:50 发布

银银豆豆

最新推荐文章于 2024-10-05 12:07:50 发布

阅读量106

点赞数

分类专栏： mybatis 文章标签： java mybatis 增删改查

本文链接：https://blog.csdn.net/qq_32726809/article/details/89306893

版权

mybatis 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

1配置相应的环境

2采用映射方式增删改查

2.1 配置mybatis文件，设置映射的文件。


<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
	<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/lsq" />
                <property name="username" value="root" />
                <property name="password" value="111111" />
             </dataSource>
		</environment>
	</environments>
	<mappers>
		<mapper resource="mappsers_my/user.xml"/>
		<mapper class="bean.UserMapper"/>
	</mappers>
</configuration>

2.2 配置mapper文件

<?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="user">

	<select id="getUser" parameterType="int" resultType="bean.User">
		select * from user where id = #{id}
	</select>
	<select id="getUsers" resultType="bean.User">
	     select * from user
	</select>
	<insert id="insertUser" parameterType="bean.User">
	      insert into user (id,name,pass) values (#{id},#{name},#{pass}) 
	</insert>
	<update id="updateUser" parameterType="bean.User">
	      update user set name = #{name} , pass=#{pass} where id= #{id}
	</update>
	<delete id="deleteUser" parameterType="bean.User">
	      delete from user where id = #{id}
	</delete>
</mapper>

2.3 调用

package main;

import java.io.IOException;
import java.io.Reader;
import java.util.ArrayList;
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 bean.User;
import bean.UserMapper;
/**
 * 
 * @ClassName:  Main   
 * @Description:简单例子，仅作测试学习  
 * @author: 
 * @date:   2019年4月15日 上午9:53:47   
 *
 */
public class Main {
	static String resource = "config.xml";

	public static void main(String[] args) {
		//inserUser();
		/*
		 * getUsers(); updateUser(); getUsers();
		 * 
		 * deleteUser();
		 */
		getUsers2();
	}
	
	/**
	 * 
	 *    
	 * @Title: getUsers  
	 * @author :
	 * @Description: 简单例子，获取所有用户   
	 * @param: @return      
	 * @return: List<User>      
	 * @throws
	 */
	public static List<User> getUsers(){
		Reader reader = null;
		try {
			reader = Resources.getResourceAsReader(resource);
		} catch (IOException e) {

			e.printStackTrace();
		}
		SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(reader);
		SqlSession session = sessionFactory.openSession();
		List<User> li = session.selectList("user.getUsers");
		for(User user : li) {
			System.out.println(user);
		}
		return null;
	}
	/**
	 * 
	 *    
	 * @Title: getUsers2  
	 * @author :
	 * @Description: 通过接口获取用户
	 * @param: @return      
	 * @return: List<User>   
	 * @throws
	 */
	public static List<User> getUsers2(){
		Reader reader = null;
		try {
			reader = Resources.getResourceAsReader(resource);
		} catch (IOException e) {

			e.printStackTrace();
		}
		SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(reader);
		SqlSession session = sessionFactory.openSession();
		UserMapper mapper =   session.getMapper(UserMapper.class);
		List<User> li  =  mapper.getUsers();
		
		for(User user : li) {
			System.out.println(user);
		}
		return null;
	}
	
	/**
	 * 
	 *    
	 * @Title: inserUser  
	 * @author :
	 * @Description:插入用户   
	 * @param:       
	 * @return: void      
	 * @throws
	 */
	public static void inserUser() {
		Reader reader = null;
		try {
			reader = Resources.getResourceAsReader(resource);
		} catch (IOException e) {

			e.printStackTrace();
		}
		SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(reader);
		SqlSession session = sessionFactory.openSession();
		session.insert("user.insertUser", new User("13", "12", "12"));
		session.commit();
	}
	/**
	 * 
	 *    
	 * @Title: updateUser  
	 * @author 
	 * @Description: 更新用户
	 * @param:       
	 * @return: void      
	 * @throws
	 */
	public static void updateUser() {
		Reader reader = null;
		try {
			reader = Resources.getResourceAsReader(resource);
		} catch (IOException e) {

			e.printStackTrace();
		}
		SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(reader);
		SqlSession session = sessionFactory.openSession();
		session.update("user.updateUser", new User("12","11211","1111"));
		session.commit();
	}
	/**
	 * 
	 *    
	 * @Title: deleteUser  
	 * @author :
	 * @Description:删除用户 
	 * @param:       
	 * @return: void      
	 * @throws
	 */
	public static void deleteUser() {
		Reader reader = null;
		try {
			reader = Resources.getResourceAsReader(resource);
		} catch (IOException e) {

			e.printStackTrace();
		}
		SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(reader);
		SqlSession session = sessionFactory.openSession();
		session.delete("user.deleteUser", new  User("12", null, null));
		session.commit();
	}

}

3采用接口注解的方式

3.1配置mybatis文件，将要引入的几口mapper放在这里

<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
	<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/lsq" />
                <property name="username" value="root" />
                <property name="password" value="111111" />
             </dataSource>
		</environment>
	</environments>
	<mappers>
		<mapper resource="mappsers_my/user.xml"/>
		<mapper class="bean.UserMapper"/>
	</mappers>
</configuration>

3.1配置接口文件

package bean;

import java.util.List;

import org.apache.ibatis.annotations.Select;

public interface UserMapper {
	@Select(" select * from user")
	List<User> getUsers();

}

3.2调用

public static List<User> getUsers2(){
		Reader reader = null;
		try {
			reader = Resources.getResourceAsReader(resource);
		} catch (IOException e) {

			e.printStackTrace();
		}
		SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(reader);
		SqlSession session = sessionFactory.openSession();
		UserMapper mapper =   session.getMapper(UserMapper.class);
		List<User> li  =  mapper.getUsers();
		
		for(User user : li) {
			System.out.println(user);
		}
		return null;
	}