视频1 视频21 视频41 视频61 视频文章1 视频文章21 视频文章41 视频文章61 推荐1 推荐3 推荐5 推荐7 推荐9 推荐11 推荐13 推荐15 推荐17 推荐19 推荐21 推荐23 推荐25 推荐27 推荐29 推荐31 推荐33 推荐35 推荐37 推荐39 推荐41 推荐43 推荐45 推荐47 推荐49 关键词1 关键词101 关键词201 关键词301 关键词401 关键词501 关键词601 关键词701 关键词801 关键词901 关键词1001 关键词1101 关键词1201 关键词1301 关键词1401 关键词1501 关键词1601 关键词1701 关键词1801 关键词1901 视频扩展1 视频扩展6 视频扩展11 视频扩展16 文章1 文章201 文章401 文章601 文章801 文章1001 资讯1 资讯501 资讯1001 资讯1501 标签1 标签501 标签1001 关键词1 关键词501 关键词1001 关键词1501 专题2001
mysql连接数据库并测试实例分享
2020-11-09 08:43:57 责编:小采
文档
 本文主要和大家分享mysql连接数据库并测试实例,希望能帮助到大家。

1.通过maven导入关于mybatis的jar包

可以通过阿里云的maven库直接下载相关jar包

<dependencies>
 <dependency>
 <groupId>org.mybatis</groupId>
 <artifactId>mybatis</artifactId>
 <version>3.4.5</version>
 </dependency>
<dependency>
 <groupId>MySQL</groupId>
 <artifactId>mysql-connector-Java</artifactId>
 <version>5.1.38</version>
</dependency>
</dependencies>

2.编写mybatis的配置文件

<?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" /> 
 <!-- 配置数据库 -->
 <dataSource type="POOLED"> 
 <property name="driver" value="com.mysql.jdbc.Driver" /> 
 <property name="url" value="jdbc:mysql://localhost:3306/my_schema?useSSL=true" /> 
 <property name="username" value="root" /> 
 <property name="password" value="" /> 
 </dataSource> 
 </environment> 
</environments> 
<!-- 映射文件 -->
<mappers> 
 <mapper resource="UserMapper.xml" /> 
</mappers> 
</configuration>

3.编写映射文件UserMapper.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="userMapper"> 
<select id="selectUser" resultType="entity.User"> 
 select * from user 
</select> 
</mapper>

4.写出实体类User,很平常的类,就不在过多解释.

public class User {
private String username;
private String email;
private String password;
private String create_time;
public String getUsername() {
 return username;
}
public void setUsername(String username) {
 this.username = username;
}
public String getEmail() {
 return email;
}
public void setEmail(String email) {
 this.email = email;
}
public String getPassword() {
 return password;
}
public void setPassword(String password) {
 this.password = password;
}
public String getCreate_time() {
 return create_time;
}
public void setCreate_time(String create_time) {
 this.create_time = create_time;
}
@Override
public String toString() {
 return "User [username=" + username + ", email=" + email + ", password=" + password + ", create_time="
 + create_time + "]";
}
public User(String username, String email, String password, String create_time) {
 super();
 this.username = username;
 this.email = email;
 this.password = password;
 this.create_time = create_time;
}
public User() {
 super();
}

}

5.在写一个类MybatisSamples,里面包含main方法,进行测试.

具体代码如下

public static void main(String[] args) {
 String resource = "mybatis-config.xml";
 SqlSession session = null;
 try {
 InputStream is = Resources.getResourceAsStream(resource);
 //获取一个session工厂
 SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(is);
 //通过工厂获取session
 session = sqlSessionFactory.openSession();
 //根据映射文件中select标签的id获取集合
 List<User> list = session.selectList("userMapper.selectUser");
 for(User user: list) {
 System.out.println(user);
 
 }
 } catch (IOException e) {
 // TODO Auto-generated catch block
 e.printStackTrace();
 }finally {
 //注意关闭session!!!
 session.close();
 }
 
}

执行结果如下:

附:
包结构

数据库结构

总结:想入门mybatis最重要的两步,第一是写配置文件,配置数据库和mapper,第二步是写好mapper和实体类,mapper中写sql语句,然后可以就可以通过mybatis把表中的数据映射成为一个对象了。

下载本文
显示全文
专题