jsp+ajax+servlet+mysql运行一个简单的ajax小例子

现在的位置: 首页 > 综合 > 正文

RSS

jsp+ajax+servlet+mysql运行一个简单的ajax小例子

2013年02月11日 ⁄ 综合 ⁄ 共 21772字 ⁄ 字号小中大 ⁄ 评论关闭

一数据库脚本文件：（database.sql）

-- 在命令行下进入数据库后用(source D:/database.sql)执行该文件即可

-- 删除已经存在的数据库HRDatabase,如果该数据库存在
DROP DATABASE HRDatabase;

-- 创建数据库 HRDatabase
CREATE DATABASE HRDatabase;

-- 使用数据库 HRDatabase;
USE HRDatabase;

-- 创建表department
CREATE TABLE department(
id varchar(10),
departname varchar(20)
);

-- 创建表 employeeinfo
CREATE TABLE employeeinfo(
empid int(10) PRIMARY KEY,
departname varchar(30),
empname varchar(20),
empgender varchar(10),
birthday date,
idcard varchar(25),
hometown varchar(100),
arrdate date,
leavdate date,
contact varchar(20),
basalory varchar(20),
ps varchar(40)
);

-- 插入数据
INSERT INTO department values('1','生产部门');
INSERT INTO department values('2','销售部门');
INSERT INTO department values('3','人力资源部');
INSERT INTO department values('4','后勤部');
INSERT INTO department values('5','企化部');

-- 插入数据
INSERT INTO employeeinfo values(1,'生产部门','张一','男','1985-1-20','12345678912345','山东省聊城市区一',curdate(),'2010-1-12','15965475462','2000','');
INSERT INTO employeeinfo values(2,'生产部门','张二','女','1970-6-11','14556789123456','山东省聊城市区二','2004-4-12',curdate(),'154965475462','2100','');
INSERT INTO employeeinfo values(3,'生产部门','张三','男','1980-2-11','45454546543456','山东省聊城市区三','2005-6-1','2007-6-1','456456475462','2700','');
INSERT INTO employeeinfo values(4,'生产部门','张四','男','1982-12-11','65456646543456','山东省聊城市区四','2006-6-11','2007-8-1','456456475462','3700','');
INSERT INTO employeeinfo values(5,'销售部门','李一','男','1975-6-1','64565454656565','山东省滨州市区一','2007-11-1','2008-6-5','456456475462','5100','');
INSERT INTO employeeinfo values(6,'销售部门','李二','女','1945-3-15','45684546543655','山东省滨州市区二','1995-6-5','2010-6-25','456456475462','3000','');
INSERT INTO employeeinfo values(7,'销售部门','李三','男','1950-2-14','78454546543875','山东省滨州市区三','2005-9-1','2007-6-21','456456475462','2700','');
INSERT INTO employeeinfo values(8,'销售部门','李四','女','1956-5-21','12454546543487','山东省滨州市区四','2005-5-1','2007-6-1','456456475462','5000','');
INSERT INTO employeeinfo values(9,'销售部门','李五','男','1942-2-11','5454546543456','山东省滨州市区五','2005-5-11','2007-6-5','456456475462','5000','');
INSERT INTO employeeinfo values(10,'销售部门','李六','女','1954-5-15','5644546543465','山东省滨州市区六','2005-7-15','2007-6-14','456456475462','6000','');
INSERT INTO employeeinfo values(11,'人力资源部','马一','男','1985-2-21','56456454546545','山东省日照市区一','2001-3-1',curdate(),'456456475462','4700','');
INSERT INTO employeeinfo values(12,'人力资源部','马二','女','1945-8-19','45645468796','山东省日照市区二','2002-8-1','2007-6-23','456456475462','2000','');
INSERT INTO employeeinfo values(13,'人力资源部','马三','男','1965-2-5','897456541252','山东省日照市区三','2005-9-21','2007-6-25','456456475462','4000','');
INSERT INTO employeeinfo values(14,'后勤部','赵一','男','1962-8-16','8952352223787','山东省济南市区一','2003-2-1','2007-6-24','456456475462','2900','');
INSERT INTO employeeinfo values(15,'后勤部','赵二','女','1952-2-23','23224546543895','山东省济南市区二','2008-6-23','2009-6-4','456456475462','6700','');
INSERT INTO employeeinfo values(16,'后勤部','赵三','男','1982-2-24','144454654874545','山东省济南市区三','2004-1-1','2007-6-2','456456475462','5700','');
INSERT INTO employeeinfo values(17,'后勤部','王一','女','1954-5-11','7845545465423','山东省威海市区一','2005-2-13','2007-6-8','456456475462','5300','');
INSERT INTO employeeinfo values(18,'企化部','王二','女','1956-5-21','4545545465487','山东省威海市区二','2006-9-13','2007-6-8','456456475462','2500','');
INSERT INTO employeeinfo values(19,'企化部','王三','男','1942-11-1','2145545465445','山东省威海市区三','2008-2-1','2006-5-4','456456475462','9400','');
INSERT INTO employeeinfo values(20,'企化部','王四','女','1962-5-1','4345545465454','山东省威海市区四','2005-2-13','2007-6-19','456456475462','8700','');
INSERT INTO employeeinfo values(21,'企化部','王五','男','1950-6-21','3445545465412','山东省威海市区五','2005-9-13','2009-6-05','456456475462','7700','');
INSERT INTO employeeinfo values(22,'企化部','王六','女','1964-9-11','5645545465496','山东省威海市区六','2007-2-3','2008-9-8','456456475462','2700','');

