实践步骤:
一.建立文件
1.新建工程>> 查找maven
2.输入文件名
3.创建项目名字
二.新建数据库(数据库建立)
1.添加maven的mybatis坐标,mysql的坐标(添加依赖,在pom.xml中)
2.创建student实体类>>保存表中的一行数据
package com.yu.bean;
public class student {
private Integer id;
private String name;
private Integer email;
private String password;
public student(Integer id, String name,Integer email,String age) {
this.id = id;
this.name = name;
this.email = email;
this.password = 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 getEmail() {
return email;
}
public void setEmail(Integer email) {
this.email = email;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
@Override
public String toString() {
return "student{" +
"id=" + id +
", name='" + name + '\'' +
", eamil=" + email +
", password='" + password + '\'' +
'}';
}
}
3.在dao包里创建接口studentDao接口,用来声明方法
package com.yu.dao;
import com.yu.bean.student;
import java.util.List;
//操作student表
public interface StudentDao {
List<student> selectStudent();
//添加
public void addUser();
//修改
public boolean updateUser();
//根据id删除信息
public void deleteUserById();
}
4.在resources中编写mybatis的核心配置文件mybatis.xml
url的values:jdbc:mysql://localhost:3306/maven" 中maven为自己的数据库名字,usernampassword的values为自己数据库的用户名和密码
5.在dao包下面创建studentDao映射文件,后缀名为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">
<mapper namespace="com.yu.dao.StudentDao">
<select id="selectStudent" resultType="com.yu.bean.student">
select id,name,email,age from student
</select>
</mapper>
6.在test下创建test类,用于测试代码
package com.yu.dao;
import com.yu.bean.student;
import com.sun.javaws.IconUtil;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.Test;
import javax.annotation.Resource;
import javax.imageio.stream.ImageInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.util.List;
public class MyTest {
//测试mybatis测试sql语句
public static void main(String[] args)throws IOException {
//调用mybatis某个对象的方法,执行mapper文件中的sql语句
//mybatis核心类:SqlSessionFactory
//1定义mybatis主配置文件的位置,从类路径开始的相对路径
String config = "mybatis.xml";
//2读取配置文件。使用mybatis框架中的Resource类
InputStream in = Resources.getResourceAsStream(config);
//3创建SqlSessionFactory对象,使用SqlSessionFactoryBuild类
SqlSessionFactoryBuilder builder=new SqlSessionFactoryBuilder();
SqlSessionFactory factory= builder.build(in);
//4获取SqlSession对象
SqlSession sqlSession = factory.openSession();
//5指定要执行的sql语句的id、
//查询
//sql语句的id等于namespace加上点再加上<select> <update> <insert> <delete>标签id属性值
String sqlid = "com.zhao.dao.StudentDao" + "." + "selectStudent";
//通过SqlSession的方法,执行sql语句s
List<student> studentList=sqlSession.selectList(sqlid);
for(student stu:studentList){
System.out.println("使用mybatis查询一个学生=" + stu);
}
//7关闭SqlSession
sqlSession.close();
}
}
7.结果显示
该代码实现的是查询方法,如果要实现增删改查需要在dao接口中声明方法,在映射文件中改变id和路径,最后在test类中加入增删改的语句 。