html ajax 遍历,Ajax数组遍历并显示

一、Conn.jsp

import="java.sql.*, javax.naming.Context,

javax.naming.InitialContext"

errorPage=""%>

Statement stmt = null;

ResultSet rs = null;

public void jspInit() {

try {

//Class.forName("com.mysql.jdbc.Driver");

//建立连接

//conn = DriverManager.getConnection(

// "jdbc:mysql://localhost:3306/SKY5", "root", "123456");

//Context initCtx = new InitialContext();

//Context ctx = (Context) initCtx.lookup("java:comp/env");

//获取连接池对象

//Object obj = (Object) ctx.lookup("jdbc/javasky");

//类型转换

//javax.sql.DataSource ds = (javax.sql.DataSource) obj;

//conn = ds.getConnection();

//stmt = conn.createStatement();

Class.forName("oracle.jdbc.driver.OracleDriver");

conn = DriverManager.getConnection("","","");

stmt = conn.createStatement();

} catch (Exception ex) {

System.out.println(ex.toString());

}

}

public void Exec(String sql) {

jspInit();

try {

stmt.executeUpdate(sql);

} catch (Exception e) {

System.out.print(e.toString());

}

}

public ResultSet getRs(String sql) throws SQLException {

jspInit();

try {

rs = stmt.executeQuery(sql);

return rs;

} catch (Exception e) {

System.out.print(e);

return null;

}

}

public ResultSet executeQuery(String sql) throws Exception

{

jspInit();

try {

sql = new String(sql.getBytes("GBK"), "ISO8859_1");

stmt = conn.createStatement(

java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,

java.sql.ResultSet.CONCUR_READ_ONLY);

rs = stmt.executeQuery(sql);

} catch (SQLException ex) {

System.out.println("sql.executeQuery:" + ex.getMessage());

}

return rs;

}

public String getS(String Str) {

try {

byte b[] = Str.getBytes("ISO-8859-1");

Str = new String(b, "UTF-8");

} catch (Exception ee) {

ee.printStackTrace();

}

return Str;

}%>

二、De1l.jsp

import="java.sql.*,java.util.*" errorPage=""

%>

Connection conn = null;

Statement stmt = null;

ResultSet rs = null;

try{

Class.forName("oracle.jdbc.driver.OracleDriver"); //建立连接

conn =

DriverManager.getConnection("jdbc:oracle:thin:@10.6.184.75:1523:apsisrsv",

"apsisrsv", "apsisrsv");

stmt =

conn.createStatement();

rs=stmt.executeQuery("select *

from ref_cn_airport");

StringBuffer content=new

StringBuffer("");

response.setContentType("text/xml");

response.setHeader("Cache-Control","no-cache");

content.append("<?xml

version=\"1.0\" encoding=\"UTF-8\" ?>");

content.append("");

while(rs!=null&&rs.next()){

content.append("");

content.append(""+rs.getString("ARPT_CHN_NM")+"");

content.append("");

}

content.append("");

out.print(content);

}catch(Exception e){

e.printStackTrace();

}

%>

三、index.jsp

language="java" %>

用户登录页面

var xmlHttp;

var id;

function

trim(str) { var t =

str.replace(/(^\s*)|(\s*$)/g, ""); //

用正则表达式将前后空格 return

t.replace(/(^　*)|(　*$)/g,

""); //

用空字符串替代。 }

function createXMLHttpRequest(){

if(window.ActiveXObject){

xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");

}

else

if(window.XMLHttpRequest){

xmlHttp=new XMLHttpRequest();

}

}

function validate(){

createXMLHttpRequest();

xmlHttp.open("GET","Del1.jsp",true);

xmlHttp.onreadystatechange=callback;

xmlHttp.send(null);

}

function callback(){

if(xmlHttp.readyState==4){

show();

setTimeout("validate()",3600);

}

}

function show(){

var

xmlDoc=xmlHttp.responseXML;

var

yan=xmlDoc.getElementsByTagName_r("content");

var

ta="

for(var i=0;i

var y=yan[i];

var name=y.childNodes[0].firstChild.data;

ta

+="

"+name+"";

}

ta

+="

";

document.getElementByIdx_x("res").innerHTML=ta;

}

function startmarquee(lh,speed,delay) {

validate();

var p=false;

var t;

var o=document.getElementByIdx_x("res");

o.innerHTML+=o.innerHTML;

o.style.marginTop=0;

o.οnmοuseοver=function(){p=true;}

o.οnmοuseοut=function(){p=false;}

function start(){

t=setInterval(scrolling,speed);

if(!p)

o.style.marginTop=parseInt(o.style.marginTop)-1+"px";

}

function scrolling(){

if(parseInt(o.style.marginTop)%lh!=0){

o.style.marginTop=parseInt(o.style.marginTop)-1+"px";

if(Math.abs(parseInt(o.style.marginTop))>=o.scrollHeight/2)

o.style.marginTop=0;

}else{

clearInterval(t);

setTimeout(start,delay);

}

}

setTimeout(start,delay);

}

onLoad="startmarquee(90-18,40,0)">

width=870 align=center bgColor=#ffffff

border=0>

width=860 align=center border=0>

${loginmessage }

name="logform" action="/login.do"

method="post">

   用户名：

style="FONT-WEIGHT: bold; FONT-SIZE: 11px; COLOR: #cc6600;

FONT-FAMILY: Verdana; BACKGROUND-COLOR: #f9f9f9" tabIndex=1 size=13

name="username">

密码：

tabIndex=1 type=password size=13 value=""

name="password">

name=B12 >

name=reset2 >

id="res">