87,910
社区成员
发帖
与我相关
我的任务
分享
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@page import="com.action.search_servlet"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>查询</title>
</head>
<body>
<table>
<form action="/search_servlet">
<input type="text" value="" name="name">
<input type="submit" name="Submit">
</form>
</table>
</body>
package com.action;
import java.io.IOException;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
@WebServlet(name = "search_servlet", urlPatterns={"/com.action/search_servlet"})
public class search_servlet extends HttpServlet{
public static Statement st;
protected void service(HttpServletRequest request, HttpServletResponse response) //
throws ServletException, IOException {
List<Map> list =new ArrayList<Map>();//创建list集合用于存入map的键值对集合
String name = request.getParameter("name");//接收到前台传来的数据
System.out.println(name);
try {
String sql ="SELECT t_yuangong.`name`,t_gongzi.`yuefen`,t_gongzi.`jine`,t_chuqin.tianshu\r\n"+
"FROM t_yuangong\r\n"+
"JOIN t_gongzi ON t_gongzi.yuangong_id=t_yuangong.id\r\n"+
"JOIN t_chuqin ON t_chuqin.yuangong_id=t_gongzi.yuangong_id\r\n"+
"WHERE t_yuangong.name="+name;
//复制之前的sql代码 每行必须要转换为字符串然后加上换行符
// idcard_w是用户传入的数据用于查询用户需要的信息
ResultSet rs = st.executeQuery(sql);
//从数据库读取的内容,返回一个结果集。
System.out.println("获取数据");
while (rs.next()) {
String name1 = rs.getString("name");
String yuefen = rs.getString("yuefen");
String jine = rs.getString("jine");
String tianshu = rs.getString("tianshu");
//获取用循环接收数据库的表格信息
Map map = new HashMap();
map.put("name1", name1);
map.put("yuefen", yuefen);
map.put("jine", jine);
map.put("tianshu", tianshu);
//用键值对存入到map集合中
System.out.println(map);
list.add(map);//在将map集合对象存入list集合
System.out.println("放入集合");
for (Map map_1 :list) {
System.out.println(map_1);
}//在打印台遍历出数据查看是否有错误
}//遍历结果集
} catch (Exception e) {
e.printStackTrace();
}
System.out.println("跳转");
request.setAttribute("key_list",list);//将list集合数据放入到request中共享
request.getRequestDispatcher("admin/search.jsp").forward(request, response);
//跳转到index.jsp页面
}
}