1. 新建一個名為SpringMybatis的Java項目, 添加相關jar包。

2. 在src目錄下配置jdbc.properties

3. 在src目錄下配置SqlMapConfig.xml

4. 在src目錄下配置applicationContext.xml

5. 創建User.java

package com.lywgames.domain;import java.util.Date;public class User {private Integer id;private String name;private String sex;private Date birthday;private String address;public User() {}public User(String name, String sex, Date birthday, String address) {this.name = name;this.sex = sex;this.birthday = birthday;this.address = address;}public User(Integer id, String name, String sex, Date birthday, String address) {this.id = id;this.name = name;this.sex = sex;this.birthday = birthday;this.address = address;}public Integer getId() {return id;}public void setId(Integer id) {this.id = id;}public String getName() {return name;}public void setName(String name) {this.name = name;}public String getSex() {return sex;}public void setSex(String sex) {this.sex = sex;}public Date getBirthday() {return birthday;}public void setBirthday(Date birthday) {this.birthday = birthday;}public String getAddress() {return address;}public void setAddress(String address) {this.address = address;}@Overridepublic String toString() {return "User [id=" + id + ", name=" + name + ", sex=" + sex + ", birthday=" + birthday + ", address=" + address+ "]";}}

6. 創建UserMapper.java

package com.lywgames.dao;import java.util.List; import com.lywgames.domain.User;public interface UserMapper {public List<User> selectUser(); }

7. 在和UserMapper.java相同的包下, 創建UserMapper.xml

8. 創建UserService.java

package com.lywgames.service;import java.util.List; import com.lywgames.domain.User;public interface UserService {List<User> selectUser(); }

9. 創建UserServiceImpl.java

package com.lywgames.service.impl;import java.util.List; import com.lywgames.dao.UserMapper; import com.lywgames.domain.User; import com.lywgames.service.UserService;public class UserServiceImpl implements UserService {private UserMapper userMapper;public void setUserMapper(UserMapper userMapper) {this.userMapper = userMapper;}@Overridepublic List<User> selectUser() {return userMapper.selectUser();}}

10. 創建Test.java

package com.lywgames;import java.util.List; import org.springframework.context.ApplicationContext; import org.springframework.context.support.ClassPathXmlApplicationContext; import com.lywgames.domain.User; import com.lywgames.service.UserService;public class Test {public static void main(String[] args) {// 類路徑加載配置文件ApplicationContext context = new ClassPathXmlApplicationContext("applicationContext.xml");// 獲取UserServiceUserService userService = context.getBean(UserService.class);// 查詢操作List<User> users = userService.selectUser();for (User user : users) {System.out.println(user);}} }

11. 數據庫user表內容

12. 運行結果

總結

以上是生活随笔為你收集整理的017_Spring+Mybatis+C3P0的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。