-- 提交数据
COMMIT;

二 JSP文件：

<%@ page language="java" import="java.util.*,java.sql.*" pageEncoding="GB18030"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme() + "://"
+ request.getServerName() + ":" + request.getServerPort()
+ path + "/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<jsp:useBean id="conBean" class="com.xgj.www.ConnectBean" />
<html>
<head>

<title>员工基本信息</title>
  <style type="text/css">

</style>
  <script type="text/javascript" src="scriptOperation.js"></script>
  <script type="text/javascript" src="suppliercascade.js"></script>
  <script type="text/javascript" src="calendar.js"></script>
  <script type="text/javascript" src="CheckInfo.js"></script>
  <script type="text/javascript" src="SendDataToDB.js"></script>
</head>

<form id="form1" onSubmit="return checkInfo();" method="GET" action="">
                                      
   <center>
    <h2>
     员工基本信息查询表
    </h2>
   </center>

<table width="942" border="0" id="detail" align="center">
    <tr>
     <td>
      <input type="title1" value="姓名" size="10"
       style="text-align: center" readonly='true' />
     </td>

三 js文件（放有ajax）:suppliercascade.js

var xmlHttp;
var item;

//实现级联
function doCascade1() {
//enable();
var departmentIndex = document.getElementById("department").selectedIndex;
if (departmentIndex == 0) {
  for (var i = 4; i < 13; i++) {
   document.getElementById("select" + i).options.length = 0;
  }
  //alert(" /u8bf7/u9009/u62e9/u4f9b/u5e94/u5546/uff01 ");
  return;
}
createXMLHttpRequest();
var url = "SendItem?departmentIndex=" + departmentIndex;
xmlHttp.onreadystatechange = handleStateChange;
xmlHttp.open("GET", url, true);
xmlHttp.send(null);
}

//创建XMLHttpRequest对象
var xmlHttp;
function createXMLHttpRequest() {
if (window.ActiveXObject) {
  xmlHttp = new ActiveXObject("Microsoft.XMLHTTP");
} else {
  if (window.XMLHttpRequest) {
   xmlHttp = new XMLHttpRequest();
  }
}
}

