1.书写MyBatis-Config-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> <typeAliases> <typeAlias alias="User" type="cn.swt.entity.UserInfo" /> </typeAliases> <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/message" /> <property name="username" value="root" /> <property name="password" value="123456" /> </dataSource> </environment> </environments> <mappers> <mapper resource="UserDao.xml"></mapper> </mappers> </configuration>
2.书写UserDao.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="cn.swt.dao.UserDao1"> <select id="all" resultType="User"> select id,name,pwd from userinfo where id=#{id} </select> </mapper>
3.书写接口
package cn.swt.dao; import cn.swt.entity.UserInfo; import org.apache.ibatis.annotations.Param; import java.util.List; /** * Created by Administrator on 2017/6/28. */ public interface UserDao1 { public UserInfo all(@Param("id") int id); }4.书写测试类
//psvm String resource="MyBatis-Config.xml"; try { Reader reader = Resources.getResourceAsReader(resource); SqlSessionFactory ssf = new SqlSessionFactoryBuilder().build(reader); SqlSession session = ssf.openSession(); UserDao1 mapper = session.getMapper(UserDao1.class); System.out.println(mapper.all(1).getName()); session.close(); } catch (Exception e) { e.printStackTrace(); } finally { }