三大框架入门都讲了,现在讲一个轻量级的框架Mybatis。
首先,要承认的是这个框架和Hibernate是类似的,更灵活,更容易学。
1.新建一个项目,加上Mybatis的核心包和数据库连接包
2.新建一个实体User,加上get,set方法
package com.qm.entity;
public class User {
private int id;
private String name;
private String pwd;
public User() {
}
public User(String name, String pwd) {
this.name = name;
this.pwd = pwd;
}
public User(int id, String name, String pwd) {
super();
this.id = id;
this.name = name;
this.pwd = pwd;
}
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 getPwd() {
return pwd;
}
public void setPwd(String pwd) {
this.pwd = pwd;
}
@Override
public String toString() {
return "User [id=" + id + ", name=" + name + ", pwd=" + pwd + "]";
}
}
3.新建一个配置文件conf.xml用来连接数据库
<environments default="development">
<environment id="development">
<transactionManager type="JDBC" />
<dataSource type="POOLED">
<property name="driver" value="com.mysql.jdbc.Driver" />
<property name="url" value="jdbc:mysql://localhost:3306/ssh" />
<property name="username" value="root" />
<property name="password" value="root" />
</dataSource>
</environment>
</environments>
4.新建一个映射文件。userMapper.xml 里面可以直接写sql,非常灵活
<mapper namespace="com.qm.mapping.userMapper">
5.在配置文件注册
<mappers>
<!-- 注册userMapper.xml文件-->
<mapper resource="com/qm/mapping/userMapper.xml"/>
</mappers>
6.新建一个测试类开始测试,这是添加
String resource = "conf.xml";
Reader reader;
try {
reader = Resources.getResourceAsReader(resource);
//构建sqlSession的工厂
SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(reader);
SqlSession session = sessionFactory.openSession();
String statement="com.qm.mapping.userMapper.insertUser";
User user1=new User("quanmin","888");
session.insert(statement, user1);
sessionmit();
} catch (IOException e) {
e.printStackTrace();
}
7.在映射文件写上对应的sql语句
运行结果
添加:刚刚添加的quanmin,看数据库
删除:删除刚刚添加的数据
通过id查找
查找所有:
更多推荐
Mybatis入门教程之增删查实例
发布评论