mybits最基本的例子————-实现增删改查

1，项目结构

Center

![Image 1][]![Image 1][]

[java] view plain copy

package com.entity;
public class Book {
private int bookid;
private String bookname;
private String bookauthor;
private int bookprice;
public Book() {
super();
}
public Book(int bookid, String bookname, String bookauthor, int bookprice) {
super();
this.bookid = bookid;
this.bookname = bookname;
this.bookauthor = bookauthor;
this.bookprice = bookprice;
}
public Book(String bookname, String bookauthor, int bookprice) {
super();
this.bookname = bookname;
this.bookauthor = bookauthor;
this.bookprice = bookprice;
}
public int getBookid() {
return bookid;
}
public void setBookid(int bookid) {
this.bookid = bookid;
}
public String getBookname() {
return bookname;
}
public void setBookname(String bookname) {
this.bookname = bookname;
}
public String getBookauthor() {
return bookauthor;
}
public void setBookauthor(String bookauthor) {
this.bookauthor = bookauthor;
}
public int getBookprice() {
return bookprice;
}
public void setBookprice(int bookprice) {
this.bookprice = bookprice;
}
}

[java] view plain copy

[java] view plain copy

[html] view plain copy

[html] view plain copy

<?**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”></transactionManager**>
<**dataSource type=”POOLED”>**
<**property name=”driver” value=”com.mysql.jdbc.Driver”></property**>
<**property name=”url” value=”jdbc//localhost:3306/<**span style=”color:#ff6666;”>**<mysqlDb></span**>?characterEncoding=utf-8”>**</property>**
<**property name=”username” value=mysqlnam”></property**>
<**property name=”password” value=”mysqlpassword”></property**>
</**dataSource**>
</**environment**>
</**environments**>
<**mappers**>
<**mapper resource=”com/mapper/BookMapper.xml”></mapper**>
</**mappers**>
</**configuration**>

[java] view plain copy

package com.util;
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;
public class MysqlSessionFactory {
static SqlSession session;
public SqlSession getSqlSession(){
try {
Reader reader = Resources.getResourceAsReader(“Configuration.xml”);
SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(reader);
session = sessionFactory.openSession();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return session;
}
}

[java] view plain copy

[java] view plain copy

以上是整个demo的所有源代码！

只想说这一部分

1,book.javav中的属性名与mysql中book table中字段名字不匹配：

[html] view plain copy

resulteMap 是为了解决book.javav中的属性名与mysql中book table中字段名字不匹配，无法进行数据的填充！

2,命名空间

[java] view plain copy

这个是service的名字，不要写错，另外service的方法名也要和配置文件的方法名一样。

总体感觉没什么好说的！

1，读取配置文件获得SqlsessionFactory

2，通过SqlsessionFactory获得sqlsession

那涉及到一个问题：配置文件

配置文件:Configtion.xml

这个文件定义了关于数据源的配置

[html] view plain copy

<**environments default=”development”>**
<**environment id=”development”>**
<**transactionManager type=”JDBC”></transactionManager**>
<**dataSource type=”POOLED”>**
<**property name=”driver” value=”com.mysql.jdbc.Driver”></property**>
<**property name=”url” <**span style=”font-family: Arial, Helvetica, sans-serif;”>value=”jdbc//localhost:3306/</**span><**span style=”font-family: Arial, Helvetica, sans-serif;”>**</property></span**>