代码配置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);
}
运行结果: