JAVA---ajaxとデータベース接続で添削してdemoを調べる

フロント:

     ：
     ：
     ：  
    
      : 
       ：
      	A 
      	B 
      	C 
      	D 
          
      
      
      
      
      

         id ：
                     ：  
          

           id  
      


	
     function insert_1(){
    	 var name =$("#input_name").val();
    	 var classname =$("#input_class").val();
    	 var sex =$('input[name ="sex"]:checked').val();
    	 var major =$("#input_name").val();
    	 var store =$("#select_grade option:selected").val();
    	 var data ={
    	 	"name":name,
    	 	"classname":classname,
    	 	"sex":sex,
    	 	"major":major,
    	 	"store":store
    	 }
    	  var url ="Test";
    	  $.ajax({
    	  	type:"get",
    	  	url:url,
    	  	async:false,
    	  	cache:false,
    	  	data:data,
    	  	success: function(data,textStaus,jqXHR){
    	  		
    	  	if(data.code == 200){
		        		alert("     ");
		        	}else{
		        		alert(data.message);
		        	}
		        },
		        error:function (XMLHttpRequest, textStatus, errorThrown) {      
		           
		            alert(typeof(errorThrown));
		        }
    	  });
     }
     function select_1(){
    	
    	 var url ="Testselect";
    	 
    	  $.ajax({
      	  	type:"get",
      	  	url:url,
      	 	async:false,
    	  	cache:false,
      	  success: function(data,textStaus,jqXHR){
      		 $("#div_2").html(data);
      	  }
      	  });
    	 
     }
     function update_1(){
    	 var id = $("#update_1").val();
    	 var name = $("#update_2").val();
    	 var url ="Testupdate";
    	 var data = {
    			 "id":id,
    			 "name":name
    	 }
    	 $.ajax(
    			{
    				type:"get",
    				url:url,
    				data:data,
    			 	async:false,
    	    	  	cache:false,
    				success:function(data,textStaus,jqXHR){
    					$("#div_3").html(data);
    					if(data.code==200){
    						alert("1");
    					}
    				},
    				error:function(data,textStaus){
    					if(data.code==999){
    						alert("-1");
    					}
    				}
    			} 
    	 );
    		 
    	 
     }
     function delete_1(){
    	 var id =$("#delete_1").val();
    	 var url ="Testdelete";
    	 var data ={
    			 "id":id
    	 }
    	 $.ajax({
    		 type:"get",
    		 url:url,
    		 data:data,
    		 async:false,
        	 cache:false,
        	 success:function(data){
        		 $("#div_4").html(data);
        		 if(data.code ==200){
        			 alert();
        		 }
        	 },
        	 error:function(data){
        		 if(data.code ==999){
        			 alert();
        		 }
        	 }
    		 
    	 });
    	 
     }
     

バックエンド
挿入:

package com.mysql.util;

import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.mysql.MysqlUtil;

/**
 * Servlet implementation class Test
 */
@WebServlet("/Test")
public class Test extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public Test() {
        super();
        // TODO Auto-generated constructor stub
    }

	/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		//response.getWriter().append("Served at: ").append(request.getContextPath());
		  response.setCharacterEncoding("utf-8");
		  response.setContentType("application/json;charset=utf-8");
		  String name = request.getParameter("name");
		  String classname =request.getParameter("classname");
		  String sex = request.getParameter("sex");
		  String major = request.getParameter("major");
		  String grade = request.getParameter("store");
		  String sql = "insert into student(stuname,class,sex,major,mathstore)values('"+name+"','"+classname+"','"+sex+"','"+major+"','"+grade+"')";
		  System.out.println(sql);
		  int r = MysqlUtil.add(sql);
		  
		  String json ="";
		  if (r ==1) {
			json = "{\"code\":\"200\",\"message\":\"       \"}";

		}else {
			json = "{\"code\":\"999\",\"message\":\"       \"}";
		}
		response.getWriter().write(json);
		
	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		doGet(request, response);
	}

}

削除:

package com.mysql.util;

import java.io.IOException;
import java.util.List;
import java.util.Map;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.mysql.MysqlUtil;

/**
 * Servlet implementation class Testdelete
 */
@WebServlet("/Testdelete")
public class Testdelete extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public Testdelete() {
        super();
        // TODO Auto-generated constructor stub
    }

	/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		//response.getWriter().append("Served at: ").append(request.getContextPath());
	      String id = request.getParameter("id");
	      String sql ="delete from student where id ="+id;
	      System.out.println(sql);
	      int r = MysqlUtil.del(sql);
	      String json ="";
	  	response.setCharacterEncoding("utf-8");
		response.setContentType("text/html;charset=utf-8");
	    String []Param = {"id","stuname","class","sex","major","mathstore","engstore","yuwenstore"};
	    String sqll = "select * from student";
		System.out.println(sqll);
		List

クエリー:

package com.mysql.util;

import java.io.IOException;
import java.util.List;
import java.util.Map;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.mysql.MysqlUtil;

/**
 * Servlet implementation class Testselect
 */
@WebServlet("/Testselect")
public class Testselect extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public Testselect() {
        super();
        // TODO Auto-generated constructor stub
    }

	/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		//response.getWriter().append("Served at: ").append(request.getContextPath());
		  response.setCharacterEncoding("utf-8");
		  response.setContentType("text/html;charset=utf-8");
		 
		  String []Param = {"id","stuname","class","sex","major","mathstore","engstore","yuwenstore"};
		  String sql = "select * from student";
		  System.out.println(sql);
		  List

 
変更:

package com.mysql.util;

import java.io.IOException;
import java.util.List;
import java.util.Map;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.mysql.MysqlUtil;

/**
 * Servlet implementation class Testupdate
 */
@WebServlet("/Testupdate")
public class Testupdate extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public Testupdate() {
        super();
        // TODO Auto-generated constructor stub
    }

	/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		//response.getWriter().append("Served at: ").append(request.getContextPath());
	     String id = request.getParameter("id");
	     String name = request.getParameter("name");
	     String sql ="update student set stuname ='"+name+"'where id ="+id;
	     System.out.println(sql);
	     int r = MysqlUtil.update(sql);
		  String json ="";
		 if (r ==1) {
			json = "{\"code\":\"200\",\"message\":\"       \"}";

		}else {
			json = "{\"code\":\"999\",\"message\":\"       \"}";
		}
		response.setCharacterEncoding("utf-8");
		response.setContentType("text/html;charset=utf-8");
		 
		  String []Param = {"id","stuname","class","sex","major","mathstore","engstore","yuwenstore"};
		  String sqll = "select * from student where id ="+id;
		  System.out.println(sqll);
		  List