0106—mybatis单独配置

来源：互联网发布：运营数据分析专员编辑：程序博客网时间：2024/05/21 19:39

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><!-- mybatis别名定义 --><typeAliases><typeAlias alias="Student" type="com.bean.Student" /></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://192.168.172.131:3306/test?characterEncoding=gbk" /><property name="username" value="root" /><property name="password" value="admin" /></dataSource></environment></environments><!-- mybatis的mapper文件，每个xml配置文件对应一个接口 --><mappers><mapper resource="com/dao/student.xml" /></mappers></configuration>

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.dao.StudentDao"><insert id="saveStudent" parameterType="Student"useGeneratedKeys="true" keyProperty="sid">insert into student (name) values(#{name})</insert><select id="findStudentBySid" parameterType="int" resultType="Student">select * from `student` where student.sid = #{sid}</select><delete id="deleteStudentBySid" parameterType="int">delete fromstudent where sid=#{sid}</delete><update id="updateStudentBySid" parameterType="Student">update student setname = #{name} where sid= #{sid}</update></mapper>

test;

static {try {reader = Resources.getResourceAsReader("Configuration.xml");sessionFac = new SqlSessionFactoryBuilder().build(reader);} catch (IOException e) {fail("Not yet implemented");}}public static void updateStudentInfo() {session = sessionFac.openSession();StudentDao dao = session.getMapper(StudentDao.class);Student sutdent = new Student();sutdent.setSid(1);sutdent.setName("王菲");int code = dao.updateStudentBySid(sutdent);System.out.println(code == 0 ? "fail !" : "success!");}

0 0