controller里 增删改查 http://localhost:8080/szcmaven/

http://localhost:8080/szcmaven/

    //增加
            @RequestMapping("addStudent1")
            public  void   addStudent1 (Student student) {

                       studentService.addStudent1(student);  
                       System.out.println(student);
                }

            //删除
            @RequestMapping("deleteStudent1")
            public  void   deleteStudent1 (int sid) {


                   studentService.deleteStudent1(sid);    
            }

            //修改
            @RequestMapping("updateStudent1")
            public void  updateStudent1 (Student student) {


               studentService.updateStudent1(student);
            }

            //查
            @RequestMapping("showStudent1")
            @ResponseBody
            public List<Student>  showStudent1 () {


                List<Student> showStudent1=  studentService.showStudent1();



                return showStudent1;
                }

mapping.xml 增删改查

<select id="showprivalige"  resultType="com.shy.pojo.User">
     select pname from privalige where pid in  (select   pid  from  roleprivilage  where rid in (SELECT  rid  FROM  userole where uid=1 ))  

    </select>

 <insert id="addStudent1" parameterType="com.shy.pojo.Student">
        INSERT INTO 
        student(sname,sex)
        VALUES
        (#{sname},#{sex})
    </insert>

<delete id="deleteStudent1" parameterType="int">
        DELETE 
        FROM student
        WHERE sid = #{sid}
    </delete>
 <update id="updateStudent1" parameterType="com.shy.pojo.Student">
        UPDATE studen set
        name = #{sname},
        number = #{sex}
        where sid = #{sid}
    </update> 
    <select id="showStudent1" resultType="com.shy.pojo.Student">
        SELECT *
        FROM student

    </select>

long int map 怎么表示

<select id="selectByPrimaryKey" resultMap="BaseResultMap" 
parameterType="java.lang.Long" > 

<select id="queryCarMakerList" resultMap="BaseResultMap" 
parameterType="java.util.Map">  

<delete id="deleteStudent1" parameterType="int">
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值