代码配置Mybatis

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();

        }

    }

}

public interface UserMapper {

    // 增加插入方法

    @Insert("insert into t_user(user_name, age, sex, create_time) values (#{userName}, #{age}, #{sex}, #{createTime})")

    int insertUser(User user);

}