java ajax增删改查_JAVA---用ajax 和数据库连接进行增删改查demo

前台：

mysql

姓名：

班级：

性别：男女

专业:

成绩 ：

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> rr = MysqlUtil.show(sqll,Param);

for (int i = 0; i

response.getWriter().write("

学号"+rr.get(i).get("id")+"

");

response.getWriter().write("

姓名"+rr.get(i).get("stuname")+"

");

response.getWriter().write("

班级"+rr.get(i).get("class")+"

");

response.getWriter().write("

性别"+rr.get(i).get("sex")+"

");

response.getWriter().write("

专业"+rr.get(i).get("major")+"

");

response.getWriter().write("

数学成绩"+rr.get(i).get("mathstore")+"

");

response.getWriter().write("

英语成绩"+rr.get(i).get("engstore")+"

");

response.getWriter().write("

语文成绩"+rr.get(i).get("yuwenstore")+"

");

}

}

/**

* @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 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> r = MysqlUtil.show(sql,Param);

for (int i = 0; i

response.getWriter().write("

学号"+r.get(i).get("id")+"

");

response.getWriter().write("

姓名"+r.get(i).get("stuname")+"

");

response.getWriter().write("

班级"+r.get(i).get("class")+"

");

response.getWriter().write("

性别"+r.get(i).get("sex")+"

");

response.getWriter().write("

专业"+r.get(i).get("major")+"

");

response.getWriter().write("

数学成绩"+r.get(i).get("mathstore")+"

");

response.getWriter().write("

英语成绩"+r.get(i).get("engstore")+"

");

response.getWriter().write("

语文成绩"+r.get(i).get("yuwenstore")+"

");

}

//          String json ="";

//          if (r ==1) {

//            json = "{\"code\":\"200\",\"message\":\"成功插入数据库\"}";

//

//        }else {

//            json = "{\"code\":\"999\",\"message\":\"错误插入数据库\"}";

//        }

}

/**

* @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 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> rr = MysqlUtil.show(sqll,Param);

for (int i = 0; i

response.getWriter().write("

学号"+rr.get(i).get("id")+"

");

response.getWriter().write("

姓名"+rr.get(i).get("stuname")+"

");

response.getWriter().write("

班级"+rr.get(i).get("class")+"

");

response.getWriter().write("

性别"+rr.get(i).get("sex")+"

");

response.getWriter().write("

专业"+rr.get(i).get("major")+"

");

response.getWriter().write("

数学成绩"+rr.get(i).get("mathstore")+"

");

response.getWriter().write("

英语成绩"+rr.get(i).get("engstore")+"

");

response.getWriter().write("

语文成绩"+rr.get(i).get("yuwenstore")+"

");

}

}

/**

* @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);

}

}