求大神给个 jsp + jquery + ajax +sql 数据库的例子
解决方案 »
- webservice接口返回带"<>"字符的String如何不被转义
- spring 获取上下文的问题
- Java类总是不运行
- Tomcat5.5+MSSQL连接多数据库怎么设计连接池
- struts连接tomcat数据源连接池 代码如何写效率最高?等~~
- j2ee表格显示问题
- Axis做WS开发,如何使用代理?
- 如何实现JSR168
- 第一个struts工程,表单提交后报错:HTTP Status 503 - Servlet action is currently unavailable
- 急!!!小弟明天面试,求助大家!!!
- 请问,java.lang.StackOverflowError怎么个处理,什么原因?
- java接收结构体回调问题
ss_name varchar(100));
servlet
package com.zf.servlet;import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
@SuppressWarnings("serial")
public class SaveAddress extends HttpServlet { private static final String url = "jdbc:mysql://localhost:3306/zftest3";
private static final String username = "root";
private static final String password = "root"; @Override
public void init() throws ServletException {
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
super.init();
} protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String addressName = request.getParameter("addressName");
Connection conn = null;
PreparedStatement ps = null;
try {
conn = DriverManager.getConnection(url, username, password);
ps = conn.prepareStatement("insert into address(address_name) values(?)");
ps.setString(1, addressName);
ps.execute();
} catch (SQLException e) {
e.printStackTrace();
}finally{
try {
ps.close();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
} protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doGet(request, response);
}}web.xml
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" id="WebApp_ID" version="2.5">
<display-name>ajax</display-name>
<welcome-file-list>
<welcome-file>index.html</welcome-file>
<welcome-file>index.htm</welcome-file>
<welcome-file>index.jsp</welcome-file>
<welcome-file>default.html</welcome-file>
<welcome-file>default.htm</welcome-file>
<welcome-file>default.jsp</welcome-file>
</welcome-file-list>
<servlet>
<description></description>
<display-name>SaveAddress</display-name>
<servlet-name>SaveAddress</servlet-name>
<servlet-class>com.zf.servlet.SaveAddress</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>SaveAddress</servlet-name>
<url-pattern>/SaveAddress</url-pattern>
</servlet-mapping>
</web-app>
jsp 页面 <%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Insert title here</title>
<script type="text/javascript" src="jquery-1.7.2.min.js"></script>
<script type="text/javascript">
$(function(){
$("#save").click(function(){
var addressName = $("#addressName").val();
if(addressName == null || addressName.match("^\\s*$")){
alert("名称能为空!");
return ;
}
$.ajax({
url:"SaveAddress" ,
type:"post",
data: "addressName=" + addressName ,
success:function(data){
alert("添加成功!");
},
error:function(){
alert("添加失败!");
}
});
});
});
</script>
</head>
<body>
<div>
<input type="text" name="addressName" id="addressName" />
<br/>
<input type="button" value="保存" id="save"/>
</div>
</body>
</html>
需要的jar包
mysql-connector-java-5.1.18-bin.jar
@RequestMapping(value = "/username_unique.jspx")
public void usernameUnique(HttpServletRequest request,
HttpServletResponse response) {
String username = RequestUtils.getQueryParam(request, "username");
// 用户名为空,返回false。
if (StringUtils.isBlank(username)) {
ResponseUtils.renderJson(response, "false");
return;
}
CmsSite site = CmsUtils.getSite(request);
CmsConfig config = site.getConfig();
// 保留字检查不通过,返回false。
if (!config.getMemberConfig().checkUsernameReserved(username)) {
ResponseUtils.renderJson(response, "false");
return;
}
// 用户名存在,返回false。
if (unifiedUserMng.usernameExist(username)) {
ResponseUtils.renderJson(response, "false");
return;
}
ResponseUtils.renderJson(response, "true");
}
$("#username").rules("add", {required:true,rangelength:[${site.usernameMinLen},20],username:true,remote:'${base}/username_unique.jspx',messages:{remote:'用户名已存在!',required:'[用户名] 必填项!'}});
<input class="add_regi_wh" id="username" name="username" type="text" />