9.13每日总结
index.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>河北省重大技术需求征集活动</title>
<style>
* {
margin: 0;
padding: 0;
}
html,body {
height: 100%;
width: 100%;
}
body {
font-family: Arial, sans-serif;
}
.container {
max-width: 800px;
margin: 0 auto;
padding: 20px;
}
h1 {
text-align: center;
color: #333;
}
.banner {
background-image: url('banner.jpg');
background-size: cover;
height: 300px;
}
.banner h2 {
color: #fff;
text-align: center;
padding: 120px 10px;
font-size: 48px;
text-shadow: 2px 2px 4px rgba(0, 0, 0, 0.5);
}
.content {
margin-top: 20px;
}
.content p {
line-height: 1.5;
margin-bottom: 20px;
}
.highlight {
color: #ff6600;
font-weight: bold;
}
.button {
display: inline-block;
padding: 10px 20px;
background-color: #ff6600;
color: #fff;
text-decoration: none;
border-radius: 4px;
transition: background-color 0.3s ease;
}
.button:hover {
background-color: #e55b00;
}
.footer {
margin-top: 50px;
text-align: center;
color: #888;
}
</style>
</head>
<body>
<div class="banner">
<h2>河北省重大技术需求征集活动</h2>
</div>
<div class="container">
<h1>活动简介</h1>
<div class="content">
<p>欢迎参加河北省重大技术需求征集活动。本活动旨在通过广泛征集社会各界的技术需求，推动科技创新与产业发展的结合，促进河北省经济的快速发展。</p>
<p>活动期间，我们将搜集并评估各类重大技术需求，并提供相应的支持和资源。希望各位专家、企业和科研机构能够积极参与，共同推动河北省的科技创新和经济发展。</p>
<p class="highlight">活动时间：2023年10月1日至2023年12月31日</p>
<a href="add.jsp" class="button">信息提交</a>
<a href="search.jsp" class="button">填报查询</a>
<a href="all.jsp" class="button">信息统计</a>
<a href="需求提交页面.html" class="button">提交需求</a>
</div>
</div>
<br><br>
<div class="footer">
<p>© 2023 河北省科技厅. All rights reserved.</p>
</div>
</body>
</html>
add.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>征集页面</title>
<meta name="viewport" content="width=device-width, initial-scale=1" />
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<script>
addEventListener("load", function () { setTimeout(hideURLbar, 0); }, false); function hideURLbar() { window.scrollTo(0, 1); }
</script>
<script src="../../static/admin/js/jquery-1.8.3.js" type="text/javascript"></script>
<link href="../../static/admin/css/font-awesome.min.css" rel="stylesheet">
<link href="../../static/admin/css/bootstrap.min.css" rel="stylesheet">
</head>
<style>
input::-webkit-input-placeholder {
/* placeholder颜色 */
color: #ff0000;
}
#doc{
margin-left: 200px;
margin-right: 200px;
padding-left: 50px;
padding-right: 50px;
padding-top: 0px;
}
td{
font-family: '楷体';
font-weight: bolder;
font-size: 18px;
}
input[type=text]{
width: 100%;
height: 100%;
border: 0;
outline: none;
}
textarea{
width: 100%;
height: 100%;
border: 0;
outline: none;
}
</style>
<body>
<div id="doc">
<h2 align="center">河北省重大技术需求征集表</h2>
<form method="get" action="get.jsp">
<table align="center" border="1px" bordercolor="black" cellspacing="0" cellpadding="10" width="90%">
<tr>
<td>机构全称<span style="color: red">*</span></td>
<td colspan="2"><input type="text" id="jgmc" name="JIGUOQUANCHENG"></td>
<td>归口管理部门</td>
<td colspan="2"><input type="text" id="gkglbm" name="GUIKOUGUANLIBUMEN"></td>
</tr>
<tr>
<td>通讯地址<span style="color: red">*</span></td>
<td colspan="2"><input type="text" id="txdz" name="TONGXUNDIZHI"></td>
<td>所在地域<span style="color: red">*</span></td>
<td colspan="2"><input type="text" id="szdy" name="SUOZAIDIYU"></td>
</tr>
<tr>
<td>网址</td>
<td colspan="2"><input type="text" id="dwwz" name="WANGZHI"></td>
<td>电子邮箱<span style="color: red">*</span></td>
<td colspan="2"><input type="text" style="width: 100%" id="dzyx" name="DIANZIXINXIANG"></td>
</tr>
<tr>
<td>法人代表<span style="color: red">*</span></td>
<td colspan="2"><input type="text" id="frdb" name="FARENDAIBIAO"></td>
<td>邮政编码</td>
<td colspan="2"><input type="text" id="yzbm" name="YOUZHENGBIANMA"></td>
</tr>
<tr >
<td>联系人<span style="color: red">*</span></td>
<td colspan="2"><input type="text" id="lxr" name="LIANXIREN" ></td>
<td>固定电话</td>
<td colspan="2"><input type="text" style="width: 100%" id="gddh" placeholder="固定电话(选填)" name="DIANHUA1"></td>
</tr>
<tr>
<td>移动电话<span style="color: #ff0000">*</span></td>
<td colspan="2"><input type="text" style="width: 100%" id="yddh" placeholder="移动电话" name="DIANHUA2"></td>
<td>传真</td>
<td colspan="2"><input type="text" style="width: 100%;" id="cz" name="CHUANZHEN"></td>
</tr>
<tr>
<td>机构属性<span style="color: red">*</span></td>
<td colspan="5">
<input type="radio" name="JIGOUSHUXING" value="企业" />企业
<input type="radio" name="JIGOUSHUXING" value="高等院校"/>高等院校
<input type="radio" name="JIGOUSHUXING" value="研究机构"/>研究机构
<input type="radio" name="JIGOUSHUXING" value="其他"/>其他
</td>
</tr>
<tr>
<td colspan="6">
<textarea id="jgJIGOUJIANJIEjj" placeholder="机构简介（单位基本情况，研究基础等，限500字）" style="width: 100%;height: 100px;" name=""></textarea>
</td>
</tr>
<tr>
<td>技术需求名称<span style="color: red">*</span></td>
<td colspan="2">
<input id="JISHUXUQIUMINGCHENG" type="text" style="width: 100%;" name="JISHUXUQIUMINGCHENG"/>
</td>
<td>需求年限<span style="color: red">*</span></td>
<td colspan="3">
<input id="qsxqnf" type="text" style="width: 30%;" name="SHIXIAN_KAISHI"/>年 ---
<input id="jzxqnf" type="text" style="width: 30%;" name="SHIXIAN_JIESHU"/>年
</td>
</tr>
<tr>
<tr>
<td rowspan="3">技术需求概述</td>
<td colspan="5" >
<textarea id="zywt" placeholder="主要问题（需要解决的重大技术问题，限500字以内）" style="width: 100%;height: 100px;" name="JISHUXUQIUGAISHU1"></textarea>
</td>
<tr>
<td colspan="5">
<textarea id="jsgj" placeholder="技术关键（所需的关键技术、主要指标，限500字以内）" style="width: 100%;height: 100px;" name="JISHUXUQIUGAISHU2"></textarea>
</td>
</tr>
<tr>
<td colspan="5">
<textarea id="yqmb" placeholder="预期目标（技术创新性、经济社会效益，限500字以内）" style="width: 100%;height: 100px;" name="JISHUXUQIUGAISHU3"></textarea>
</td>
</tr>
</tr>
<tr>
<td>关键词<span style="color: red">*</span></td>
<td colspan="1">
<input style="width: 100%" type="text" name="GUANJIANZI1">
</td>
<td colspan="1">
<input style="width: 100%" type="text" name="GUANJIANZI2">
</td>
<td colspan="1">
<input style="width: 100%" type="text" name="GUANJIANZI3">
</td>
<td colspan="1">
<input style="width: 100%" type="text" name="GUANJIANZI4">
</td>
<td colspan="1">
<input style="width: 100%" type="text" name="GUANJIANZI5">
</td>
</tr>
<tr>
<td>拟投入资金总额<span style="color: red">*</span></td>
<td colspan="5"><input id="ntrjzze" style="width: 80%" type="text" name="NITOURUZIJINZONGE">万元</td>
</tr>
<tr>
<td rowspan="2" colspan="">技术需求解决方式<span style="color: red">*</span></td>
<td colspan="5">
<input name="JISHUXUQIUJIEJUEFANGSHI" type="checkbox" onchange="jsxqhzms()" value="独立研发"/>独立研发
<input name="JISHUXUQIUJIEJUEFANGSHI" type="checkbox" onchange="jsxqhzms()" value="委托研发"/>委托研发
<input name="JISHUXUQIUJIEJUEFANGSHI" type="checkbox" onchange="jsxqhzms()" value="合作开发"/>合作开发
<input name="JISHUXUQIUJIEJUEFANGSHI" type="checkbox" onchange="jsxqhzms()" id="qt" value="其他"/>其他
</td>
</tr>
<tr>
<td colspan="2">合作意向单位(选填)</td>
<td colspan="3">
<input id="hzyxdw" type="text" name="HEZUOYIXIANGDANWEI">
</td>
</tr>
</tr>
<tr>
<td>科技活动类型<span style="color: red">*</span></td>
<td colspan="5">
<input name="KEJIHUODONGLEIXING" type="checkbox" value="基础研究" onchange="yjlx()"/>基础研究
<input name="KEJIHUODONGLEIXING" type="checkbox" value="应用研究" onchange="yjlx()" />应用研究
<input name="KEJIHUODONGLEIXING" type="checkbox" value="试验发展" onchange="yjlx()" />试验发展
<input name="KEJIHUODONGLEIXING" type="checkbox" value="研究与试验发展成果应用" onchange="yjlx()" />研究与试验发展成果应用
<input name="KEJIHUODONGLEIXING" type="checkbox" value="技术推广与科技服务" onchange="yjlx()" />技术推广与科技服务
<input name="KEJIHUODONGLEIXING" type="checkbox" value="生产性活动" onchange="yjlx()" />生产性活动
</td>
</tr>
<tr>
<td>学科分类<span style="color: red">*</span></td>
<td colspan="5">
<input id="xkfl" style="width: 100%;" type="text" placeholder="（参加学科分类，限基础研究填写）" name="XUEKEFENLEI"/>
</td>
</tr>
<tr>
<td>需求技术所属领域（非基础研究填写）<span style="color: red">*</span></td>
<td colspan="5">
<input name="XUQIUJISHUSUOSHULINGYU" type="checkbox" value="电子信息技术" onchange="xqjsssly()" />电子信息技术
<input name="XUQIUJISHUSUOSHULINGYU" type="checkbox" value="光机电一体化" onchange="xqjsssly()" />光机电一体化
<input name="XUQIUJISHUSUOSHULINGYU" type="checkbox" value="软件" onchange="xqjsssly()" />软件
<input name="XUQIUJISHUSUOSHULINGYU" type="checkbox" value="生物制药技术" onchange="xqjsssly()" />生物制药技术
<input name="XUQIUJISHUSUOSHULINGYU" type="checkbox" value="新材料及应用技术" onchange="xqjsssly()" />新材料及应用技术
<input name="XUQIUJISHUSUOSHULINGYU" type="checkbox" value="先进制造技术" onchange="xqjsssly()" />先进制造技术
<input name="XUQIUJISHUSUOSHULINGYU" type="checkbox" value="现代农业技术" onchange="xqjsssly()" />现代农业技术
<input name="XUQIUJISHUSUOSHULINGYU" type="checkbox" value="新能源与高效节能技术" onchange="xqjsssly()" />新能源与高效节能技术
<input name="XUQIUJISHUSUOSHULINGYU" type="checkbox" value="资源与环境保护新技术" onchange="xqjsssly()" />资源与环境保护新技术
<input name="XUQIUJISHUSUOSHULINGYU" type="checkbox" value="其他技术（注明）" id="qtjs" onchange="xqjsssly()" />其他技术（注明）
</td>
</tr>
<tr id="qita"></tr>
<tr>
<td>需求技术应用行业<span style="color: red">*</span></td>
<td colspan="5">
<input id="xqjsyyhy" type="text" placeholder="（参见国民经济行业分类，非基础研究填写）" name="XUQIUJISHUYINGYONGHANGYE"/>
</td>
</tr>
<tr id="qita2"></tr>
<!--<tr>
<td rowspan="2">项目资金需求及来源</td>
<td colspan="2">
计划总投资<span style="color: red">*</span><input id="jhztz" style="width: auto;" type="text" readonly="readonly" />万元
</td>
<td colspan="2">
企业自筹<span style="color: red">*</span><input id="qyzc" style="width: auto;" onchange="qyzc()" type="text" />万元
</td>
</tr>
<tr>
<td colspan="2">
银行贷款<span style="color: red">*</span><input id="yhdk" style="width: auto;" onchange="yhdk()" type="text" />万元
</td>
<td colspan="2">
其它融资<span style="color: red">*</span><input id="qtrz" style="width: auto;" onchange="qtrz()" type="text" />万元
</td>
</tr>-->
</table>
<p style="text-align: center">
<input type="submit" id="btn" class="btn btn-success btn-lg" >
</p>
</form>>
</div>
</body>
</html>
get.jsp
<%@ page import="java.util.ArrayList" %>
<%@ page import="pack.sql_" %>
<%--
Created by IntelliJ IDEA.
User: 绿波亭
Date: 2023/9/15
Time: 10:22
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>Title</title>
</head>
<body>
<%
String JIGUOQUANCHENG = request.getParameter("JIGUOQUANCHENG");
String GUIKOUGUANLIBUMEN = request.getParameter("GUIKOUGUANLIBUMEN");
String TONGXUNDIZHI = request.getParameter("TONGXUNDIZHI");
String SUOZAIDIYU = request.getParameter("SUOZAIDIYU");
String WANGZHI = request.getParameter("WANGZHI");
String DIANZIXINXIANG = request.getParameter("DIANZIXINXIANG");
String FARENDAIBIAO = request.getParameter("FARENDAIBIAO");
String YOUZHENGBIANMA = request.getParameter("YOUZHENGBIANMA");
String LIANXIREN = request.getParameter("LIANXIREN");
String DIANHUA1 = request.getParameter("DIANHUA1");
String DIANHUA2 = request.getParameter("DIANHUA2");
String CHUANZHEN = request.getParameter("CHUANZHEN");
String JIGOUSHUXING = request.getParameter("JIGOUSHUXING");
String JIGOUJIANJIE = request.getParameter("JIGOUJIANJIE");
String JISHUXUQIUMINGCHENG = request.getParameter("JISHUXUQIUMINGCHENG");
String SHIXIAN_KAISHI = request.getParameter("SHIXIAN_KAISHI");
String SHIXIAN_JIESHU = request.getParameter("SHIXIAN_JIESHU");
String JISHUXUQIUGAISHU = request.getParameter("JISHUXUQIUGAISHU1")+"\n"
+request.getParameter("JISHUXUQIUGAISHU2")+"\n"
+request.getParameter("JISHUXUQIUGAISHU3");
String GUANJIANZI = request.getParameter("GUANJIANZI1")+" "+
request.getParameter("GUANJIANZI2")+" "+
request.getParameter("GUANJIANZI3")+" "+
request.getParameter("GUANJIANZI4")+" "+
request.getParameter("GUANJIANZI5");
String NITOURUZIJINZONGE = request.getParameter("NITOURUZIJINZONGE");
String JISHUXUQIUJIEJUEFANGSHI = request.getParameter("JISHUXUQIUJIEJUEFANGSHI");
String HEZUOYIXIANGDANWEI = request.getParameter("HEZUOYIXIANGDANWEI");
String KEJIHUODONGLEIXING = request.getParameter("KEJIHUODONGLEIXING");
String XUEKEFENLEI = request.getParameter("XUEKEFENLEI");
String XUQIUJISHUSUOSHULINGYU = request.getParameter("XUQIUJISHUSUOSHULINGYU");
String XUQIUJISHUYINGYONGHANGYE = request.getParameter("XUQIUJISHUYINGYONGHANGYE");
ArrayList<String> list_=new ArrayList<>();
list_.add(JIGUOQUANCHENG);
list_.add(GUIKOUGUANLIBUMEN);
list_.add(TONGXUNDIZHI);
list_.add(SUOZAIDIYU);
list_.add(WANGZHI);
list_.add(DIANZIXINXIANG);
list_.add(FARENDAIBIAO);
list_.add(YOUZHENGBIANMA);
list_.add(LIANXIREN);
list_.add(DIANHUA1);
list_.add(DIANHUA2);
list_.add(CHUANZHEN);
list_.add(JIGOUSHUXING);
list_.add(JIGOUJIANJIE);
list_.add(JISHUXUQIUMINGCHENG);
list_.add(SHIXIAN_KAISHI);
list_.add(SHIXIAN_JIESHU);
list_.add(JISHUXUQIUGAISHU);
list_.add(GUANJIANZI);
list_.add(NITOURUZIJINZONGE);
list_.add(JISHUXUQIUJIEJUEFANGSHI);
list_.add(HEZUOYIXIANGDANWEI);
list_.add(KEJIHUODONGLEIXING);
list_.add(XUEKEFENLEI);
list_.add(XUQIUJISHUSUOSHULINGYU);
list_.add(XUQIUJISHUYINGYONGHANGYE);
sql_ s=new sql_();
s.insert(list_);
%>
<script>
alert('提交成功')
window.location.href="index.jsp"
</script>
</body>
</html>
search.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="pack.*" %>
<%@ page import="java.util.List" %>
<%@ page import="java.util.ArrayList" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>多条件查询</title>
<style>
body {
font-family: Arial, sans-serif;
margin: 20px;
}
h1 {
text-align: center;
}
form {
margin-bottom: 20px;
}
label {
text-align: right;
display: inline-block;
width: 140px;
}
input[type="text"] {
width: 200px;
padding: 5px;
}
table {
width: 100%;
border-collapse: collapse;
}
th, td {
padding: 10px;
border: 1px solid #ddd;
}
</style>
</head>
<body>
<h1>填报查询</h1>
<%
String a=request.getParameter("a");
String b=request.getParameter("b");
String c=request.getParameter("c");
String d=request.getParameter("d");
sql_ sq=new sql_();
List<Integer> ids = sq.DimQuery2(a,b,c,d);
%>
<form method="get" action="search.jsp">
<label for="institutionName">机构全称：</label>
<input type="text" id="institutionName" name="a">
<label for="location">所在地域：</label>
<input type="text" id="location" name="b">
<label for="techRequirement">技术需求名称：</label>
<input type="text" id="techRequirement" name="c">
<label for="keyword">关键词：</label>
<input type="text" id="keyword" name="d">
<input type="submit">
</form>
<table id="resultsTable">
<tr style="border: aqua">
<th>机构全称</th>
<th>所在地域</th>
<th>技术需求名称</th>
<th>关键词</th>
<th></th>
</tr>
<%for(int i=0;i<ids.size();i++){
ArrayList<String> row=sq.get_what(String.valueOf(ids.get(i)));
%>
<tr>
<td><%out.print(row.get(0));%></td>
<td><%out.print(row.get(3));%></td>
<td><%out.print(row.get(14));%></td>
<td><%out.print(row.get(18));%></td>
<td><a href="what.jsp?id=<%=ids.get(i)%>">详情</a></td>
</tr>
<%}%>
</table>
</body>
</html>
what.jsp
<%@ page import="java.util.ArrayList" %>
<%@ page import="pack.sql_" %>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>征集页面</title>
<meta name="viewport" content="width=device-width, initial-scale=1" />
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<script>
addEventListener("load", function () { setTimeout(hideURLbar, 0); }, false); function hideURLbar() { window.scrollTo(0, 1); }
</script>
<script src="../../static/admin/js/jquery-1.8.3.js" type="text/javascript"></script>
<link href="../../static/admin/css/font-awesome.min.css" rel="stylesheet">
<link href="../../static/admin/css/bootstrap.min.css" rel="stylesheet">
</head>
<style>
input::-webkit-input-placeholder {
/* placeholder颜色 */
color: #ff0000;
}
#doc{
margin-left: 200px;
margin-right: 200px;
padding-left: 50px;
padding-right: 50px;
padding-top: 0px;
}
td{
font-family: '楷体';
font-weight: bolder;
font-size: 18px;
}
input[type=text]{
width: 100%;
height: 100%;
border: 0;
outline: none;
}
textarea{
width: 100%;
height: 100%;
border: 0;
outline: none;
}
</style>
<script>
$(function () {
var username=localStorage.getItem("username");
$.ajax({
url: "../../getuser",
type: "POST",
data: {"username": username},
dataType: "JSON",
async: true,
success: function (data) {
var yzbm=data.yzbm;
var jgqc=data.jgqc;
$("#jgmc").val(jgqc);
$("#yzbm").val(yzbm);
},
error: function (e) {
alert("获取邮编等出现错误！！");
}
});
});
</script>
<body>
<%
String id=request.getParameter("id");
sql_ sq=new sql_();
ArrayList<String> row=sq.get_what(id);
%>
<div id="doc">
<h2 align="center">河北省重大技术需求表</h2>
<form method="get" action="get.jsp">
<table align="center" border="1px" bordercolor="black" cellspacing="0" cellpadding="10" width="90%">
<tr>
<td>机构全称<span style="color: red">*</span></td>
<td colspan="2"><input type="text" id="jgmc"placeholder="<%out.print(row.get(0));%>" readonly></td>
<td>归口管理部门</td>
<td colspan="2"><input type="text" id="gkglbm" placeholder="<%out.print(row.get(1));%>" readonly></td>
</tr>
<tr>
<td>通讯地址<span style="color: red">*</span></td>
<td colspan="2"><input type="text" id="txdz" placeholder="<%out.print(row.get(2));%>" readonly></td>
<td>所在地域<span style="color: red">*</span></td>
<td colspan="2"><input type="text" id="szdy" placeholder="<%out.print(row.get(3));%>" readonly></td>
</tr>
<tr>
<td>网址</td>
<td colspan="2"><input type="text" id="dwwz"placeholder="<%out.print(row.get(4));%>" readonly></td>
<td>电子邮箱<span style="color: red">*</span></td>
<td colspan="2"><input type="text" style="width: 100%" id="dzyx" placeholder="<%out.print(row.get(5));%>" readonly></td>
</tr>
<tr>
<td>法人代表<span style="color: red">*</span></td>
<td colspan="2"><input type="text" id="frdb" placeholder="<%out.print(row.get(6));%>" readonly></td>
<td>邮政编码</td>
<td colspan="2"><input type="text" id="yzbm" placeholder="<%out.print(row.get(7));%>" readonly></td>
</tr>
<tr >
<td>联系人<span style="color: red">*</span></td>
<td colspan="2"><input type="text" id="lxr"placeholder="<%out.print(row.get(8));%>" readonly></td>
<td>固定电话</td>
<td colspan="2"><input type="text" style="width: 100%" id="gddh"placeholder="<%out.print(row.get(9));%>" readonly></td>
</tr>
<tr>
<td>移动电话<span style="color: #ff0000">*</span></td>
<td colspan="2"><input type="text" style="width: 100%" id="yddh" placeholder="<%out.print(row.get(10));%>" readonly></td>
<td>传真</td>
<td colspan="2"><input type="text" style="width: 100%;" id="cz" placeholder="<%out.print(row.get(11));%>" readonly></td>
</tr>
<tr>
<td>机构属性<span style="color: red">*</span></td>
<td colspan="5">
<input type="text" placeholder="<%out.print(row.get(12));%>" readonly/>
</td>
</tr>
<tr>
<td colspan="6">
<textarea id="jgJIGOUJIANJIEjj"
style="width: 100%;height: 100px;" placeholder="<%out.print(row.get(13));%>" readonly></textarea>
</td>
</tr>
<tr>
<td>技术需求名称<span style="color: red">*</span></td>
<td colspan="2">
<input id="JISHUXUQIUMINGCHENG" type="text" style="width: 100%;" placeholder="<%out.print(row.get(14));%>" readonly/>
</td>
<td>需求年限<span style="color: red">*</span></td>
<td >
<input id="qsxqnf" type="text" style="width: 30%;"placeholder="<%out.print(row.get(15));%>" readonly/>年 ---
<input id="jzxqnf" type="text" style="width: 30%;"placeholder="<%out.print(row.get(16));%>" readonly/>年
</td>
</tr>
<tr>
<tr>
<td>技术需求概述</td>
<td colspan="4">
<textarea id="zywt" style="width: 100%;height: 100px;" placeholder="<%out.print(row.get(17));%>" readonly></textarea>
</td>
</tr>
<tr>
<td>关键词<span style="color: red">*</span></td>
<td colspan="4">
<input style="width: 100%" type="text" placeholder="<%out.print(row.get(18));%>" readonly>
</td>
</tr>
<tr>
<td>拟投入资金总额<span style="color: red">*</span></td>
<td colspan="4">
<input id="ntrjzze" style="width: 80%" type="text"placeholder="<%out.print(row.get(19));%>" readonly>万元</td>
</tr>
<tr>
<td>技术需求解决方式<span style="color: red">*</span></td>
<td colspan="4">
<input name="JISHUXUQIUJIEJUEFANGSHI" type="text"placeholder="<%out.print(row.get(20));%>" readonly/>
</td>
</tr>
<tr>
<td >合作意向单位(选填)</td>
<td colspan="4">
<input id="hzyxdw" type="text" placeholder="<%out.print(row.get(21));%>" readonly>
</td>
</tr>
</tr>
<tr>
<td>科技活动类型<span style="color: red">*</span></td>
<td colspan="5">
<input name="KEJIHUODONGLEIXING" type="text" placeholder="<%out.print(row.get(22));%>" readonly/>
</td>
</tr>
<tr>
<td>学科分类<span style="color: red">*</span></td>
<td colspan="5">
<input id="xkfl" style="width: 100%;" type="text" placeholder="<%out.print(row.get(23));%>" readonly/>
</td>
</tr>
<tr>
<td>需求技术所属领域（非基础研究填写）<span style="color: red">*</span></td>
<td colspan="5">
<input name="XUQIUJISHUSUOSHULINGYU" type="text"placeholder="<%out.print(row.get(24));%>" readonly/>
</td>
</tr>
<tr id="qita"></tr>
<tr>
<td>需求技术应用行业<span style="color: red">*</span></td>
<td colspan="5">
<input id="xqjsyyhy" type="text" placeholder="<%out.print(row.get(25));%>" readonly/>
</td>
</tr>
</table>
</form>
</div>
</body>
</html>
all.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>统计页面</title>
<style>
body {
font-family: Arial, sans-serif;
margin: 20px;
}
h1 {
text-align: center;
}
form {
display: flex;
align-items: center;
justify-content: center;
margin-bottom: 20px;
}
label {
margin-right: 10px;
}
table {
width: 100%;
border-collapse: collapse;
}
th, td {
padding: 10px;
border: 1px solid #ddd;
}
</style>
</head>
<body>
<h1>统计页面</h1>
<form method="get" action="all.jsp">
<div>
科技活动类型：
<input type="checkbox" name="activity" />基础研究
<input type="checkbox" name="activity" />应用研究
<input type="checkbox" name="activity" />试验发展
<input type="checkbox" name="activity" />研究与试验发展成果应用
<input type="checkbox" name="activity" />技术推广与科技服务
<input type="checkbox" name="activity" />生产性活动
<input type="submit" value="统计" id = "ID">
<script type="text/javascript">
const btn=document.getElementById("ID");
btn.onclick=function(){
alert('1')
}
</script>
<br>
机构属性：
<input type="checkbox" name="attr" />电子信息
<input type="checkbox" name="attr" />光机电一体化
<input type="checkbox" name="attr" />生物技术与制药
<input type="checkbox" name="attr" />新材料及应用
<input type="checkbox" name="attr" />现代农业
<input type="checkbox" name="attr" />新能源与高效节能
<input type="checkbox" name="attr" />资源与环境
<input type="checkbox" name="attr" />高技术服务业
<input type="checkbox" name="attr" />海洋
<input type="checkbox" name="attr" />社会公共事业
<input type="checkbox" name="attr" />医疗卫生
<input type="checkbox" name="attr" />其他（注明）
</div>
</form>
</table>
</body>
</html>
与hbase连接的Java类
package pack;
import java.sql.Connection;
import java.sql.DriverManager;
public class Con {
public static Connection getConnection() throws Exception {
Class.forName("org.apache.phoenix.jdbc.PhoenixDriver");
String url = "jdbc:phoenix:192.168.88.101:2181";
String user = "hadoop";
String pwd = "123456";
Connection con = DriverManager.getConnection(url, user, pwd);
return con;
}
}
hbase的sql语句方法
package pack;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
public class sql_ {
public void insert(ArrayList<String> list_) throws Exception {
Connection connection = Con.getConnection();
PreparedStatement preparedStatement = null;
String sql = "UPSERT into one(JIGUOQUANCHENG,GUIKOUGUANLIBUMEN,TONGXUNDIZHI,SUOZAIDIYU,WANGZHI,DIANZIXINXIANG,FARENDAIBIAO,YOUZHENGBIANMA,LIANXIREN,DIANHUA1,DIANHUA2,CHUANZHEN,JIGOUSHUXING,JIGOUJIANJIE,JISHUXUQIUMINGCHENG,SHIXIAN_KAISHI,SHIXIAN_JIESHU,JISHUXUQIUGAISHU,GUANJIANZI,NITOURUZIJINZONGE,JISHUXUQIUJIEJUEFANGSHI,HEZUOYIXIANGDANWEI,KEJIHUODONGLEIXING,XUEKEFENLEI,XUQIUJISHUSUOSHULINGYU,XUQIUJISHUYINGYONGHANGYE,ID) values (?,?,?,?,?," +
"?,?,?,?,?," +
"?,?,?,?,?," +
"?,?,?,?,?," +
"?,?,?,?,?,?,?)";
//String sql = "delete from table_name where id=?";
preparedStatement = connection.prepareStatement(sql);
for(int i=0;i<list_.size();i++) {
preparedStatement.setString(i+1, list_.get(i));
}
preparedStatement.setInt(27,this.select_id());
System.out.println(preparedStatement.toString());
preparedStatement.executeUpdate();
connection.commit();
}
private int select_id() throws Exception {
String sql = "SELECT ID FROM one";
Connection connection = Con.getConnection();
Statement statement=connection.createStatement();
ResultSet resultSet=statement.executeQuery(sql);
int i=1;
while(resultSet.next()){
i++;
}
return i;
}
public List<Integer> DimQuery2(String jigouname,String suozai,String jishuxvqiu,String guanjianci) throws Exception
{
List<Integer> id_list=new ArrayList<>();
String sql="SELECT ID FROM one WHERE JIGUOQUANCHENG LIKE ? AND" +
" SUOZAIDIYU LIKE ? AND JISHUXUQIUMINGCHENG like ? AND" +
" GUANJIANZI LIKE ?";
PreparedStatement pre =Con.getConnection().prepareStatement(sql);
pre.setString(1,"%"+jigouname+"%");
pre.setString(2,"%"+suozai+"%");
pre.setString(3,"%"+jishuxvqiu+"%");
pre.setString(4,"%"+guanjianci+"%");
ResultSet rs = pre.executeQuery();
while(rs.next())
{
id_list.add(rs.getInt("ID"));
}
pre.close();
return id_list;
}
public int DimQuery3(String type,ArrayList<String> list_) throws Exception
{
String sql="select "+type+" from one where JIGUOQUANCHENG = ?";
PreparedStatement pre =Con.getConnection().prepareStatement(sql);
pre.setString(1,list_.get(0));
ResultSet rs = pre.executeQuery();
int all=0;
while(rs.next())
{
all++;
}
pre.close();
return all;
}
public ArrayList<String> get_what(String id) throws Exception
{
ArrayList<String> all = new ArrayList<>();
String sql="select * from one where ID = ?";
PreparedStatement pre =Con.getConnection().prepareStatement(sql);
pre.setInt(1, Integer.parseInt(id));
ResultSet rs = pre.executeQuery();
rs.next();
for(int i=0;i<26;i++){
all.add(rs.getString(i+1));
}
return all;
}
}
浙公网安备 33010602011771号