mybatis框架insert入门案例（1）

1.首先导入jar包 2.配置mybatis.xml 3.映射sql语句 第一个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" /> <property name="url" value="jdbc:mysql:///class1" /> <property name="username" value="root" /> <property name="password" value="123456" /> </dataSource> </environment> </environments> <mappers> <mapper resource="StudentMapper.xml" /> </mappers> </configuration> log4j.xml <?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE log4j:configuration SYSTEM "log4j.dtd"> <log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/"> <appender name="STDOUT" class="org.apache.log4j.ConsoleAppender"> <param name="Encoding" value="UTF-8" /> <layout class="org.apache.log4j.PatternLayout"> <param name="ConversionPattern" value="%-5p %d{MM-dd HH:mm:ss,SSS} %m (%F:%L) \n" /> </layout> </appender> <logger name="java.sql"> <level value="debug" /> </logger> <logger name="org.apache.ibatis"> <level value="info" /> </logger> <root> <level value="debug" /> <appender-ref ref="STDOUT" /> </root> </log4j:configuration> 映射sql 编写接口StudentMapper package com.gg.dao; import com.gg.entity.Student; public interface StudentMapper { public void insertStudent(Student student); } <?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"> <!--namespace :取值為要映射的接口的全名稱 --> <mapper namespace="com.gg.dao.StudentMapper"> <!-- id:該抽象方法的名稱 --> <insert id="insertStudent"> <!--#{}相当于占位符 --> insert into student values (#{sid},#{sname},#{sage}); </insert> </mapper>

实体类

package com.gg.entity; public class Student { private String sid; private String sname; private Integer sage; public Student() { super(); // TODO Auto-generated constructor stub } public Student(String sid, String sname, Integer sage) { super(); this.sid = sid; this.sname = sname; this.sage = sage; } @Override public String toString() { return "Student [sid=" + sid + ", sname=" + sname + ", sage=" + sage + "]"; } public String getSid() { return sid; } public void setSid(String sid) { this.sid = sid; } public String getSname() { return sname; } public void setSname(String sname) { this.sname = sname; } public Integer getSage() { return sage; } public void setSage(Integer sage) { this.sage = sage; } }

测试类‘

package com.gg.demo; import java.io.InputStream; 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 com.gg.dao.StudentMapper; import com.gg.entity.Student; public class Demo { public static void main(String[] args) throws Exception { //定義主配置文件的相對路徑 String resource = "mybatis.xml"; //獲取当前主配置文件的输入流 InputStream inputStream = Resources.getResourceAsStream(resource); //创建sqlSessionFactory工厂对象 SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream); //session sqlsession SqlSession session=sqlSessionFactory.openSession(false); StudentMapper mapper=session.getMapper(StudentMapper.class); Student student=new Student("1012", "sname", 12); mapper.insertStudent(student); session.commit(); session.close(); } }