导入jar包
配置mybatis.xml文件
<configuration>
<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/vote"/>
<property name="username" value="root"/>
<property name="password" value="100"/>
</dataSource>
</environment>
</environments>
<mappers>
<!-- 导入实体类配置文件 -->
<mapper resource="com/znsd/mybaits/vo/student.xml"/>
</mappers>
</configuration>
配置实体类的映射文件
<mapper namespace="StudentMapper">
<select id="stu" resultType="com.znsd.mybaits.vo.Student">
select * from student
</select>
</mapper>
实现查询操作
public class StudentList {
private static SqlSessionFactory factory;
public static void main(String[] args) throws IOException {
//读取配置文件
InputStream inputStream = Resources.getResourceAsStream("myBatis.xml");
//创建SqlSessionFactory对象
factory = new SqlSessionFactoryBuilder().build(inputStream);
//创建Session对象
SqlSession session = factory.openSession();
//读取配置文件中的查询方法
List<Student> list = session.selectList("StudentMapper.stu");
for (Student student : list) {
System.out.println(student);
}
}
}
在这里只有查询,增删改就是在实体类映射文件中配置就行了,基本和查询一样。