1配置maven环境,配置mybatis环境,
2 写接口
package bean;
import org. apache. ibatis. annotations. Select;
public interface Users {
@Select ( "select * from user where id = #{id}" )
User getUser ( String id) ;
}
3在config进行声明自己所引用的接口
<?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" />
< property name = " url" value = " jdbc:mysql://localhost:3306/lsq" />
< property name = " username" value = " root" />
< property name = " password" value = " 111111" />
</ dataSource>
</ environment>
</ environments>
< mappers>
< mapper resource = " sql.xml" />
< mapper class = " bean.Users" />
</ mappers>
</ configuration>
4进行调用
package main;
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 bean. User;
import bean. Users;
public class Main {
public static void main ( String[ ] args) {
try {
Reader read = Resources. getResourceAsReader ( "config.xml" ) ;
SqlSessionFactory sqlsessionFactory = new SqlSessionFactoryBuilder ( ) . build ( read) ;
SqlSession sqlsession = sqlsessionFactory. openSession ( ) ;
Users usermaper = sqlsession. getMapper ( Users. class ) ;
User user = usermaper. getUser ( "1" ) ;
System. out. println ( user) ;
} catch ( IOException e) {
e. printStackTrace ( ) ;
}
}
}