MyBatis使用註解開發和無主配置文件開發的情況

public class User implements Serializable {

 private long userId;
 private String userName;
 private Date birthday;
 private String sex;
 private String address;

getter setter toString

<?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="db.properties"/>

 <!--開啟駝峰命名-->
 <settings>
  <setting name="mapUnderscoreToCamelCase" value="true"/>
 </settings>

 <!--起別名 typeAliases-->
 <typeAliases>
  <package name="com.codeyancy.cn.entity"/>
 </typeAliases>

 <environments default="development">
  <environment id="development">
   <transactionManager type="JDBC"/>
   <dataSource type="POOLED">
    <property name="driver" value="${jdbc.driverClassName}"/>
    <property name="url" value="${jdbc.url}"/>
    <property name="username" value="${jdbc.username}"/>
    <property name="password" value="${jdbc.password}"/>
   </dataSource>
  </environment>
 </environments>

 <mappers>
  <!--包掃描-->
  <package name="com.codeyancy.cn.mapper"/>
 </mappers>
</configuration>

jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/web_test?characterEncoding=utf-8
jdbc.username=root
jdbc.password=666

public interface UserMapper {

 /**
  * 查詢所有用戶信息
  */
 @Select("select * from user")
 List<User> findAll();

 /**
  * 根據id查詢用戶信息
  */
 @Select("select * from user where user_id=#{userId}")
 User findById(Integer id);

 /**
  * 新增
  */
 @Insert("insert into user (user_name,birthday,sex,address) values (#{userName},#{birthday},#{sex},#{address})")
 void insertUser(User user);

 /**
  * 修改
  */
 @Update("update user set user_name=#{userName},birthday=#{birthday},sex=#{sex},address=#{address} where user_id=#{userId}")
 void updateUser(User user);

 /**
  * 刪除
  */
 @Delete("delete from user where user_id=#{userId}")
 void deleteUserById(Integer id);

	/**
  * 通過id或者名字模糊查詢
  * 多個參數查詢方式二：@Param
  */
 @Select("select * from user where user_id=#{id} or user_name like '%${name}%'")
 List<User> select(@Param("id") Integer id, @Param("name") String name);
}

public class Demo {

 public static void main(String[] args) {
  String path="mybatis-config.xml";
  InputStream resourceAsStream = null;
  try {
   resourceAsStream = Resources.getResourceAsStream(path);
  } catch (IOException e) {
   e.printStackTrace();
  }
  SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsStream);
  SqlSession sqlSession = sqlSessionFactory.openSession(true);
  UserMapper mapper = sqlSession.getMapper(UserMapper.class);

  //System.out.println(mapper.findAll());
  //System.out.println(mapper.findById(1));

  /*User user = new User();
  user.setUserName("老皮");
  user.setBirthday(new Date());
  mapper.insertUser(user);*/

  /*User user = new User();
  user.setUserName("李立林");
  user.setBirthday(new Date());
  user.setUserId(27);
  mapper.updateUser(user);*/

  //mapper.deleteUserById(27);

		System.out.println(mapper.select(1, "麻"));

  sqlSession.close();
  try {
   resourceAsStream.close();
  } catch (IOException e) {
   e.printStackTrace();
  }
 }
}

* 如果數據庫列名和實體類屬性名不一致或者沒有開啟駝峰命名，可以使用@Results解決這個問題
 *
 * @Select("sql語句")
 * @Results({
 *  @Result(column="",property=""),
 *  @Result(column="",property=""),
 *  @Result(column="",property=""),
 * })
 *
 * 使用註解也可以一對一，一對多
 *  @Result(column="",property="",one=@One("sql語句")), 一對一
 *  @Result(column="",property="",one=@Many("sql語句")), 一對多

/**
 *使用java類代替mybatis-config.xml主配置文件
 */
public class MyBatisDemo {
 public static void main(String[] args) {
  //加載db.properties文件方式一
//  InputStream resourceAsStream = MyBatisDemo.class.getClassLoader().getResourceAsStream("db.properties");
//  Properties properties = new Properties();
//  try {
//   properties.load(resourceAsStream);
//  } catch (IOException e) {
//   e.printStackTrace();
//  }
//  String drive = properties.getProperty("jdbc.driverClassName");
//  String url = properties.getProperty("jdbc.url");
//  String name = properties.getProperty("jdbc.username");
//  String pass = properties.getProperty("jdbc.password");
//  DataSource dataSource = new PooledDataSource(drive,url,name,pass);

  //加載db.properties文件方式二(推薦)
  ResourceBundle bundle = ResourceBundle.getBundle("db");
  String drive = bundle.getString("jdbc.driverClassName");
  String url = bundle.getString("jdbc.url");
  String name = bundle.getString("jdbc.username");
  String pass = bundle.getString("jdbc.password");

  DataSource dataSource = new PooledDataSource(drive,url,name,pass);
  TransactionFactory transactionFactory = new JdbcTransactionFactory();
  Environment environment = new Environment("development", transactionFactory, dataSource);
  Configuration configuration = new Configuration(environment);
  //開啟包掃描
  configuration.addMappers("com.codeyancy.cn.mapper");
  //開啟駝峰命名
  configuration.setMapUnderscoreToCamelCase(true);
  //設置別名
  //configuration.getTypeAliasRegistry().registerAliases("com.codeyancy.cn.entity");
  SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(configuration);
  SqlSession sqlSession = sqlSessionFactory.openSession(true);
  UserMapper mapper = sqlSession.getMapper(UserMapper.class);

  //打印查詢所有
  System.out.println(mapper.findAll());

  sqlSession.close();
 }
}