Skip to content

代码配置Mybatis

MyBatis也提供了配置类Configuration,提供了所有与XML文件相同的配置。

1. 使用Configuration类

java
public class UserDemo2 {

    public static void main(String[] args) throws IOException {
        String driver = "com.mysql.cj.jdbc.Driver";
        String jdbcUrl = "jdbc:mysql://192.168.101.102:3306/sql_exercise";
        String username = "root";
        String password = "123456";
        DataSource dataSource = new PooledDataSource(driver, jdbcUrl, username, password);
        TransactionFactory transactionFactory = new JdbcTransactionFactory();
        Environment environment = new Environment("dev", transactionFactory, dataSource);
        Configuration configuration = new Configuration(environment);
        configuration.addMappers("com.rocket.demo.dao");
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(configuration);
        try (SqlSession session = sqlSessionFactory.openSession()) {
            UserMapper mapper = session.getMapper(UserMapper.class);
            User user = new User();
            user.setAge(123);
            user.setCreateTime(new Date());
            user.setSex(1);
            user.setUserName("测试");
            int rows = mapper.insertUser(user);
            System.out.println(rows);
            session.commit();
        }
    }
}
java
public interface UserMapper {
    // 增加插入方法
    @Insert("insert into t_user(user_name, age, sex, create_time) values (#{userName}, #{age}, #{sex}, #{createTime})")
    int insertUser(User user);
}

运行结果:
Alt text