maven与mybatis的小实例

最新推荐文章于 2024-08-13 21:13:17 发布

凤五寂寞哥

最新推荐文章于 2024-08-13 21:13:17 发布

阅读量641

点赞数 1

分类专栏： mybatis 文章标签： mybatis maven mysql

本文链接：https://blog.csdn.net/weixin_41866003/article/details/79918098

版权

mybatis 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

maven与mybatis的小实例

1.工程目录

2.具体步骤

1.新建maven项目

勾选第一个（跳过骨架选择），点击下一步

GroupID是项目组织唯一的标识符，实际对应JAVA的包的结构，是main目录里java目录结构，vincent是我的名字

ArtifactID就是项目的唯一的标识符，实际对应项目的名称，就是项目根目录的名称，设为mybatis1

其他默认，因为不是web项目，所以packaging选择jar

2.修改target目录下的pom.xml文件

添加

  <dependency>  
  <groupId>mysql</groupId>  
  <artifactId>mysql-connector-java</artifactId>  
  <version>5.1.38</version>  
</dependency>  
  
<!--mybatis依赖-->  
<dependency>  
  <groupId>org.mybatis</groupId>  
  <artifactId>mybatis</artifactId>  
  <version>3.4.1</version>  
</dependency>

3.创建mysql表

4.创建实体类person

person.java

package com.entity;

public class person {
private Integer id;
private String name;
private String age;
public Integer getId() {
	return id;
}
public void setId(Integer id) {
	this.id = id;
}
public String getName() {
	return name;
}
public void setName(String name) {
	this.name = name;
}
public String getAge() {
	return age;
}
public void setAge(String age) {
	this.age = age;
}

}

5.编写连接数据库的配置文件mybatisConfig.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>  
 <typeAliases>  
  <!--给实体类起一个别名 user -->  
  <typeAlias type="com.entity.person" alias="person" />  
 </typeAliases>  
 <!--数据源配置 这块用 mysql数据库 -->  
 <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://localhost:3306/user" />  
    <property name="username" value="root" />  
    <property name="password" value="" />  
   </dataSource>  
  </environment>  
 </environments>  
 <mappers>  
  <!--userMapper.xml装载进来 同等于把“dao”的实现装载进来 -->  
  <mapper resource="mapper/personMapper.xml" />  
 </mappers>  
</configuration>

6.编写personMapper接口

package com.dao;

import com.entity.person;

public interface personMapper {
public person find(Integer id);
}

7.编写personMapper的实现，personMapper.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"> 
    <mapper namespace="com.dao.personMapper">
    <!-- find必须和接口中的方法名一样 -->
    <select id="find" parameterType="HashMap" resultType="person">
 select  
  * from t_person where id=#{id}  
    
    </select>
    </mapper>

8.编写测试文件

package com.test;
import java.io.IOException;  
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.dao.personMapper;
import com.entity.person;  

public class test {  
	 private static SqlSessionFactory getSessionFactory() {  
		  SqlSessionFactory sessionFactory = null;  
		  String resource = "mybatisConfig.xml";  
		  try {  
		   sessionFactory = new SqlSessionFactoryBuilder().build(Resources  
		     .getResourceAsReader(resource));  
		  } catch (IOException e) {  
	
		   e.printStackTrace();  
		  }  
		  return sessionFactory;  
		 }  
		  
		 public static void main(String[] args) {  
		  SqlSession sqlSession = getSessionFactory().openSession();  
		  personMapper personMapper = sqlSession.getMapper(personMapper.class);  
		  person person = personMapper.find(1);  
		  person person2 = personMapper.find(2);  

		  person person3 = personMapper.find(3);  

		  System.out.println("name= "+person.getName()+"    age= "+person.getAge());  
		  System.out.println("name= "+person2.getName()+"    age= "+person2.getAge());  
		  System.out.println("name= "+person3.getName()+"    age= "+person3.getAge());  


		  
		 }  
    }