MyBatis框架(2.0)
实现数据的增加处理:
1,建立cn.mldn.vo.Member类:
package cn.mldn.vo;
import java.io.Serializable;
import java.util.Date;
@SuppressWarnings("serial")
public class Member implements Serializable {
private String mid ;
private String name ;
private Integer age ;
private Date birthday ;
private Double salary ;
public String getMid() {
return mid;
}
public void setMid(String mid) {
this.mid = mid;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public Integer getAge() {
return age;
}
public void setAge(Integer age) {
this.age = age;
}
public Date getBirthday() {
return birthday;
}
public void setBirthday(Date birthday) {
this.birthday = birthday;
}
public Double getSalary() {
return salary;
}
public void setSalary(Double salary) {
this.salary = salary;
}
}
2,建立Member类的映射文件为Member.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">
<!-- 设置命名空间,可以与不同表的同类型操作进行区分,使用时以“空间名称.id”的方式调用 -->
<mapper namespace="cn.mldn.mapping.MemberNS">
<!-- 定义增加数据的操作配置,同时指定参数类型,建议与DAO的方法名称一致 -->
<insert id="doCreate" parameterType="cn.mldn.vo.Member">
INSERT INTO member(mid,name,age,birthday,salary)
VALUES (#{mid},#{name},#{age},#{birthday},#{salary}) ;
</insert>
</mapper>
3,MyBatis并不知道该文件,配置追加:
范例:在mybaits.cfg.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">
<!-- 此时的事务控制交由JDBC负责处理 -->
<transactionManager type="jdbc" /> <!-- 使用JDBC方式管理 -->
<dataSource type="POOLED"> <!-- 设置数据源类型,此时为POOLED -->
<property name="driver" value="org.gjt.mm.mysql.Driver" />
<property name="url" value="jdbc:mysql://localhost:3306/mldn" />
<property name="username" value="root" />
<property name="password" value="mysqladmin" />
</dataSource>
</environment>
</environments>
<mappers> <!-- 映射文件信息 -->
<mapper resource="cn/mldn/vo/mapping/Member.xml" />
</mappers>
</configuration>
4,建立test测试类:
package cn.mldn.test;
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 cn.mldn.vo.Member;
public class TestInsertDemo {
public static void main(String[] args) throws Exception {
// 1、读取mybatis.cfg.xml文件进行操作的解析
InputStream input = Resources.getResourceAsStream("mybatis.cfg.xml");
// 2、创建SqlSessionFactory接口对象
SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(input) ;
// 3、创建SqlSession接口;
SqlSession session = factory.openSession() ; // 创建一个新的Session对象
// 4、创建member的VO对象
Member vo = new Member() ;
vo.setMid("mldn");
vo.setAge(15);
vo.setName("小王吧");
vo.setBirthday(new Date());
vo.setSalary(89999.09);
// 5、实现数据的保存处理
int len = session.insert("cn.mldn.mapping.MemberNS.doCreate", vo) ;
System.out.println("影响的数据行数:" + len);
// 6、关闭资源
session.commit();
session.close();
input.close();
}
}