用jsp和servlet实现增删改查
最终实现的效果如下(并没有加上css修饰,就实现最简单功能)
先要事先新建一个jsp文件,和4个servler文件,4个是调用ajax方法给予回调函数,一个是sql方法函数我命名为SqlConnection
jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
<script type="text/javascript">
function checkUsername(increase) {
createRequest("Mysql?increase=" + increase.value);
}
function checkUsername2(strikeout) {
createRequest("Mysql2?strikeout=" + strikeout.value);
}
function checkUsername3(modify) {
createRequest("Mysql3?modify=" + modify.value);
}
function checkUsername4(inquire) {
createRequest("Mysql4?inquire=" + inquire.value);
}
function createRequest(url) {
http_request = new XMLHttpRequest();
http_request.onreadystatechange = function() {
if (http_request.readyState == 4) {
if (http_request.status == 200) {
//alert("1");
if (http_request.responseText == 1) {
alert("列表中存在此数据");
}
if (http_request.responseText == 2) {
alert("列表中不存在此数据");
}
}
}
};
http_request.open("POST", url, true);
http_request.send(null);
}
</script>
</head>
<body>
<form action="">
<li><input name="increase" type="text" value=""> <input
type="button" class="login-btn" value=