{"id":118,"date":"2016-03-16T23:11:34","date_gmt":"2016-03-16T15:11:34","guid":{"rendered":"http:\/\/www.chenweikang.top\/?p=118"},"modified":"2016-03-16T23:51:25","modified_gmt":"2016-03-16T15:51:25","slug":"mybatis%e5%ad%a6%e4%b9%a0%e4%b9%8b%e8%b7%af-helloworld","status":"publish","type":"post","link":"https:\/\/www.chenweikang.top\/?p=118","title":{"rendered":"Mybatis\u5b66\u4e60\u4e4b\u8def---HelloWorld"},"content":{"rendered":"
\n
<\/div>\n
MyBatis \u672c\u662fapache<\/a>\u7684\u4e00\u4e2a\u5f00\u6e90\u9879\u76eeiBatis<\/a>, 2010\u5e74\u8fd9\u4e2a\u9879\u76ee\u7531apache software foundation \u8fc1\u79fb\u5230\u4e86google code\uff0c\u5e76\u4e14\u6539\u540d\u4e3aMyBatis \u30022013\u5e7411\u6708\u8fc1\u79fb\u5230Github\u3002<\/div>\n
iBATIS\u4e00\u8bcd\u6765\u6e90\u4e8e\u201cinternet\u201d\u548c\u201cabatis\u201d\u7684\u7ec4\u5408\uff0c\u662f\u4e00\u4e2a\u57fa\u4e8eJava\u7684\u6301\u4e45\u5c42<\/a>\u6846\u67b6\u3002iBATIS\u63d0\u4f9b\u7684\u6301\u4e45\u5c42\u6846\u67b6\u5305\u62ecSQL Maps\u548cData Access Objects\uff08DAO\uff09<\/div>\n
<\/div>\n
OK \u5f00\u542fMybatis\u5b66\u4e60\u4e4b\u8def<\/div>\n<\/blockquote>\n
\u00a0\"1\"<\/div>\n

\u4e00\u3001\u521b\u5efa\u9879\u76ee \u914d\u7f6emybatis<\/h2>\n

1. \u5bfc\u5165mybatis jar\u5305<\/h3>\n

com.mysql.jdbc.Driver.jar ---\u6570\u636e\u5e93\u8fde\u63a5<\/p>\n

log4j-1.2.17.jar ---\u65e5\u5fd7\u8bb0\u5f55<\/p>\n

mybatis-3.3.1.jar ---mybatis\u6838\u5fc3<\/p><\/blockquote>\n

2. \u6dfb\u52a0\u914d\u7f6e\u6587\u4ef6<\/h3>\n
\n

A . db.properties \u6570\u636e\u5e93\u8fde\u63a5\u4fe1\u606f<\/h4>\n

 <\/p>\n

driver=com.mysql.jdbc.Driver<\/p>\n

url=jdbc:mysql:\/\/127.0.0.1:3306\/mybatis_db<\/p>\n

username=root<\/p>\n

password=199432<\/p>\n

B. mybatis-config.xml mybatis \u914d\u7f6e\u6587\u4ef6<\/h4>\n

 <\/p>\n

<!-- \u5f15\u5165\u6570\u636e\u5e93\u8fde\u63a5\u914d\u7f6e --><\/p>\n

<properties resource=\"db.properties\" \/><\/p>\n

<!-- \u6307\u5b9a\u522b\u540d\u6240\u5728\u7684\u5305 --><\/p>\n

<typeAliases><\/p>\n

<package name=\"com.cwk.model\" \/><\/p>\n

<\/typeAliases><\/p>\n

<environments default=\"development\"><\/p>\n

<!-- \u53ef\u4ee5\u914d\u7f6e\u591a\u4e2a\u73af\u5883 \u4f7f\u7528default\u6307\u5b9a\u4f7f\u7528\u54ea\u4e2a\u73af\u5883 --><\/p>\n

<environment id=\"development\"><\/p>\n

<transactionManager type=\"JDBC\"\/><\/p>\n

<dataSource type=\"POOLED\"><\/p>\n

<property name=\"driver\" value=\"${driver}\"\/><\/p>\n

<property name=\"url\" value=\"${url}\"\/><\/p>\n

<property name=\"username\" value=\"${username}\"\/><\/p>\n

<property name=\"password\" value=\"${password}\"\/><\/p>\n

<\/dataSource><\/p>\n

<\/environment><\/p>\n

<\/environments><\/p>\n

<!-- mapper\u6620\u5c04\u6587\u4ef6\u6240\u5728\u7684\u5305 --><\/p>\n

<mappers><\/p>\n

<package name=\"com.cwk.dao\"\/><\/p>\n

<\/mappers><\/p>\n

 <\/p><\/blockquote>\n

\u4e8c\u3001\u521b\u5efa\u5b9e\u4f53\u7c7b Mapper\u63a5\u53e3\u548c<\/h2>\n

3. \u521b\u5efa\u5b9e\u4f53\u7c7b \uff0c\u521b\u5efaEmployeeMapper \u63a5\u53e3 \u548c \u540c\u540d\u7684\u6620\u5c04\u6587\u4ef6<\/h3>\n

 <\/p>\n

<mapper namespace=\"com.cwk.dao.EmployeeMapper\" >
\n<!--\u5b9e\u73b0\u6dfb\u52a0\u6570\u636e-->
\n<insert id=\"add\" parameterType=\"Employee\">
\nINSERT INTO employee
\n(username,salary,deptID)
\nVALUES
\n(#{username},#{salary},#{deptID})
\n<\/insert>
\n<\/mapper><\/p><\/blockquote>\n

4. \u521b\u5efa\u5de5\u5177\u7c7b \u83b7\u53d6SqlSession<\/h3>\n

 <\/p>\n

public class SqlSessionFactoryUtil {<\/p>\n

private static SqlSessionFactory sqlSessionFactory = null;<\/p>\n

private static SqlSessionFactory getSessionFactory(){<\/p>\n

\/\/\u521d\u59cb\u5316 sqlSessionFactory<\/p>\n

if(sqlSessionFactory==null){<\/p>\n

Reader reader;<\/p>\n

try {<\/p>\n

reader = Resources.getResourceAsReader(\"mybatis-config.xml\"); \/\/\u8bfb\u53d6\u914d\u7f6e\u6587\u4ef6<\/p>\n

sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);<\/p>\n

} catch (IOException e) {<\/p>\n

e.printStackTrace();<\/p>\n

}
\n}<\/p>\n

return sqlSessionFactory;
\n}<\/p>\n

public static SqlSession openSession(){<\/p>\n

return getSessionFactory().openSession(); \u00a0\/\/\u8fd4\u56deiSqlSession
\n}<\/p><\/blockquote>\n

5. \u521b\u5efa\u6d4b\u8bd5\u7c7b(\u4f7f\u7528junit\u6d4b\u8bd5)<\/h3>\n

 <\/p>\n

private SqlSession sqlSession = null;<\/p>\n

private Logger logger = null;<\/p>\n

@Before
\npublic void setUp() throws Exception {<\/p>\n

\/\/\u521d\u59cb\u6570\u636e\u5e93\u8fde\u63a5<\/p>\n

sqlSession = SqlSessionFactoryUtil.openSession();<\/p>\n

\/\/\u6570\u636e\u65e5\u5fd7<\/p>\n

logger = Logger.getLogger(TestCRUD.class);
\n}<\/p>\n

@After<\/p>\n

public void tearDown() throws Exception {<\/p>\n

sqlSession.close();
\n}<\/p>\n

@Test
\npublic void testAdd() {<\/p>\n

logger.info(\"\u6dfb\u52a0\u5458\u5de5!\");<\/p>\n

Employee emp = new Employee(3,\"\u738b\u4e94\",3500f);<\/p>\n

EmployeeMapper empMapper = sqlSession.getMapper(EmployeeMapper.class);<\/p>\n

int res = empMapper.add(emp);<\/p>\n

System.out.println(emp);<\/p>\n

sqlSession.commit();
\nif(res>0){<\/p>\n

logger.info(\"\u6dfb\u52a0\u6210\u529f!\");
\n}else{<\/p>\n

logger.info(\"\u6dfb\u52a0\u5931\u8d25!\");
\n}}<\/p><\/blockquote>\n

\u8f6c\u8f7d\u8bf7\u6ce8\u660e\uff1a\u5de6\u624b\u4ee3\u7801\u53f3\u624b\u8bd7<\/a> » Mybatis\u5b66\u4e60\u4e4b\u8def---HelloWorld<\/a><\/p>

\r\n
\r\n
~\u8c22\u8c22\u6253\u8d4f~<\/div>\r\n
<\/div>
<\/div>
<\/div><\/div>\r\n