1.导入jar包
2.创建与数据库表对应的实体类
package cn.zzu.entity;
public class Student {
private Integer id;
private String name;
private Integer age;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public Integer getAge() {
return age;
}
public void setAge(Integer age) {
this.age = age;
}
@Override
public String toString() {
return "Student [id=" + id + ", name=" + name + ", age=" + age + "]";
}
}
2.在src下创建conf.xml文件,并配置xml文件
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<environments default="development">
<environment id="development">
<!-- 使用jdbc事务管理 -->
<transactionManager type="JDBC"></transactionManager>
<!-- 使用数据库连接池 -->
<dataSource type="POOLED">
<property name="driver" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql:///mybatis?characterEncoding=utf-8"/>
<property name="username" value="root"/>
<property name="password" value="123456"/>
</dataSource>
</environment>
</environments>
<!-- 引入Mapper1.xml文件 -->
<mappers>
<mapper resource="SalMap/Mapper1.xml"/>
</mappers>
</configuration>
3.创建mapper.xml并配置
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!-- namespace命名空间
用来隔离sql
-->
<mapper namespace="student">
<!-- 通过id来查询一个用户
id属性:sql的名称,namespace+id用来定位具体的sql(标识)
parameterType属性:参数类型
resultType属性:返回值
如果bean与数据库一一对应,则会自动映射 where id=#{v},#{} 占位符,里面要写一个任意字符
-->
<select id="findStudentById" parameterType="Integer" resultType="cn.zzu.entity.Student">
select * from student where id=#{v}
</select>
</mapper>