📄 captial_statistic.jsp

📁 C++源代码

💻 JSP

字号:

<%@ page contentType="text/html; charset=gb2312" %>
<%@ page language="java" import="java.sql.*"%>
<%@ page import="java.util.Date,java.text.SimpleDateFormat" %>
<html>


<style TYPE="text/css">

<!--
body {font-size:10pt;color:#415161}
td {font-size:10pt;color:#415161}
th {font-size:10pt;color:#415161}
</style>

<jsp:useBean id="j" scope="application" class="jdbc.jdbc"/>

<%
SimpleDateFormat df=new SimpleDateFormat("yyyy");
String date=df.format(new Date());
%>
  
<table width="100%" border="1" cellspacing="0" bordercolor="#CCCCFF">
  <tr bgcolor="#CCCCFF"> 
    <td width="47%"><div align="center"><strong>企业名称</strong></div></td>
    <td width="14%"><div align="center"><strong>注册资金</strong></div></td>
    <td width="14%"><div align="center"><strong>投资总额</strong></div></td>
    <td width="25%"><div align="center"><strong>企业地址</strong></div></td>
  </tr>
  <%


String captial=new String(request.getParameter("captial").getBytes("ISO8859_1"), "GBK");
String compare=new String(request.getParameter("compare").getBytes("ISO8859_1"), "GBK");

String co;

if(compare.equals("more"))
{co=">=";}
else
{co="<=";}

try{
Connection con=j.getConnection();

Statement statement=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);

String sql="select * from enterprise_info  where capital "+co+" '"+captial+"' and year_time='"+date+"'";


ResultSet r=statement.executeQuery(sql);
if(!r.first())
response.sendRedirect("../nomessage.htm");

r.beforeFirst();
while(r.next())
{
%>
  <tr> 
    <td><%=r.getString(1)%></td>
    <td><%=r.getString(3)%></td>
    <td><%=r.getString(8)%></td>
    <td><%=r.getString(4)%></td>
  </tr>
  <%
}
}catch(SQLException ee){out.print("数据库连接失败！");}
%>
</table>

</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -