Mybatis通過注解方式訪問數(shù)據(jù)庫（intellij）
一仗岖、連接的方式
創(chuàng)建Maven工程并導(dǎo)入坐標(biāo)
創(chuàng)建實體類和dao接口文件
創(chuàng)建Mybatis的主配置文件 SqlMapConfig.xml
二仰冠、具體連接方式
1. 首先在Resources文件夾下面建立 SqlMapConfig.xml 文件
2. 建立相應(yīng)的實體類和對應(yīng)的接口
（1）/src/main/java/com/xxx/dao
IUserDao.javapublic interface IUserDao { // 用戶持久層接口 @Select("select * from user") // 注解方式進(jìn)行相應(yīng)的數(shù)據(jù)處理操作 List findAll();}
(2) /src/main/java/com/xxx/domain 包 建立相應(yīng)接口文件
User.java//public class User { private Integer id; private String username; private Date birthday; private String sex; private String address; public String getAddress() { return address; } public void setAddress(String address) { this.address = address; } public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } public String getUsername() { return username; } public void setUsername(String username) { this.username = username; } public Date getBirthday() { return birthday; } public void setBirthday(Date birthday) { this.birthday = birthday; } public String getSex() { return sex; } public void setSex(String sex) { this.sex = sex; } @Override public String toString() { return "User{" + "id=" + id + ", username='" + username + '\'' + ", birthday=" + birthday + ", sex='" + sex + '\'' + ", address='" + address + '\'' + '}'; }}
public static void main(String[] args)throws Exception {
//1.讀取配置文件
InputStream in = Resources.getResourceAsStream("SqlMapConfig.xml"); //2.創(chuàng)建SqlSessionFactory工廠
SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
SqlSessionFactory factory = builder.build(in);
//3.使用工廠生產(chǎn)SqlSession對象
SqlSession session = factory.openSession();
//4.使用SqlSession創(chuàng)建Dao接口的代理對象
IUserDao userDao = session.getMapper(IUserDao.class);
//5.使用代理對象執(zhí)行方法
List users = userDao.findAll();
for(User user : users) {
System.out.println(user);
}
//6.釋放資源
session.close(); //
in.close();
}
