Mybatis3.4.6 CRUD

青旅半醒 2022-05-07 04:56 176阅读 0赞

\`\`  
package cn.qchcloud.mybatisstd.domain;

import java.util.List;

import cn.qchcloud.mybatisstd.domain.AppUser;

public interface AppUserMapper \{

/**
     * This method was generated by MyBatis Generator. This method corresponds to the database table app_user
     * @mbg.generated  Sun Oct 14 15:31:11 CST 2018
     */
    int insert(AppUser record);
    
    AppUser getUserinfoById(Long id);
    void deleteUserinfoById(Long id);
    List<AppUser>  getAllUserinfo();
    void updateUserinfoById(AppUser record);

<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    <mapper namespace="cn.qchcloud.mybatisstd.domain.AppUserMapper">
      <resultMap id="BaseResultMap" type="cn.qchcloud.mybatisstd.domain.AppUser">
        
        <result column="id" jdbcType="INTEGER" property="id" />
        <result column="userName" jdbcType="VARCHAR" property="username" />
        <result column="password" jdbcType="VARCHAR" property="password" />
      </resultMap>
      <insert id="insert" parameterType="cn.qchcloud.mybatisstd.domain.AppUser">
        
        insert into app_user (id, userName, password
          )
        values (#{id,jdbcType=INTEGER}, #{username,jdbcType=VARCHAR}, #{password,jdbcType=VARCHAR}
          )
      </insert>
      <select id="getUserinfoById" parameterType="int" resultType="cn.qchcloud.mybatisstd.domain.AppUser">
    		select * from
    		app_user where id=#{id}
    	</select>
    	<delete id="deleteUserinfoById" parameterType="int">
    		delete from
    		app_user where id=#{id}
    	</delete>
    	<select id="getAllUserinfo" resultType="cn.qchcloud.mybatisstd.domain.AppUser">
    		select * from app_user
    	</select>
    	<update id="updateUserinfoById" parameterType="cn.qchcloud.mybatisstd.domain.AppUser">
    		update app_user
    		set
    		username=#{username},password=#{password}
    		where id=#{id}
    	</update>
      
     
    </mapper>

package cn.qchcloud.mybatisstd;

import java.io.IOException;  
import java.io.InputStream;  
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 cn.qchcloud.mybatisstd.domain.AppUser;

/\*\*

*  Hello world!
 *  
 *

\*/  
public class App  
\{  
public static void main( String\[\] args )  
\{  
System.out.println( “Hello World!” );  
String resource=“mybatis-config.xml”;  
try \{  
InputStream inputStream=Resources.getResourceAsStream(resource);  
SqlSessionFactory sqlSessionFactory=new SqlSessionFactoryBuilder().build(inputStream);  
System.out.println(sqlSessionFactory);

AppUser user=new AppUser();
    		user.setId(2);
    		user.setUsername("testUpdate");
    		user.setPassword("1234568");
    		SqlSession sqlSession=sqlSessionFactory.openSession();
    		//sqlSession.insert("insert", user);
    		//sqlSession.delete("deleteUserinfoById",1);
    		//sqlSession.update("updateUserinfoById", user);
    		List<AppUser> appUsers=sqlSession.selectList("getAllUserinfo");
    		for (int i = 0; i < appUsers.size(); i++) {
    			AppUser user2= appUsers.get(i);
    			System.out.println(user2.getId() + " "
    					+ user2.getUsername() + " " + user2.getPassword());
    
    		}
    		sqlSession.commit();
    		sqlSession.close();
    	} catch (IOException e) {
    		// TODO Auto-generated catch block
    		e.printStackTrace();
    	}
        
    }