令人吃惊,不做任何转码,居然中文能通过:
<%@ page import="java.sql.*"%>
<%
String name = request.getParameter("name").toString();
System.out.println(name);
String data = "";
try {
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/db_cityinfo", "root", "HuaDi5");
Statement st = con.createStatement();
ResultSet rs = st
.executeQuery("select * from tb_type where type_intro='"
+ name + "'");
int count = 0;
while (rs.next()) {
count++;
}
if (count > 0) {
data = "Not Available";
} else {
data = "Available";
}
out.println(data);
System.out.println(data);
} catch (Exception e) {
System.out.println(e);
}
%>
<html>
<head>
<script type="text/javascript">
function check(value) {
xmlHttp = GetXmlHttpObject()
var url = "check.jsp";
url = url + "?name=" + value;
xmlHttp.onreadystatechange = stateChanged
xmlHttp.open("GET", url, true)
xmlHttp.send(null)
}
function stateChanged() {
if (xmlHttp.readyState == 4 || xmlHttp.readyState == "complete") {
var showdata = xmlHttp.responseText;
document.getElementById("mydiv").innerHTML = showdata;
}
}
function GetXmlHttpObject() {
var xmlHttp = null;
try {
xmlHttp = new XMLHttpRequest();
} catch (e) {
try {
xmlHttp = new ActiveXObject("Msxml2.XMLHTTP");
} catch (e) {
xmlHttp = new ActiveXObject("Microsoft.XMLHTTP");
}
}
return xmlHttp;
}
</script>
</head>
<body>
<form name="form">
UserName: <input type="text" name="name" id="name"
οnkeyup="check(this.value);"><font color="red"><div
id="mydiv"></div></font>
</form>
</body>
</html>
本文所用的数据库: http://blog.csdn.net/weiyanghuadi/article/details/8957965
我开始先实验的英文字段,截图如下:
源代码:http://pan.baidu.com/share/link?shareid=463716&uk=3878681452