create database School; use School; create table Users ( id int primary key, name varchar(200) );
导入 MyBatis的jar包到WEB-INF/lib目录下
在src下新建:database.properties文件
driver=com.mysql.jdbc.Driver url=jdbc:mysql://localhost:3306/school username=root password=root
新建包th.bean 新建类:User
package th.bean; public class User { private int id; private String name; public User() { super(); // TODO Auto-generated constructor stub } public int getId() { return id; } public void setId(int id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } }
在src下新建一个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="database.properties"></properties> <environments default="development"> <environment id="development"> <!-- 处理方式JDBC --> <transactionManager type="JDBC"></transactionManager> <!-- 编写数据源 --> <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> <!-- 配置映射的mapping --> <mappers> <mapper resource="th/dao/mapping/UserMapper.xml"></mapper> </mappers> </configuration>
新建包:th.dao.mapping ,新建文件:UserMapping.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="th.dao.mapping.UserMapper" > //根据ID查询指定用户 <select id="getUser" parameterType="Integer" resultType="th.bean.User"> select * from users where id = #{id} </select> </mapper>
import org.apache.ibatis.session.SqlSessionFactoryBuilder; import th.bean.User; public class UserTest { @org.junit.Test public void test{ String resource = "MyBatis-config.xml"; try { InputStream ins = Resources.getResourceAsStream(resource); SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(ins); SqlSession session = sessionFactory.openSession(); User user = session.selectOne("th.dao.mapping.UserMapper.getUser",2); System.out.println("用户id:"+user.getId()+"\t用户名称:"+user.getName()); }
如对本文有疑问, 点击进行留言回复!!
Flink程序JDK8 运行一段时间后NullException解决
解决: java.lang.NoClassDefFoundError: org/apache/http/client/HttpClient
SpringBoot中定制异常页面(404页面配置提高用户体验)
DataGrip和IDEA无法连接上Mysql问题解决方法详解
Java基础语法(多态、类、接口、Date类、基本类型、系统类)
网友评论