mysql连接数据库测试代码_mysql连接数据库并测试

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

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

org.mybatis

mybatis

3.4.5

MySQL

mysql-connector-Java

5.1.38

2.编写mybatis的配置文件

/p>

PUBLIC "-//mybatis.org//DTD Config 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-config.dtd">

3.编写映射文件UserMapper.xml

/p>

PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

select * from user

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 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把表中的数据映射成为一个对象了...渣渣写的随便看看就好