[Ajax] Ajax+Jsp+Mysql 實現資料的存取

最後更新：2018-12-07 來源：互聯網

上載者：User

創建阿里雲帳戶，並獲得超過 40 款產品的免費試用版；而企業帳戶則可以享有總值 $1200 的免費試用版。立即註冊！

課程需要，寫了一個簡單的Ajax資料存取操作，後台用的是Jsp，資料庫是Mysql...

1. Functions.js

代碼

var xmlHttp

/*讀取資料*/
function getUserInfo(uid)
{
  xmlHttp=GetXmlHttpObject();
  if (xmlHttp==null)
  {
    alert ("您的瀏覽器不支援AJAX！");
    return;
  }
  var url="data.jsp";
  url=url+"?uid="+uid;
  xmlHttp.onreadystatechange=stateChanged;
  xmlHttp.open("GET",url,true);
  xmlHttp.send(null);
}
function stateChanged()
{
  if (xmlHttp.readyState==4)
  {
    alert(xmlHttp.responseText);
  }
}

/*儲存資料*/
function saveUserInfo(uid)
{
  xmlHttp=GetXmlHttpObject();
  if (xmlHttp==null)
  {
    alert ("您的瀏覽器不支援AJAX！");
    return;
  }
  var url="savedata.jsp";
  var info="postdate..";
  var postdate="uid="+uid+"&info="+info;
  xmlHttp.onreadystatechange=function()
  {
    if(xmlHttp.readyState == 4 && xmlHttp.status == 200){
      alert("data posted!");
    }
  };
  xmlHttp.open("POST",url,true);
  xmlHttp.setRequestHeader("Content-Type","application/x-www-form-urlencoded");
  xmlHttp.send(postdate);
}

/*建立Request對象*/
function GetXmlHttpObject()
{
  var xmlHttp=null;
  try
  {
    // Firefox, Opera 8.0+, Safari
    xmlHttp=new XMLHttpRequest();
  }
  catch(e)
  {
    // Internet Explorer
    try
    {
      xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
    }
    catch (e)
    {
      xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
    }
  }
  return xmlHttp;
}

2. data.jsp

代碼

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ page import="java.io.*" %>
<%@ page import="mysqlcont.mysql"%>
<%@ page import="java.sql.*"%>
<%!
  public static mysql sql = new mysql();
%>
<%
  String uid = request.getParameter("uid").trim();
  int id = Integer.parseInt(uid);
  sql.select("select info from tablename where id="+id);
  ResultSetMetaData meta = sql.rs.getMetaData();
  while (sql.rs.next()) {
    out.println(sql.rs.getString(1));
  }
%>;

//說明：mysqlcont.mysql類就是另一篇隨筆《Java操作Mysql執行個體》中的類

3. savedata.jsp

代碼

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ page import="java.io.*" %>
<%@ page import="mysqlcont.mysql"%>
<%@ page import="java.sql.*"%>
<%!
  public static mysql sql = new mysql();
%>
<%
  String uid = request.getParameter("uid").trim();
  String info = request.getParameter("info").trim();
  int id = Integer.parseInt(uid);
  sql.update("update tablename set cloname='"+info+"' where id="+id);
  out.println("update succeed!");
%>; //說明：mysqlcont.mysql類就是另一篇隨筆《Java操作Mysql執行個體》中的類

4. main.jsp

End....

本文章原先以中文撰寫並發佈於 aliyun.com，亦設英文版本，僅作資訊用途。本網站不對文章的準確性，完整性或可靠性或其任何翻譯作出任何明示或暗示的陳述或保證。如對該文章有任何疑慮或投訴，請傳送電郵至 info-contact@alibabacloud.com 並提供相關疑慮或投訴的詳細說明。職員會於 5 個工作天內與您聯絡，一經驗證之後，即會刪除該侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

Get Started for Free

Sales Support

1 on 1 presale consultation

Chat Contact Sales
After-Sales Support

24/7 Technical Support 6 Free Tickets per Quarter Faster Response

Open a Ticket
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.

Learn More