Example code for implementing classification query function using JSP+ajax-JS Tutorial-php.cn

Home

Web Front-end

JS Tutorial

Example code for implementing classification query function using JSP+ajax

韦小宝

Jan 18, 2018 am 09:54 AM

javascriptQuery function

This article mainly introduces the example code of using JSP+ajax to implement the classification query function. It has certain reference and learning value for JSP. Those who are interested in JSP can learn about this article

This time It is to record and share some problems and solutions encountered in the design of information management system courses for college graduates in the primary semester.

Title requirements: Provide query function for enterprise recruitment information (this year or previous years);

First create a jsp file to display database information, and add a text box for input conditions on it And query button, a js function needs to be completed in this jsp file to complete the query function.

<%@ page language="java" pageEncoding="UTF-8"%>
<%@ page import="java.util.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="TestSQL.SelectDB"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>企业招聘信息</title>
<style>
body {
  width: 600px;
  margin: 40px auto;
  font-family: &#39;trebuchet MS&#39;, &#39;Lucida sans&#39;, Arial;
  font-size: 14px;
  color: #444;
}

table {
  *border-collapse: collapse; /* IE7 and lower */
  border-spacing: 0;
  width: 100%;
}

/*----------------------*/
.zebra td,.zebra th {
  padding: 10px;
  border-bottom: 1px solid #f2f2f2;
}

.zebra tbody tr:nth-child(even) {
  background: #f5f5f5;
  -webkit-box-shadow: 0 1px 0 rgba(255, 255, 255, .8) inset;
  -moz-box-shadow: 0 1px 0 rgba(255, 255, 255, .8) inset;
  box-shadow: 0 1px 0 rgba(255, 255, 255, .8) inset;
}

