软件需求与分析

1今日完成网络审核

2、明日目标多条件查询

 

 

 

 

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
    <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
    
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>

    <!-- Bootstrap -->
    <link
            href="https://cdn.jsdelivr.net/npm/bootstrap@3.3.7/dist/css/bootstrap.min.css"
            rel="stylesheet">
    <script
            src="https://cdn.jsdelivr.net/npm/jquery@1.12.4/dist/jquery.min.js"></script>
    <!-- 加载 Bootstrap 的所有 JavaScript 插件。你也可以根据需要只加载单个插件。 -->
    <script
            src="https://cdn.jsdelivr.net/npm/bootstrap@3.3.7/dist/js/bootstrap.min.js"></script>
</head>
<body>
<div class="container-fluid">
	<div class="row-fluid">
		<div class="span6">
			<div class="row-fluid">
				
				<div class="span4">
					<form class="form-search" action="checkque">
					<table><tr><td><input class="input-medium search-query" type="text" placeholder="机构全称" name="jigoumingcheng"></td>
					<td><input class="input-medium search-query" type="text" placeholder="所在地域"  name="province"></td>
					<td><input class="input-medium search-query" type="text" placeholder="技术需求名称" name="Name"></td>
					<td><input class="input-medium search-query" type="text" placeholder="归口管理单位" name="guikou"></td>
					<td><input class="input-medium search-query" type="text" placeholder="机构属性" name="shuxing"></td>
					<td><input class="input-medium search-query" type="text" placeholder="科技活动类型" name="duoxuan"></td>
					<td><button class="btn" type="submit">查找</button></td></tr></table>
						
					</form>
				</div>
			</div>
		</div>
		
	<div class="row-fluid">
		<div class="span12">
			<table class="table table-bordered table-hover">
				<thead>
					<tr>
						<th>
							编号
						</th>
						<th>
							机构全称
						</th>
						<th>
							技术需求名称
						</th>
						<th>
							所在地域
						</th>
						<th>
							归口管理单位
						</th>
						<th>
							机构属性
							</th>
							<th>
							法人代表
							</th>
							<th>
							拟投入资金金额
							</th>
							<th>
							科技活动类型
						</th>
					</tr>
				</thead>
				<tbody>
  	  <c:forEach var="item" items="${list}" varStatus="i">
					<tr class="info">
						<td>
							<a href="selectid?id=${item.id }">${item.id}</a>
						</td>
						<td>
							${item.jigoumingcheng }
						</td>
						<td>
							${item.name }
						</td>
						<td>
							${item.province }
						</td>
						<td>
							${item.guikou }
						</td>
						<td>
							${item.shuxing }
						</td>
						<td>
							${item.faren }
						</td>
						<td>
							${item.nitouru }
						</td>
						<td>
							${item.duoxuan }
						</td>
					</tr></c:forEach>
				</tbody>
			</table>
		</div>
	</div>
</div>
</body>
</html>

  servlet

package servlet;

import java.io.IOException;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import Bean.Gongwen;
import DBUtil.DBUtil;

/**
 * Servlet implementation class checkque
 */
@WebServlet("/checkque")
public class checkque extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public checkque() {
        super();
        // TODO Auto-generated constructor stub
    }

	/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		String jigou=request.getParameter("jigoumingcheng");
		String province=request.getParameter("province");
		String Name=request.getParameter("Name");
		String guikou=request.getParameter("guikou");
		String shuxing=request.getParameter("shuxing");
		String duoxuan=request.getParameter("duoxuan");
		StringBuilder sql1=new StringBuilder("select * from xvqiu where 1 and 1");
		if(jigou!=null&&!jigou.trim().isEmpty())
		{
			sql1.append(" and jigoumingcheng like '%"+jigou+"%'");
			
		}
		else if(province!=null&&!province.trim().isEmpty())
		{
			sql1.append(" and province like '%"+province+"%'");
			
		}
		else if(Name!=null&&!Name.trim().isEmpty())
		{
			sql1.append(" and Name like '%"+Name+"%'");
			
		}
		else if(guikou!=null&&!guikou.trim().isEmpty())
		{
			sql1.append(" and guikou like '%"+guikou+"%'");
			
		}
		else if(shuxing!=null&&!shuxing.trim().isEmpty())
		{
			sql1.append(" and shuxing like '%"+shuxing+"%'");
			
		}
		else if(duoxuan!=null&&!duoxuan.trim().isEmpty())
		{
			sql1.append(" and duoxuan like '%"+duoxuan+"%'");
			
		}
		String sql=sql1.toString();
		System.out.println(sql);
		List<Gongwen>list=new ArrayList<Gongwen>();

		Connection conn = DBUtil.getConn();
		Statement state = null;
		ResultSet rs = null;
		boolean flag=false;
		Gongwen gongwen=null;
		try {
			state = conn.createStatement();
			rs = state.executeQuery(sql);
			//要用statement类的executeQuery()方法来下达select指令以查询数据库,
			//executeQuery()方法会把数据库响应的查询结果存放在ResultSet类对象中供我们使用。

			while (rs.next()) {
				int id=rs.getInt("id");
				String jigou1=rs.getString("jigoumingcheng");
				String shuxing1=rs.getString("shuxing");
				String Name1=rs.getString("Name");
				String province1=rs.getString("province");
				String faren=rs.getString("faren");
				String guikou1=rs.getString("guikou");
				String nitouru=rs.getString("nitouru");
				String 	duoxuan1=rs.getString("duoxuan");
			
				 gongwen=new  Gongwen(id,jigou1,guikou1,province1,faren,shuxing1,Name1,nitouru,duoxuan1);
				 list.add(gongwen);
				 
				 
				 
				 
				
				flag = true;
			}
		}
		catch (SQLException e) {
			e.printStackTrace();
		} finally {
			DBUtil.close(rs, state, conn);
		}
		request.setAttribute("list",list);
		request.getRequestDispatcher("templete/wlsh.jsp").forward(request, response);
	
	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		doGet(request, response);
	}

}

  

posted @ 2020-10-22 21:52  恶霸xx  阅读(107)  评论(0编辑  收藏  举报