mysql create read

vison.cao · vison.cao · commit 395c161ea303 · 2021-01-06T16:04:36.000+08:00
diff --git a/src/main/java/com/vison/webmvc/controller/UserController.java b/src/main/java/com/vison/webmvc/controller/UserController.java
@@ -29,27 +29,26 @@ public String profile(HttpServletRequest request, HttpServletResponse response)
     }
 
     @GetMapping(path = "/user")
-    public Response user() {
+    public Response user(HttpServletRequest request, int id) {
         User user = null;
         SqlSession session = MybatisLoader.getSqlSessionFactory().openSession();
         UserMapper mapper = session.getMapper(UserMapper.class);
-        user = mapper.selectUser(1);
-
+        user = mapper.selectUser(id);
         return new Response(0, "获取成功", user);
     }
 
     @PostMapping(path = "/user/add")
     public Response add(User user) {
         Log.info("request user", user);
         try {
-//            EntityManagerFactory emf = Persistence.createEntityManagerFactory("itdoc");
-//            Session session = HibernateLoader.sessionFactory.openSession();
-//            EntityManager entityManager = emf.createEntityManager();
-//            session.save(user);
+            SqlSession session = MybatisLoader.getSqlSessionFactory().openSession();
+            UserMapper mapper = session.getMapper(UserMapper.class);
+            int id = mapper.insertUser(user);
+            session.commit();
+            Log.debug("返回", id);
         } catch (Exception e) {
             Log.error("保存失败", e);
         }
-
-        return new Response(0, "获取成功", user);
+        return new Response(0, "保存", user);
     }
 }
diff --git a/src/main/java/com/vison/webmvc/dao/UserMapper.java b/src/main/java/com/vison/webmvc/dao/UserMapper.java
@@ -1,6 +1,7 @@
 package com.vison.webmvc.dao;
 
 import com.vison.webmvc.entity.User;
+import org.apache.ibatis.annotations.Insert;
 import org.apache.ibatis.annotations.Select;
 
 /**
@@ -12,4 +13,7 @@ public interface UserMapper {
     @Select("SELECT * FROM user WHERE id = #{id}")
     User selectUser(int id);
 
+    @Insert("INSERT INTO user(name,email) VALUES(#{name}, #{email})")
+    int insertUser(User user);
+
 }
