Eclipse下使用Mybatis连接阿里云数据库

参考：
https://blog.csdn.net/carson0408/article/details/79232569

1.
下载jar包并导入

2.namemapper.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="gui.frame.UserMapper">

    <select id="selectall" resultType="gui.frame.User">
        select * from student
    </select>
    
    <select id="selectUser" resultType="gui.frame.User">
    select * from student where setudentid=#{id}
    </select>

</mapper>

3.mybatis-config.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>

    <properties resource="jdbc.properties" />

    <!--  JavaBean类型自动映射扫描包配置 Java类型别名  -->

    <environments default="development">
        <!-- 数据库环境 -->
        <environment id="development">
            <!-- 使用JDBC使用管理 -->
            <transactionManager type="JDBC"/>
            <!-- 数据源配置 -->
            <dataSource type="POOLED">
                <property name="driver" value="${driver}"/>
                <property name="url" value="${url}"/>
                <property name="username" value="${username}"/>
                <property name="password" value="${password}"/>
            </dataSource>
        </environment>
    </environments>
    <!-- 映射器 ,namemapper.xml的路径-->
    <mappers>
        <mapper resource="mapper/UserMapper.xml"/>
    </mappers>
</configuration>

4.jdbc.config

driver=com.mysql.cj.jdbc.Driver
url=jdbc:mysql://rm-bp12je815pc5886c7xo.mysql.rds.aliyuncs.com:3306/study?useUnicode=true&characterEncoding=utf8
username=jason
password=1312487887qQ

url指定使用的数据库

5.namemapper.java

package gui.frame;
import java.util.List;

public interface UserMapper {
	public List<User> selectall();
    public User selectUser(String id);
}

是一个接口，在UserMapper中实现

6.user.java

package gui.frame;
public class User {

    //private int id;
    //private String username;
    //private String password;
    //private String sex;
    //private int age;
    //private String qq;
   // private String weichart;
   // private String email;
    private String studentid;
    private String studentname;
    public User(){
    	
    }
    public User(String name,String id) {
    	this.studentid=id;
    	this.studentname=name;
    }
    
	public String getStudentid() {
		return studentid;
	}
	public void setStudentid(String studentid) {
		this.studentid = studentid;
	}
	public String getStudentname() {
		return studentname;
	}
	public void setStudentname(String studentname) {
		this.studentname = studentname;
	}

}

在指定数据库中的属性名，并实现其setter和getter
7.mybatis.java

package gui.frame;
import java.io.IOException;
import java.io.InputStream;
import java.util.Iterator;
import java.util.List;

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 gui.frame.UserMapper;

public class mybatistest {

	public static void main(String[] args) throws IOException {
		// TODO Auto-generated method stub
		// TODO Auto-generated method stub
		//读取MyBatis配置文件
		InputStream inputStream=Resources.getResourceAsStream("mybatis-config.xml");
		//初始化mybatis，创建SqlSessionFactory类的实例。
		SqlSessionFactory sqlSessionFactory=new SqlSessionFactoryBuilder().build(inputStream);
		//创建Session实例
		SqlSession session=sqlSessionFactory.openSession();
		//创建User对象
		UserMapper userMapper=session.getMapper(UserMapper.class);
		//User user=new User("Carson","10086");
		//userMapper.insertUser(user);
		//user=new User("THL","女",23);
		//userMapper.insertUser(user);
		//session.commit();
		List<User> list=userMapper.selectall();
		Iterator<User> i=list.iterator();
		while(i.hasNext()) {
			User m=i.next();
		System.out.println(m.getStudentname()+" "+m.getStudentid());
		}
		//userMapper.deleteUser();
		session.commit();
		session.close();
	}

}

注意import gui.frame.UserMapper;，