1.准备jar包
mybatis包(mybatis-3.2.2.jar)
jdbc包(mysql-connector-java-5.1.17.jar)
2.数据库表
表名称:User
表字段以及类型:
字段名称 | 类型 |
id | int |
username | varchar |
password | varchar |
3.开始写程序
实体类
package test.model;
public class User {
//id
private int id;
//用户名
private String username;
//密码
private String password;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
}
user.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="test.dao.UserDao">
<select id="get" parameterType="int" resultType="test.model.User">
select * from admin_menus where id=#{id}
</select>
</mapper>
mybatis.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>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC" />
<dataSource type="POOLED">
<property name="driver" value="com.mysql.jdbc.Driver" />
<!-- 注意写自己的url -->
<property name="url"
value="jdbc:mysql://192.168.0.220:3306/spark?autoReconnect=true&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull" />
<property name="username" value="out-devops" />
<property name="password" value="out-devops123456" />
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="test/user.xml"/>
</mappers>
</configuration>
dao层代码
package test.dao;
import test.model.User;
/**
* User
* @author admin
*
*/
public interface UserDao {
/**
* 根据ID获取该条记录
* @param id
* @return User对象
*/
public User get(int id);
}
测试代码
package test.test;
import java.io.IOException;
import java.io.Reader;
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 test.dao.UserDao;
import test.model.User;
public class TsetUser {
public static void main(String[] arg0){
//开启sqlsession
SqlSession session = getSqlSession().openSession();
UserDao userDao = session.getMapper(UserDao.class);
User user = userDao.get(1);
if(user != null){
System.out.println(user.getUsername());
}else{
System.out.println("没有获取到数据");
}
}
/**
* 获取sqlsessionfactory
* @return
*/
private static SqlSessionFactory getSqlSession(){
SqlSessionFactory sqlSession = null;
//ibatis配置文件路径
String resource = "test/mybatis.xml";
try {
//读取配置文件
Reader reader = Resources.getResourceAsReader(resource);
SqlSessionFactoryBuilder factoryBuilder = new SqlSessionFactoryBuilder();
sqlSession = factoryBuilder.build(reader);
} catch (IOException e) {
e.printStackTrace();
}
return sqlSession;
}
}
以上若有不对,忘不吝指出!