mybatis DEMO

目录

0、pom文件

1、不使用xml配置文件构造sqlSessionFactory

1.1、DAO

1.2、model

---

 

0、pom文件

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0</modelVersion>
  <groupId>xyz.jangle</groupId>
  <artifactId>mybatis</artifactId>
  <version>0.0.1-SNAPSHOT</version>
  
  <dependencies>
  		<!-- mybatis需要的依赖 -->
		<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis</artifactId>
			<version>3.2.5</version>
		</dependency>
  		<!-- mysql驱动 -->
		<dependency>
		    <groupId>mysql</groupId>
		    <artifactId>mysql-connector-java</artifactId>
		    <version>5.1.31</version>
		</dependency>
		<!-- 连接池 ,tomcat的jdbc pool -->
		<dependency>
			<groupId>org.apache.tomcat</groupId>
			<artifactId>tomcat-jdbc</artifactId>
			<version>7.0.29</version>
		</dependency>
  </dependencies>
  
  <build>
		<pluginManagement>
			<plugins>
                <!-- 设置MAVEN的编译的JDK版本为1.8 -->
				<plugin>
					<groupId>org.apache.maven.plugins</groupId>
					<artifactId>maven-compiler-plugin</artifactId>
					<version>2.3.2</version>
					<configuration>
						<source>1.8</source>
						<target>1.8</target>
						<encoding>UTF-8</encoding>
					</configuration>
				</plugin>
			</plugins>
		</pluginManagement>
	</build>
</project>

1、不使用xml配置文件构造sqlSessionFactory

package mybatis;

import java.util.List;

import org.apache.ibatis.mapping.Environment;
import org.apache.ibatis.session.Configuration;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.apache.ibatis.transaction.jdbc.JdbcTransactionFactory;
import org.apache.tomcat.jdbc.pool.DataSource;

/**
 * 不使用xml文件构造SqlSessionFactory
 * @author jangle
 * @email jangle@jangle.xyz
 * @time 2022年2月17日 下午3:34:50
 * 
 */
public class M {

	public static void main(String[] args) {
		
		// 1、数据源
		DataSource dataSource = new DataSource();
		dataSource.setUrl("jdbc:mysql://mysql.jangle.xyz:10071/demo?characterEncoding=UTF8");
		dataSource.setUsername("jangle");
		dataSource.setPassword("2");
		dataSource.setDriverClassName("com.mysql.jdbc.Driver");
		
		/* 不使用xml文件构造SqlSessionFactory   */
		// 2、事务工厂
		JdbcTransactionFactory factory = new JdbcTransactionFactory();
		// 3、环境
		Environment environment = new Environment("dev", factory, dataSource);
		// 4、
		Configuration conf = new Configuration(environment);
		conf.addMapper(BsDemoMapper.class);
		
		SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
		SqlSessionFactory sessionFactory = builder.build(conf);
		SqlSession session = sessionFactory.openSession();
		try {
			BsDemoMapper mapper = session.getMapper(BsDemoMapper.class);
			List<BsDemo> list = mapper.selectAll();
			System.out.println(list.size());
		} finally {
			session.close();
		}
	}

}

1.1、DAO

package mybatis;

import java.util.List;

import org.apache.ibatis.annotations.Select;

/**
 * @author jangle
 * @email jangle@jangle.xyz
 * @time 2022年2月18日 上午10:33:39
 * 
 */
public interface BsDemoMapper {
	
	@Select("select * from bs_demo")
	List<BsDemo> selectAll();

}

1.2、model

package mybatis;

import java.util.Date;

public class BsDemo extends BaseModel {
	/**
	 * 主键ID
	 *
	 * @mbg.generated
	 */
	private Long id;

	/**
	 * 主键UUID
	 *
	 * @mbg.generated
	 */
	private String uuid;

	/**
	 * 创建时间
	 *
	 * @mbg.generated
	 */
	private Date createTime;

	/**
	 * 更新时间
	 *
	 * @mbg.generated
	 */
	private Date updateTime;

	/**
	 * 状态 0、未启用 1、启用
	 *
	 * @mbg.generated
	 */
	private Integer status;
	
	private String extends1;
	
	private String extends2;
	
	private Date extends3;
	
	private Date extends4;
	
	private Integer extends5;
	
	private Long extends6;

	/**
	 * 描述
	 *
	 * @mbg.generated
	 */
	private String dmDesc;
	private String dmDesc2;
	private String dmDesc3;
	private String dmDesc4;
	private String dmDesc5;
	private String dmDesc6;
	private String dmDesc7;
	private String dmDesc8;
	private String dmDesc9;

	public Long getId() {
		return id;
	}

	public void setId(Long id) {
		this.id = id;
	}

	public String getUuid() {
		return uuid;
	}

	public void setUuid(String uuid) {
		this.uuid = uuid;
	}

	public Date getCreateTime() {
		return createTime;
	}

	public void setCreateTime(Date createTime) {
		this.createTime = createTime;
	}

	public Date getUpdateTime() {
		return updateTime;
	}

	public void setUpdateTime(Date updateTime) {
		this.updateTime = updateTime;
	}

	public Integer getStatus() {
		return status;
	}

	public void setStatus(Integer status) {
		this.status = status;
	}

	public String getDmDesc() {
		return dmDesc;
	}

	public void setDmDesc(String dmDesc) {
		this.dmDesc = dmDesc;
	}

	public String getExtends1() {
		return extends1;
	}

	public void setExtends1(String extends1) {
		this.extends1 = extends1;
	}

	public String getExtends2() {
		return extends2;
	}

	public void setExtends2(String extends2) {
		this.extends2 = extends2;
	}

	public Date getExtends3() {
		return extends3;
	}

	public void setExtends3(Date extends3) {
		this.extends3 = extends3;
	}

	public Date getExtends4() {
		return extends4;
	}

	public void setExtends4(Date extends4) {
		this.extends4 = extends4;
	}

	public Integer getExtends5() {
		return extends5;
	}

	public void setExtends5(Integer extends5) {
		this.extends5 = extends5;
	}

	public Long getExtends6() {
		return extends6;
	}

	public void setExtends6(Long extends6) {
		this.extends6 = extends6;
	}

	public String getDmDesc2() {
		return dmDesc2;
	}

	public void setDmDesc2(String dmDesc2) {
		this.dmDesc2 = dmDesc2;
	}

	public String getDmDesc3() {
		return dmDesc3;
	}

	public void setDmDesc3(String dmDesc3) {
		this.dmDesc3 = dmDesc3;
	}

	public String getDmDesc4() {
		return dmDesc4;
	}

	public void setDmDesc4(String dmDesc4) {
		this.dmDesc4 = dmDesc4;
	}

	public String getDmDesc5() {
		return dmDesc5;
	}

	public void setDmDesc5(String dmDesc5) {
		this.dmDesc5 = dmDesc5;
	}

	public String getDmDesc6() {
		return dmDesc6;
	}

	public void setDmDesc6(String dmDesc6) {
		this.dmDesc6 = dmDesc6;
	}

	public String getDmDesc7() {
		return dmDesc7;
	}

	public void setDmDesc7(String dmDesc7) {
		this.dmDesc7 = dmDesc7;
	}

	public String getDmDesc8() {
		return dmDesc8;
	}

	public void setDmDesc8(String dmDesc8) {
		this.dmDesc8 = dmDesc8;
	}

	public String getDmDesc9() {
		return dmDesc9;
	}

	public void setDmDesc9(String dmDesc9) {
		this.dmDesc9 = dmDesc9;
	}
	
	
}