ibatis初级应用（一）

1.准备jar包

mybatis包（mybatis-3.2.2.jar）

jdbc包（mysql-connector-java-5.1.17.jar）

2.数据库表

表名称：User

表字段以及类型：

字段名称类型idintusernamevarcharpasswordvarchar

3.开始写程序

实体类

package test.model;public class User {//idprivate int id;//用户名private String username;//密码private String password;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 getPassword() {return password;}public void setPassword(String password) {this.password = password;}}

user.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="test.dao.UserDao">    <select id="get" parameterType="int" resultType="test.model.User">select * from admin_menus where id=#{id}</select></mapper>

mybatis.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.jdbc.Driver" />                <!-- 注意写自己的url -->                <property name="url"                 value="jdbc:mysql://192.168.0.220:3306/spark?autoReconnect=true&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull" />                <property name="username" value="out-devops" />                <property name="password" value="out-devops123456" />            </dataSource>        </environment>    </environments>    <mappers>        <mapper resource="test/user.xml"/>    </mappers></configuration>

dao层代码

package test.dao;import test.model.User;/** * User * @author admin * */public interface UserDao {/** * 根据ID获取该条记录 * @param id * @return User对象 */public User get(int id);}

测试代码

package test.test;import java.io.IOException;import java.io.Reader;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 test.dao.UserDao;import test.model.User;public class TsetUser {public static void main(String[] arg0){//开启sqlsessionSqlSession session = getSqlSession().openSession();UserDao userDao = session.getMapper(UserDao.class);User user = userDao.get(1);if(user != null){System.out.println(user.getUsername());}else{System.out.println("没有获取到数据");}}/** * 获取sqlsessionfactory * @return */private static SqlSessionFactory getSqlSession(){SqlSessionFactory sqlSession = null;//ibatis配置文件路径String resource = "test/mybatis.xml";try {//读取配置文件Reader reader = Resources.getResourceAsReader(resource);SqlSessionFactoryBuilder factoryBuilder = new SqlSessionFactoryBuilder();sqlSession = factoryBuilder.build(reader);} catch (IOException e) {e.printStackTrace();}return sqlSession;}}

以上若有不对，忘不吝指出！