简单mybatis配置实现连接mysql数据库

步骤如下：

1、创建java项目
2、下载mysql驱动jar包  https://dev.mysql.com/downloads/file/?id=476197
3、下载mybatis的jar包 网上可以下载
4、准备好数据库
5、在src文件夹下创建文件config/Configure.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>
		<typeAlias alias="Student" type="com.wb.mybatis.models.Student" />
	</typeAliases>
	<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://127.0.0.1:3306/mydb" />
			    <property name="username" value="root" />
			    <property name="password" value="root" />
                </dataSource>
        </environment>
    </environments>

	<mappers>
	     <mapper resource="com/wb/mybatis/models/Student.xml" />
	</mappers>
</configuration>

6、在src文件夹下创建文件com/wb/mybatis/models/Student.java和Student.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.wb.mybatis.models.StudentMapper">
	<select id="test" parameterType="int" resultType="Student">
		select * 
		from student 
		where id = #{id}
    </select>
</mapper>

7、新建测试类

public class Tee {
	private static SqlSessionFactory sqlSessionFactory;
	private static Reader reader;

	static {
		try {
			reader = Resources.getResourceAsReader("config/Configure.xml");
			sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	public static SqlSessionFactory getSession() {
		return sqlSessionFactory;
	}
	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		SqlSession session = sqlSessionFactory.openSession();
		try {
			Student area = (Student) session.selectOne(
					"com.wb.mybatis.models.StudentMapper.test",123442);
			if(area!=null){
				String userInfo = "名字："+area.getName()+", id："+area.getId();
				System.out.println(userInfo);
			}
		} finally {
			session.close();
		}
	}
}