本文主要和大家分享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把表中的数据映射成为一个对象了。
相关推荐：
php mysql连接数据库实例_mysql
mysql连接数据库函数内存泄露解决方案
python和mysql连接数据库的问题
以上就是mysql连接数据库并测试实例分享的详细内容。