Ajax异步提交

<form action="" method="get">
客户:<input type="text" id="customerId" name="customerId" οnchange="getCustomerinfo();"/>
订单:<select id="ordersNumber" name="ordersNumber">
</select>
<input type="submit" value="查询"/>
</form>

<script language="javascript" type="text/javascript">
var ajaxRequest;
try {
ajaxRequest = new XMLHttpRequest();
}catch(e) {
try {
ajaxRequest = new ActiveXObject("Msxml2.xmlhttp");
}catch(e){
ajaxRequest = new ActiveXObject("Microsoft.XMLHTTP");
}
}
function getCustomerinfo(){
var customerId = document.getElementById("customerId").value;
var url = "selectCustomerInfo?customerId=" + escape(customerId);
ajaxRequest.onreadystatechange = updateSelect;
ajaxRequest.open("GET",url,true);
ajaxRequest.send(null);
}
function updateSelect(){
if(ajaxRequest.readyState == 4) {
if(ajaxRequest.status == 200) {
var ordersNumber = ajaxRequest.responseText.split('|');
var c = document.getElementById("ordersNumber");
c.length=0;
for(var i=0;i<ordersNumber.length-1;i++) {
var opt = document.createElement('option');
opt.value = ordersNumber[i];
opt.innerText = ordersNumber[i];
c.appendChild(opt);
}
}
}
}
</script>
以下是请求所对应的类文件:
public void init() throws ServletException {
try {
Class.forName("com.mysql.jdbc.Driver");
}catch(Exception e) {
e.printStackTrace();
System.out.println("数据库加载失败!");
}
}
public void doGet(HttpServletRequest req,HttpServletResponse resp) throws ServletException,IOException {
resp.setContentType("text/html;charset=UTF-8");
PrintWriter out = resp.getWriter();
String customerId = req.getParameter("customerId");
Connection conn = null;
PreparedStatement pstmt = null;
try {
String url = "jdbc:mysql://localhost:3306/transactiontest";
conn = DriverManager.getConnection(url,"root","123456");
String sql = "select ORDER_NUMBER from orders where CUSTOMER_ID = ?";
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, customerId);
ResultSet rs = pstmt.executeQuery();
ResultSetMetaData rsmd = rs.getMetaData();
int iCount = rsmd.getColumnCount();
while(rs.next()) {
for(int i=1;i<=iCount;i++) {
out.println(rs.getString(i) + "|");
}
}
out.close();
}catch(Exception e){
e.printStackTrace();
}
}
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值