栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 软件开发 > 后端开发 > Java

Hello Mybatis(注解版)

Java 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

Hello Mybatis(注解版)

UserMapper

package com.bing.dao;

import com.bing.pojo.User;
import org.apache.ibatis.annotations.*;

import java.util.List;
import java.util.Map;


public interface UserMapper {
//    @Select("select * from mybatis.user")
//    List getUsers();
//
//    //有多个参数时候,用@Param
//    @Select("select * from mybatis.user where id = #{id}")
//    User getUserById(@Param("id") int id);


    //引用对象不需要写@Param
    @Insert("insert into mybatis.user(id,name,pwd) values (#{id},#{name},#{password})")
    int addUser(User user);

//    @Update("update mybatis.user set name=#{name},pwd=#{password} where id=#{id}")
//    int updateUser(User user);

    @Update("update mybatis.user set name=#{name},pwd=#{password} where id=#{id}")
    int updateUser(User user);

    @Delete("delete from user where id=#{uid}")
    int deleteUser(@Param("uid") int id);
}

User

package com.bing.pojo;

import lombok.AllArgsConstructor;
import lombok.Data;



@AllArgsConstructor
public class User {

    private int id;
    private String name;
    private String password;
//    public User() {
//    }
//
//    public User(int id, String name, String password) {
//        this.id = id;
//        this.name = name;
//        this.password = password;
//    }
//
//    public int getId() {
//        return id;
//    }
//
//    public void setId(int 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 User(int id) {
//        this.id = id;
//    }
//
//
//
//
//    @Override
//    public String toString() {
//        return "User{" +
//                "id=" + id +
//                ", name='" + name + ''' +
//                ", pwd='" + password + ''' +
//                '}';
//    }
}

MybatisUtils.java
//不用手动去commit了(加上true)
SqlSession sqlession = sqlSessionFactory.openSession(true);

package com.bing.utils;

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 java.io.IOException;
import java.io.InputStream;


public class MybatisUtils {
    //相当于数据库连接池
    private static SqlSessionFactory sqlSessionFactory;
    static {
        try {
            String resource = "mybatis-config.xml";
            InputStream inputStream = Resources.getResourceAsStream(resource);
            sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

    public static SqlSession getSqlSession(){
        //不用手动去commit了
        SqlSession sqlession = sqlSessionFactory.openSession(true);
        return sqlession;
    }
}

db.properties

driver=com.mysql.cj.jdbc.Driver
url=jdbc:mysql://localhost:3306/mybatis?useSSL=false&useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC
#username=root
#password=123456

mybatis-config.xml




    
        
        
    





    
        
    
    
        
            
            
                
                
                
                
            
        
    





    
        
    



UserDaoTest

package com.bing.dao;

import com.bing.pojo.User;
import com.bing.utils.MybatisUtils;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;

import java.util.HashMap;
import java.util.List;


public class UserDaoTest {

//    static Logger logger = Logger.getLogger(UserDaoTest.class);
//
//    @Test
//    public void test() {
//        SqlSession sqlSession = MybatisUtils.getSqlSession();
//
//        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
//
//        List userList = mapper.getUserList();
//
//        for (User user : userList) {
//            System.out.println(user);
//        }
//        sqlSession.close();
//    }
//    @Test
//    public void getById() {
        logger.error("哈哈哈哈哈哈哈哈哈哈");
//        SqlSession sqlSession = MybatisUtils.getSqlSession();
//        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
//        User user = mapper.getUser(1);
//        System.out.println(user);
//    }
//
    @Test
    public void log4jTest(){

        logger.debug("debug:进入了log4jTest");
        logger.error("error:进入了log4jTest");
    }
//
//    @Test
//    public void getUserByLimit(){
//        SqlSession sqlSession = MybatisUtils.getSqlSession();
//        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
//
//        HashMap map = new HashMap();
//
//        map.put("startIndex",0);
//        map.put("pageSize",2);
//        List userList = mapper.getUserByLimit(map);
//
//        for (User user : userList) {
//            System.out.println(user);
//        }
//
//        sqlSession.close();
    //}

    @Test
    public void test(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);

        //mapper.addUser(new User(6, "吃不饱", "123434"));

        //mapper.updateUser(new User(6,"穿不暖","12345567"));

        mapper.deleteUser(1);
        sqlSession.close();
    }
}

转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/976029.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号