采用Mybatis技术实现数据库的增删改查-利用接口实现类简便测试

第一步,新建工程导包

核心包::

理论上有这两个就足够了

第二步,写xml配置文件以及bean和dao和dao实现和mapper

Mybatis的xml配置文件:
这个配置文件主要用来使用jdbc连接数据库,以及制定mapper文件位置
sqlMybatis.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"></transactionManager>
            <dataSource type="POOLED">
                <property name="username" value="root"/>
                <property name="password" value="302501"/>
                <property name="url" value="jdbc:mysql://localhost:3306/shixun"/>
                <property name="driver" value="com.mysql.jdbc.Driver"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper resource="Tb_bbsDao.xml"/>
    </mappers>

</configuration>

bean文件
bean文件是数据库内容往java方面的封装,一般直接写上属性,自动生成get和set方法

tb_bbs.java

package com.atxiaoming.bean;

public class Tb_bbs {
   
    private Integer id;
    private String title;
    private String content;
    private String intime;
    
    //我创建两个构造方法,方便插入
    
    
    
    public Integer getId() {
   
        return id;
    }
    public Tb_bbs() {
   
		super();
	}
	public Tb_bbs(Integer id, String title, String content, String intime) {
   
		super();
		this.id = id;
		this.title = title;
		this.content = content;
		this.intime = intime;
	}
	public void setId(Integer id) {
   
        this.id = id;
    }
    public String getTitle() {
   
        return title;
    }
    public void setTitle(String title) {
   
        this.title = title;
    }
    public String getContent() {
   
        return content;
    }
    public void setContent(String content) {
   
        this.content = content;
    }
    public String getIntime() {
   
        return intime;
    }
    public void setIntime(String intime) {
   
        this.intime = intime;
    }

}

dao接口;
dao接口只定义方法,实现在Test mapper中,或者实现类中提供

tb_bbsDao.java

package com.atxiaoming.dao;

import java.util.List;

import com.atxiaoming