.zebra th {
  text-align: left;
  text-shadow: 0 1px 0 rgba(255, 255, 255, .5);
  border-bottom: 1px solid #ccc;
  background-color: #eee;
  background-image: -webkit-gradient(linear, left top, left bottom, from(#f5f5f5),
    to(#eee));
  background-image: -webkit-linear-gradient(top, #f5f5f5, #eee);
  background-image: -moz-linear-gradient(top, #f5f5f5, #eee);
  background-image: -ms-linear-gradient(top, #f5f5f5, #eee);
  background-image: -o-linear-gradient(top, #f5f5f5, #eee);
  background-image: linear-gradient(top, #f5f5f5, #eee);
}

.zebra th:first-child {
  -moz-border-radius: 6px 0 0 0;
  -webkit-border-radius: 6px 0 0 0;
  border-radius: 6px 0 0 0;
}

.zebra th:last-child {
  -moz-border-radius: 0 6px 0 0;
  -webkit-border-radius: 0 6px 0 0;
  border-radius: 0 6px 0 0;
}

.zebra th:only-child {
  -moz-border-radius: 6px 6px 0 0;
  -webkit-border-radius: 6px 6px 0 0;
  border-radius: 6px 6px 0 0;
}

.zebra tfoot td {
  border-bottom: 0;
  border-top: 1px solid #fff;
  background-color: #f1f1f1;
}

.zebra tfoot td:first-child {
  -moz-border-radius: 0 0 0 6px;
  -webkit-border-radius: 0 0 0 6px;
  border-radius: 0 0 0 6px;
}

.zebra tfoot td:last-child {
  -moz-border-radius: 0 0 6px 0;
  -webkit-border-radius: 0 0 6px 0;
  border-radius: 0 0 6px 0;
}

.zebra tfoot td:only-child {
  -moz-border-radius: 0 0 6px 6px;
  -webkit-border-radius: 0 0 6px 6px border-radius: 0 0 6px 6px
}
</style>
<!-- 
*
*
*此处为重点
*
*
*
 -->
<script type="text/javascript">
//按年度查询，执行
  var xmlhttp;
  function loadHtml(str) {
    xmlhttp = null;
    if (window.XMLHttpRequest()) {
      xmlhttp = new XMLHttpRequest();
    } else {
      xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
    }
    xmlhttp.onreadystatechange=function()
    {
      if(xmlhttp.readyState==4&&xmlhttp.status==200)
      {
        document.getElementById("zpxx").innerHTML=xmlhttp.responseText;
      }
    }
    xmlhttp.open("GET", "EEIMSelect.jsp?str="+str, true);
    xmlhttp.send();
  }
</script>
<!-- 
*
*
*此处为重点
*
*
*
 -->
</head>
<body>

  <p align="right">
    <input type="text" name="year" id="year">
    <input type="button" value="按年度查询" onclick="loadHtml(document.getElementById(&#39;year&#39;).value)">
  </p>
  <p id="zpxx">
  <%
  request.setCharacterEncoding("utf-8");
    SelectDB sd = new SelectDB();
    String sql = "SELECT * FROM [EIMS].[dbo].[EEIM]";
    ResultSet rs = sd.query(sql);
    out.println("<table class=&#39;zebra&#39;>");
    out.println("<tr><td>公司名字</td><td>招聘岗位</td><td>招聘人数</td><td>工作地点</td><td>要求</td><td>工资</td><td>电话</td><td>日期</td></tr>");
    while (rs.next()) {
      int Eid = Integer.parseInt(rs.getString("Eid"));
      out.println("<tr>");
      out.println("<td>" + rs.getString("Ename") + "</td>");
      out.println("<td>" + rs.getString("Jvac") + "</td>");
      out.println("<td>" + rs.getString("Num") + "</td>");
      out.println("<td>" + rs.getString("Workplace") + "</td>");
      out.println("<td>" + rs.getString("Requirement") + "</td>");
      out.println("<td>" + rs.getString("Salary") + "</td>");
      out.println("<td>" + rs.getString("Tel") + "</td>");
      out.println("<td>" + rs.getString("Year") + "</td>");
      out.println("<td><a href=&#39;EEI_show.jsp?Eid=" + Eid
          + "&#39;>了解更多</a></td>");
    }
    out.println("</table>");
  %>
  </p>
</body>
</html>
    out.println("</table>");
  %>
  </p>
</body>
</html>

The running interface is as follows:

Example code for implementing classification query function using JSP+ajax

Then process the request on another interface and use ajax technology to achieve synchronous refresh. The code is as follows:

<%@ page language="java" pageEncoding="UTF-8"%>
<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="TestSQL.SelectDB" %>
<html>
 <head>
 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  <title>企业招聘信息</title>
  <style>

body {
  width: 600px;
  margin: 40px auto;
  font-family: &#39;trebuchet MS&#39;, &#39;Lucida sans&#39;, Arial;
  font-size: 14px;
  color: #444;
}

table {
  *border-collapse: collapse; /* IE7 and lower */
  border-spacing: 0;
  width: 100%;  
}


/*----------------------*/

.zebra td, .zebra th {
  padding: 10px;
  border-bottom: 1px solid #f2f2f2;  
}

.zebra tbody tr:nth-child(even) {
  background: #f5f5f5;
  -webkit-box-shadow: 0 1px 0 rgba(255,255,255,.8) inset; 
  -moz-box-shadow:0 1px 0 rgba(255,255,255,.8) inset; 
  box-shadow: 0 1px 0 rgba(255,255,255,.8) inset;    
}

.zebra th {
  text-align: left;
  text-shadow: 0 1px 0 rgba(255,255,255,.5); 
  border-bottom: 1px solid #ccc;
  background-color: #eee;
  background-image: -webkit-gradient(linear, left top, left bottom, from(#f5f5f5), to(#eee));
  background-image: -webkit-linear-gradient(top, #f5f5f5, #eee);
  background-image:  -moz-linear-gradient(top, #f5f5f5, #eee);
  background-image:   -ms-linear-gradient(top, #f5f5f5, #eee);
  background-image:   -o-linear-gradient(top, #f5f5f5, #eee); 
  background-image:     linear-gradient(top, #f5f5f5, #eee);
}

.zebra th:first-child {
  -moz-border-radius: 6px 0 0 0;
  -webkit-border-radius: 6px 0 0 0;
  border-radius: 6px 0 0 0; 
}

.zebra th:last-child {
  -moz-border-radius: 0 6px 0 0;
  -webkit-border-radius: 0 6px 0 0;
  border-radius: 0 6px 0 0;
}

.zebra th:only-child{
  -moz-border-radius: 6px 6px 0 0;
  -webkit-border-radius: 6px 6px 0 0;
  border-radius: 6px 6px 0 0;
}

.zebra tfoot td {
  border-bottom: 0;
  border-top: 1px solid #fff;
  background-color: #f1f1f1; 
}

.zebra tfoot td:first-child {
  -moz-border-radius: 0 0 0 6px;
  -webkit-border-radius: 0 0 0 6px;
  border-radius: 0 0 0 6px;
}

.zebra tfoot td:last-child {
  -moz-border-radius: 0 0 6px 0;
  -webkit-border-radius: 0 0 6px 0;
  border-radius: 0 0 6px 0;
}

.zebra tfoot td:only-child{
  -moz-border-radius: 0 0 6px 6px;
  -webkit-border-radius: 0 0 6px 6px
  border-radius: 0 0 6px 6px
}

</style>
 </head>
 <body>
  <%
     request.setCharacterEncoding("utf-8");
    String str=request.getParameter("str");

    SelectDB sd = new SelectDB();
    String sql = "SELECT * FROM [EIMS].[dbo].[EEIM] where Year like &#39;"+str+"%&#39;";
    ResultSet rs = sd.query(sql);
    out.println("<table class=&#39;zebra&#39;>");
    out.println("<tr><td>公司名字</td><td>招聘岗位</td><td>招聘人数</td><td>工作地点</td><td>要求</td><td>工资</td><td>电话</td><td>日期</td></tr>");
    while (rs.next()) {
    int Eid=Integer.parseInt(rs.getString("Eid"));
      out.println("<tr>");
      out.println("<td>" + rs.getString("Ename") + "</td>");
      out.println("<td>" + rs.getString("Jvac") + "</td>");
      out.println("<td>" + rs.getString("Num") + "</td>");
      out.println("<td>" + rs.getString("Workplace") + "</td>");
      out.println("<td>" + rs.getString("Requirement") + "</td>");
      out.println("<td>" + rs.getString("Salary") + "</td>");
      out.println("<td>" + rs.getString("Tel") + "</td>");
      out.println("<td>" + rs.getString("Year") + "</td>");
      out.println("<td><a href=&#39;EEI_show.jsp?Eid=" + Eid
          + "&#39;>了解更多</a></td>");
    }
    out.println("</table>");
  %>  
 </body>
</html>

Achievement effect:

Example code for implementing classification query function using JSP+ajax

The above is the entire content of this article, I hope it will be helpful to everyone’s study! !

Related recommendations:

How to build a JSP development environment

Transmitting and receiving values of url in jsp

How to create dynamic pages--using JSP and Java code

The above is the detailed content of Example code for implementing classification query function using JSP+ajax. For more information, please follow other related articles on the PHP Chinese website!

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

JavaScript Frameworks: Powering Modern Web DevelopmentMay 02, 2025 am 12:04 AM

The power of the JavaScript framework lies in simplifying development, improving user experience and application performance. When choosing a framework, consider: 1. Project size and complexity, 2. Team experience, 3. Ecosystem and community support.

The Relationship Between JavaScript, C , and BrowsersMay 01, 2025 am 12:06 AM

Introduction I know you may find it strange, what exactly does JavaScript, C and browser have to do? They seem to be unrelated, but in fact, they play a very important role in modern web development. Today we will discuss the close connection between these three. Through this article, you will learn how JavaScript runs in the browser, the role of C in the browser engine, and how they work together to drive rendering and interaction of web pages. We all know the relationship between JavaScript and browser. JavaScript is the core language of front-end development. It runs directly in the browser, making web pages vivid and interesting. Have you ever wondered why JavaScr

Node.js Streams with TypeScriptApr 30, 2025 am 08:22 AM

Node.js excels at efficient I/O, largely thanks to streams. Streams process data incrementally, avoiding memory overload—ideal for large files, network tasks, and real-time applications. Combining streams with TypeScript's type safety creates a powe

Python vs. JavaScript: Performance and Efficiency ConsiderationsApr 30, 2025 am 12:08 AM

The differences in performance and efficiency between Python and JavaScript are mainly reflected in: 1) As an interpreted language, Python runs slowly but has high development efficiency and is suitable for rapid prototype development; 2) JavaScript is limited to single thread in the browser, but multi-threading and asynchronous I/O can be used to improve performance in Node.js, and both have advantages in actual projects.

The Origins of JavaScript: Exploring Its Implementation LanguageApr 29, 2025 am 12:51 AM

JavaScript originated in 1995 and was created by Brandon Ike, and realized the language into C. 1.C language provides high performance and system-level programming capabilities for JavaScript. 2. JavaScript's memory management and performance optimization rely on C language. 3. The cross-platform feature of C language helps JavaScript run efficiently on different operating systems.

Behind the Scenes: What Language Powers JavaScript?Apr 28, 2025 am 12:01 AM

JavaScript runs in browsers and Node.js environments and relies on the JavaScript engine to parse and execute code. 1) Generate abstract syntax tree (AST) in the parsing stage; 2) convert AST into bytecode or machine code in the compilation stage; 3) execute the compiled code in the execution stage.

The Future of Python and JavaScript: Trends and PredictionsApr 27, 2025 am 12:21 AM

The future trends of Python and JavaScript include: 1. Python will consolidate its position in the fields of scientific computing and AI, 2. JavaScript will promote the development of web technology, 3. Cross-platform development will become a hot topic, and 4. Performance optimization will be the focus. Both will continue to expand application scenarios in their respective fields and make more breakthroughs in performance.

Python vs. JavaScript: Development Environments and ToolsApr 26, 2025 am 12:09 AM

Both Python and JavaScript's choices in development environments are important. 1) Python's development environment includes PyCharm, JupyterNotebook and Anaconda, which are suitable for data science and rapid prototyping. 2) The development environment of JavaScript includes Node.js, VSCode and Webpack, which are suitable for front-end and back-end development. Choosing the right tools according to project needs can improve development efficiency and project success rate.

See all articles

Hot AI Tools

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress images for free

Clothoff.io

AI clothes remover

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

What's New in Windows 11 KB5054979 & How to Fix Update Issues

4 weeks agoByDDD

How to fix KB5055523 fails to install in Windows 11?

3 weeks agoByDDD

InZoi: How To Apply To School And University

1 months agoByDDD

How to fix KB5055518 fails to install in Windows 10?

3 weeks agoByDDD

Where to find the Site Office Key in Atomfall

1 months agoByDDD

Hot Tools

SecLists

SecLists is the ultimate security tester's companion. It is a collection of various types of lists that are frequently used during security assessments, all in one place. SecLists helps make security testing more efficient and productive by conveniently providing all the lists a security tester might need. List types include usernames, passwords, URLs, fuzzing payloads, sensitive data patterns, web shells, and more. The tester can simply pull this repository onto a new test machine and he will have access to every type of list he needs.