5月24日 CMS 周四-CSDN博客

本文链接：https://blog.csdn.net/helloworld_1996/article/details/80444918

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">

    <title>My JSP 'upd.jsp' starting page</title>

    <meta http-equiv="pragma" content="no-cache">
    <meta http-equiv="cache-control" content="no-cache">
    <meta http-equiv="expires" content="0">    
    <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
    <meta http-equiv="description" content="This is my page">
    <!--
    <link rel="stylesheet" type="text/css" href="styles.css">
    -->

  <script type="text/javascript" src="js/jquery-1.8.2.min.js"></script>
    <script type="text/javascript">
        var id = ${param.id};
        $.ajax({
            url:"list!show",
            type:"post",
            data:{id:id},
            dataType:"json",
            success:function(msg){
                $("#id").val(msg.id);
                $("#name").val(msg.name);
                $("#sex").val(msg.sex);
                $("#age").val(msg.age);
            }
        });

        function upd(){
            var name = $("#name").val();
            var sex = $("#sex").val();
            var age = $("#age").val();
            alert(id+name+sex+age);
            $.ajax({
                url:"list!upd",
                type:"post",
                data:{id:id,name:name,sex:sex,age:age},
                dataType:"text",
                success:function(msg){
                    if(msg>0){
                        location="list.action";
                    }else{
                        alert("修改失败");
                    }
                }
            });
        }
    </script>
  </head>

  <body>
    <input type="hidden" name="id" id="id"><br>
    name:<input name="name" id="name"><br>
    sex:<input name="sex" id="sex"><br>
    age:<input name="age" id="age"><br>
    <input type="button" value="修改" onclick="upd()">
  </body>
</html>

package com.dao;

import java.util.List;

import com.dto.Teacher;
import com.util.JdbcUtils;

public class TeacherDao {

    public List<Teacher> list() {
        // TODO Auto-generated method stub
        String sql = "select * from teacher";
        return JdbcUtils.getList(Teacher.class, sql);
    }

    public int add(int id, String name, String sex, int age) {
        // TODO Auto-generated method stub
        String sql = " insert into teacher values("+id+",'"+name+"','"+sex+"',"+age+") ";
        System.out.println(sql);
        return JdbcUtils.executeSQL(sql);
    }

    public int del(int id) {
        // TODO Auto-generated method stub
        String sql = " delete from teacher where id="+id;
        return JdbcUtils.executeSQL(sql);
    }

    public Teacher show(int id) {
        // TODO Auto-generated method stub
        String sql = " select * from teacher where id= "+id;
        System.out.println(sql);
        return (Teacher) JdbcUtils.getOneObject(Teacher.class,sql);
    }

    public int upd(int id, String name, String sex, int age) {
        // TODO Auto-generated method stub
        String sql = " update teacher set name='"+name+"',sex='"+sex+"',age="+age+" where id="+id;
        System.out.println(sql);
        return JdbcUtils.executeSQL(sql);
    }


}