mybatis实现增删改查.pdf

mybatis 实现增删改查 所需要用到的其他工具或技术: 项目管理工具 : Maven 测试运行工具 : Junit 数据库 : Derby Maven Dependencies: 1. dependencies 2. dependency 3. groupId org.mybatis /groupId 4. artifactId mybatis/artifactId 5. version 3.2.7/version 6. /dependency 7. dependency 8. groupId junit /groupId 9. artifactId junit /artifactId 10. version 4.9 /version 11. scopetest /scope 12. /dependency 13. dependency 14. groupId org.apache.derby /groupId 15. artifactId derby /artifactId 16. version /version 17. /dependency 18. dependency 19. groupId org.apache.derby /groupId 20. artifactId derbyclient/artifactId 21. version /version 22. /dependency 23. /dependencies SQL 建表及数据插入（沿用前两节中的数据库表及数据）: 1. CREATE TABLE USER_TEST_TB( 2. ID INT PRIMARY KEY, 3. USERNAME VARCHAR(20) NOT NULL, 1 / 10 4. PASSWORD VARCHAR(20) NOT NULL, 5. NICKNAME VARCHAR(20) NOT NULL 6. ); 7. 8. INSERT INTO USER_TEST_TB VALUES(1,1st,111,Jack); 9. INSERT INTO USER_TEST_TB VALUES(2,2nd,222,Rose); 10. INSERT INTO USER_TEST_TB VALUES(3,3rd,333,Will); Mybatis 配置文件 src/main/resource 源目录下 test-mybatis-configuration.xml 1. ?xml version =1.0 encoding=UTF-8 ? 2. !DOCTYPE configuration 3. PUBLIC -////DTD Config 3.0//EN 4. /dtd/mybatis-3-config.dtd 5. configuration 6. properties 7. property name=driver value =org.apache.derby.jdbc.ClientDriver / 8. property name=url 9. value =jdbc:derby://localhost:1527/bjpowernode;create=true / 10. /properties 11. environments default=develop