import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import oracle.jdbc.OracleDriver;
publicclass remai extends HttpServlet {
public remai() {
super();
}
public Connection getConnection() throws SQLException{
Connection conn = null;
DriverManager.registerDriver(new OracleDriver());
String url = "jdbc:oracle:thin:@192.168.5.28:1521:w2046";
String user = "scott";
String password = "tiger";
conn = DriverManager.getConnection(url, user, password);
return conn;
}
public dede selectabc() throws SQLException{
dede dede = null;
PreparedStatement pstmt = getConnection().prepareStatement("select * from dede where bbb=(select max(bbb) from dede)");
ResultSet rs = pstmt.executeQuery();
rs.next();
dede = new dede(rs.getString(1),rs.getString(2));
return dede;
}
publicvoid doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/xml");
response.setHeader("Cache-Control","no-cache");
PrintWriter out = response.getWriter();
out.println("<aa>");
try {
dede wc = selectabc();
out.println("<name>"+wc.getAaa()+"</name>");
out.println("<zhi>"+wc.getBbb()+"</zhi>");
out.println("</aa>");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
package web;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
publicclass zuce extends HttpServlet {
public zuce() {
super();
}
publicvoid doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/xml");
response.setHeader("Cache-Control","no-cache");
PrintWriter out = response.getWriter();
String name=null;
String password=null;
name=request.getParameter("name");
password=request.getParameter("password");
out.println("<aa>");
if(name.equals("abc")&&password.equals("abc")){
out.println("<bb>chenggong</bb>");
}else{
out.println("<bb>buchenggong</bb>"); }
out.println("</aa>");
}
publicvoid doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doGet(request, response);
}
}
AJAX部分网页代码
<head><script language="javascript">
var xmlHttp;
function check(){
var name=document.form.name.value;
var password=document.form.password.value;
if(name=="")
{
alert("cuo!meiyoumingzi");
return false;
}if(password=="")
{
alert("cuo!meiyoupassword");
return false;
}
createXMLHttpRequest(name,password);
}
function processResponse(){
if(xmlHttp.readyState==4){
if(xmlHttp.status==200){
var tt=xmlHttp.responseXML.getElementsByTagName("bb");
var he=tt[0].childNodes[0].nodeValue;
alert(he);
}else{
alert("?????????");
} } }
function createXMLHttpRequest(name,password){
if(window.ActiveXObject){
xmlHttp = new ActiveXObject("Microsoft.XmlHttp");
}else if(window.XmlHttpRequest){
xmlHttp = new XmlHttpRequest();
}
xmlHttp.onreadystatechange = processResponse;
alert(name);
alert(password);
xmlHttp.open("POST","zuce",true);
xmlHttp.setRequestHeader("Content-Type","application/x-www-form-urlencoded");
xmlHttp.send("name="+name+"&password="+password);
}
</script></head><body>
<form name="form" method="post" action="">
<p>
<input type="text" name="name">
</p>
<p> <input type="text" name="password">
</p><p>
<input type="submit" name="Submit" value="¨¬¨¢??" onClick="return check()">
</p></form></body>
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
publicclass list extends HttpServlet {
public list() {
super();
}
publicvoid doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/xml");
response.setHeader("Cache-Control","no-cache");
PrintWriter out = response.getWriter();
String select=request.getParameter("select");
out.println("<aa>");
if(select.equals("IBM")){
out.println("<name>IBM 001</name>");
out.println("<name>IBM 002</name>");
out.println("<name>IBM 003</name>");
}if(select.equals("SONY")){
out.println("<name>SONY 001</name>");
out.println("<name>SONY 002</name>");
out.println("<name>SONY 003</name>");
}if(select.equals("LENOVO")){
out.println("<name>LENOVO 001</name>");
out.println("<name>LENOVO 002</name>");
out.println("<name>LENOVO 003</name>");
}
out.println("</aa>");
}
}