1、建立一个User类
import java.io.Serializable;
import java.util.Date;
public class User implements Serializable {
private static final long serialVersionUID = -7409332756936075241 L;
private int id;
private String username;
private String sex;
private Date birthday;
private String address;
private String detail;
private Float score;
public int getId () {
return id;
}
public void setId (int id) {
this .id = id;
}
public String getUsername () {
return username;
}
public void setUsername (String username) {
this .username = username;
}
public String getSex () {
return sex;
}
public void setSex (String sex) {
this .sex = sex;
}
public Date getBirthday () {
return birthday;
}
public void setBirthday (Date birthday) {
this .birthday = birthday;
}
public String getAddress () {
return address;
}
public void setAddress (String address) {
this .address = address;
}
public String getDetail () {
return detail;
}
public void setDetail (String detail) {
this .detail = detail;
}
public Float getScore () {
return score;
}
public void setScore (Float score) {
this .score = score;
}
@Override
public String toString () {
return "User [id=" + id + ", username=" + username + ", sex=" + sex + ", birthday=" + birthday + ", address="
+ address + ", detail=" + detail + ", score=" + score + "]" ;
}
}
2、写一个接口UserMapper
import java.util.List;
import com.zhiyou.domain.User;
public interface UserMapper {
public User findUserById (int id)throws Exception;
public List<User> findUserAll (String name)throws Exception;
public int addUser (User user)throws Exception;
public void deleteUser (int id)throws Exception;
public void updateUser (User user)throws Exception;
}
3、写一个mybatis配置文件mybatisConfig.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" >
<transactionManager type ="JDBC" />
<dataSource type ="POOLED" >
<property name ="driver" value ="com.mysql.cj.jdbc.Driver" />
<property name ="url" value ="jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimezone=UTC" />
<property name ="username" value ="root" />
<property name ="password" value ="123456" />
</dataSource >
</environment >
</environments >
<mappers >
<mapper resource ="mappers/UserMapper.xml" />
</mappers >
</configuration >
4、写一个User的映射文件UserMapper.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.zhiyou.dao.UserMapper" >
<select id ="findUserById" parameterType ="int" resultType ="com.zhiyou.domain.User" >
SELECT * FROM user WHERE id=#{id}
</select >
<select id ="findUserAll" parameterType ="java.lang.String" resultType ="com.zhiyou.domain.User" >
SELECT * FROM user WHERE username LIKE '%${value}%';
</select >
<insert id ="addUser" parameterType ="com.zhiyou.domain.User" >
<selectKey keyProperty ="id" order ="AFTER" resultType ="java.lang.Integer" >
select LAST_INSERT_ID()
</selectKey >
INSERT INTO user (username,sex,birthday,address,score,detail)
VALUES (#{username},#{sex},#{birthday},#{address},#{score},#{detail})
</insert >
<delete id ="deleteUser" parameterType ="int" >
DELETE FROM user WHERE id=#{id}
</delete >
<update id ="updateUser" parameterType ="com.zhiyou.domain.User" >
update user set username=#{username},sex=#{sex},birthday=#{birthday},address=#{address},score=#{score},detail=#{detail} where id=#{id}
</update >
</mapper >
5、写一个测试类,就完成了,不需要Dao层的实现
import java.io .InputStream
import java.util .Date
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 .Before
import org.junit .Test
import com .zhiyou .dao .UserMapper
import com .zhiyou .domain .User
public class UserMapperTest {
private SqlSessionFactory sqlSessionFactory
@Before
public void setUp() throws Exception {
// 加载配置文件
String resource = "mybatisConfig.xml"
InputStream inputStream = Resources.getResourceAsStream (resource)
// 根据mytais的配置创建SqlSessionFactory
sqlSessionFactory = new SqlSessionFactoryBuilder().build (inputStream)
}
@Test
public void test1() throws Exception
{
SqlSession session=sqlSessionFactory.openSession ()
UserMapper userMapper=session.getMapper (UserMapper.class )
User user=userMapper.findUserById (2 )
System.out .println (user)
}
@Test
public void test2() throws Exception
{
SqlSession session=sqlSessionFactory.openSession ()
UserMapper userMapper=session.getMapper (UserMapper.class )
User user=new User()
user.setUsername ("yanhuang" )
user.setSex ("男" )
user.setBirthday (new Date())
user.setDetail ("种花家" )
user.setScore (50.0 f)
int a= userMapper.addUser (user)
session.commit ()
session.close ()
System.out .println (a)
}
}