//处理服务器响应
function handleStateChange() {
if (xmlHttp.readyState == 4) {
  if (xmlHttp.status == 200) {
//   var Doc = xmlHttp.responseText;
//   item = Doc.split("n");
//   for (var i = 0; i < item.length; i++) {
//    item[i] = item[i].split("*");
//   }
//   createOption();
   alert(xmlHttp.responseText);
   //alert(responseText);
  }
}
}
function createOption() {
for (var i = 4; i < 13; i++) {
  var select = document.getElementById("select" + i);
  while (select.length > 0) {
   select.remove(0);
  }
  var option = document.createElement("option");
  select.insertBefore(option);
  for (var j = 0; j < item.length - 1; j++) {
   var option = document.createElement("option");
   option.innerText = item[j][0];
   select.insertBefore(option);
  }
}
}

四 servlet服务器：SendItem.java

package back.purchaseorder;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
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 com.xgj.www.ConnectBean;

public class SendItem extends HttpServlet {
private static final long serialVersionUID = 1L;

// override doGet
protected void doGet(HttpServletRequest request,
   HttpServletResponse response) throws ServletException, IOException {
  response.setHeader("Cache-Control", "no-cache");
  response.setHeader("pragma", "no-cache");
  response.setContentType("text/xml");
  PrintWriter out = response.getWriter();
  processRequest(request, response, out);
}

// override doPost
protected void doPost(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
this.doGet(request, response);
}

private void processRequest(HttpServletRequest request,
   HttpServletResponse response, PrintWriter out) {
  String departmentIndex = request.getParameter("departmentIndex");
  switch (Integer.parseInt(departmentIndex)) {
  case 1:
   processCase("SELECT * FROM employeeinfo WHERE departname = '生产部门'",
     out);
   break;
  case 2:
   processCase("SELECT * FROM employeeinfo WHERE departname = '销售部门'",
     out);
   break;
  case 3:
   processCase(
     "SELECT * FROM employeeinfo WHERE departname = '人力资源部'",
     out);
   break;
  case 4:
   processCase("SELECT * FROM employeeinfo WHERE departname = '后勤部'",
     out);
   break;
  case 5:
   processCase("SELECT * FROM employeeinfo WHERE departname = '企化部'",
     out);
   break;
  }
}

private void processCase(String sql, PrintWriter out) {
  ConnectBean conBean = new ConnectBean();
  Connection con = conBean.getConnection();
  PreparedStatement pstmt = conBean.getPStmt(sql, con);
  ResultSet rset = conBean.getResultSet(pstmt);
  try {
   while (rset.next()) {
    out.write(rset.getString("empname") + "*"
      + rset.getInt("empid") + "*"
      + rset.getString("empgender") + "*"
      + rset.getDate("birthday") + "*"
      + rset.getString("idcard") + "*"
      + rset.getString("hometown") + "*"
      + rset.getDate("arrdate") + "*"
      + rset.getDate("leavdate") + "*"
      + rset.getString("contact") + "*"
      + rset.getString("basalory"));
    System.out.println(rset.getString("empname") + "*"
      + rset.getInt("empid") + "*"
      + rset.getString("empgender") + "*"
      + rset.getDate("birthday") + "*"
      + rset.getString("idcard") + "*"
      + rset.getString("hometown") + "*"
      + rset.getDate("arrdate") + "*"
      + rset.getDate("leavdate") + "*"
      + rset.getString("contact") + "*"
      + rset.getString("basalory"));
   }
   out.close();
   conBean.closeStatement(pstmt);
   conBean.closeConnection(con);
  } catch (SQLException e) {
   e.printStackTrace();
  }
}
}

这里边可能有些多余的代码，因为是直接从一个小项目里copy的，不过不影响调试。

【上篇】【转载】乔布斯给中国CEO的三堂课
【下篇】定时器小结 setitimer/getitimer Or timer_settime/timer_gettime

作者: scatter

该日志由 scatter 于11年前发表在综合分类下，最后更新于 2013年02月11日.
转载请注明: jsp+ajax+servlet+mysql运行一个简单的ajax小例子 | 学步园 +复制链接

抱歉!评论已关闭.

学步园

jsp+ajax+servlet+mysql运行一个简单的ajax小例子

作者: scatter

书签

最新文章New

本站推荐

返回首页