package com.cy.mybatis.service; 2 3 import java.util.List; 4 5 import org.apache.ibatis.session.SqlSession; 6 7 import com.cy.mybatis.beans.UserBean; 8 import com.cy.mybatis.tools.DBTools; 9 import com.cy.mybatis.mapper.UserMapper; 10 11 public class UserService { 12 13 14 15 16 public static void main(String[] args) { 17 insertUser(); 18 // deleteUser(); 19 // selectUserById(); 20 // selectAllUser(); 21 } 22 23 24 /** 25 * 新增用户 26 */ 27 private static void insertUser() { 28 SqlSession session = DBTools.getSession(); 29 UserMapper mapper = session.getMapper(UserMapper.class); 30 UserBean user = new UserBean("懿", "1314520", 7000.0); 31 try { 32 mapper.insertUser(user); 33 System.out.println(user.toString()); 34 session.commit(); 35 } catch (Exception e) { 36 e.printStackTrace(); 37 session.rollback(); 38 } 39 } 40 41 42 /** 43 * 删除用户 44 */ 45 private static void deleteUser(){ 46 SqlSession session=DBTools.getSession(); 47 UserMapper mapper=session.getMapper(UserMapper.class); 48 try { 49 mapper.deleteUser(1); 50 session.commit(); 51 } catch (Exception e) { 52 e.printStackTrace(); 53 session.rollback(); 54 } 55 } 56 57 58 /** 59 * 根据id查询用户 60 */ 61 private static void selectUserById(){ 62 SqlSession session=DBTools.getSession(); 63 UserMapper mapper=session.getMapper(UserMapper.class); 64 try { 65 UserBean user= mapper.selectUserById(2); 66 System.out.println(user.toString()); 67 68 session.commit(); 69 } catch (Exception e) { 70 e.printStackTrace(); 71 session.rollback(); 72 } 73 } 74 75 /** 76 * 查询所有的用户 77 */ 78 private static void selectAllUser(){ 79 SqlSession session=DBTools.getSession(); 80 UserMapper mapper=session.getMapper(UserMapper.class); 81 try { 82 List<UserBean> user=mapper.selectAllUser(); 83 System.out.println(user.toString()); 84 session.commit(); 85 } catch (Exception e) { 86 e.printStackTrace(); 87 session.rollback(); 88 } 89 } 90 91 92 }
主函数调用其他方法
最新推荐文章于 2024-07-01 19:02:43 发布