📄 findmessage_op.jsp

📁 一个全面的JSP+Oracle的小型管理系统
💻 JSP
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%
if(session.getValue("ID")==null)
  response.sendRedirect("indexs.jsp");
String url="jdbc:oracle:thin:@10.0.0.4:1521:ORCL";
String user="mms";
String psw="mms123";
String number="";
String number_address="";
String number_type="";
String op_name="";
String op_time="";
int pageLine=20;
int intPageCount=0;
int totalRec=0;
int intPage=1;
int i;
boolean sign=false;
if(request.getParameter("page")!=null)
intPage=Integer.parseInt(request.getParameter("page"));
try{
    Class.forName("oracle.jdbc.driver.OracleDriver");
}
catch(Exception e){
    out.println("没找到数据库驱动！");
	e.printStackTrace();
}	
%>
<script language="javascript" src="image/regcheckdata.js"></script>
<SCRIPT language='JavaScript'>
function check_submit(type)
{
	if(type==1){		
	    document.login_form.action="foundmessage.jsp";
		document.login_form.submit();			
	}
	if(type==2){
		document.login_form.action="modify1.jsp";
		document.login_form.submit();
	}
	if(type==3){
	  	document.login_form.action="add.jsp";
		document.login_form.submit();
	}
	if(type==4){
	    document.login_form.action="delete.jsp";	
		document.login_form.submit();	
	}
}
</script>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>用户登录界面</title>
</head>
<link rel="stylesheet" href="image/cs.css" type="text/css">
<body>
<TABLE style="MARGIN-TOP: 10px" cellSpacing=0 cellPadding=0 width=760 border=0 background="image/jiao_c2.gif" align="center">
  <TR>
    <TD vAlign=top>
      <TABLE style="MARGIN-TOP: 0px" cellSpacing=0 cellPadding=0 width=759 border=0>        
        <TR bgColor=#b4d14e>
          <TD vAlign=top align=left>
		  	<IMG height=28 src="image/jiao_c1.gif" width=11>
		  </TD>
          <TD style="FONT-WEIGHT: bold; FONT-SIZE: 14px; COLOR: #ffffff; LINE-HEIGHT: 24px" width="100%" align="center">手机号段查询系统操作员界面</TD>
          <TD vAlign=top align=right>
		  	<IMG style="FILTER: fliph" height=28 src="image/jiao_c1.gif" width=11>
		  </TD>
	    </TR>	   
      </TABLE>
	  
      <TABLE cellSpacing=0 cellPadding=0 width=760 border=0>        
        <TR>
          <TD width=760 bgColor=#f1fbcd>		  
            <TABLE cellSpacing=0 cellPadding=2 width="90%" border=0>              
              <TR>
                <TD vAlign=bottom height=13></TD>
			  </TR>			 
			</TABLE>			
		  </TD>
	    </TR>		
	   </TABLE>
			
            <TABLE cellSpacing=0 cellPadding=2 width="100%" border=0>
              <FORM name=login_form method=post>              
              <TR>
                <TD width="41%" align=right noWrap class=ygw style="FONT-SIZE: 12px; COLOR: #339900; LINE-HEIGHT: 24px">号 段:</TD>
                <TD width="59%" align="left" vAlign=top>
					<INPUT id=number style="WIDTH: 125px" name="number">
				</TD>
			  </TR>	
			  <tr>
			  <TD colSpan=2 height=30 align="center"> </td>
			  </tr>		               
              <TR>			  
                <TD colSpan=2 height=30 align="center">   
					<input type="button" name="chaxun" value="查  询" onClick="check_submit(1)">
					<input type="button" name="xiugai" value="修  改" onClick="check_submit(2)">
					<input type="button" name="tianjia" value="添  加" onClick="check_submit(3)">
					<input type="button" name="shanchu" value="删  除" onClick="check_submit(4)"> 					 
                </TD>
			  </TR>			  
			  </FORM>
			</TABLE>
			           
            <TABLE cellSpacing=0 cellPadding=0 width=760 border=0>             
             <TR bgColor=#f1fbcd>
              <TD vAlign=bottom align=left height=11>
			  	<IMG height=11 src="image/jiao_c2.gif" width=11>
			  </TD>
              <TD vAlign=bottom align=right>
			  	<IMG style="FILTER: fliph" height=11 src="image/jiao_c2.gif" width=11>
			  </TD>
			 </TR>			
			</TABLE>
			
<table width="760" border="0" cellpadding="0" cellspacing="0">
  <!--DWLayoutTable-->
  <tr> 
    <td width="760" height="59" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
        <!--DWLayoutTable-->

      </table></td>
  </tr>
  <tr> 
    <td height="57" valign="top"><table width="100%"表cellpadding="0" cellspacing="0" border="1"  bgcolor="#FFCCCC">
        <!--DWLayoutTable-->
        <tr> 
          <td width="79" height="34" valign="middle"><strong><font color="#990000">手机号段</font></strong></td>
          <td width="122" valign="middle"> <div align="center"><strong><font color="#990000">归属地</font></strong></div></td>
          <td width="157" valign="middle"> <div align="center"><strong><font color="#990000">号段类型</font></strong></div></td>
          <td width="110" valign="middle"> <div align="center"><strong><font color="#990000">操作员</font></strong></div></td>
          <td width="195" align="center" valign="middle"><font color="#990000"><strong>操作日期</strong></font></td>
		  <td align="center" valign="middle"><font color="#990000"><strong>操作类型</strong></font></td>
        </tr>
<%        
try{		
   	Connection con=DriverManager.getConnection(url,user,psw);
	Statement stm=con.createStatement();
	String sql="select count(*) as cnt from number_info";
 	ResultSet countrs=stm.executeQuery(sql);
	if(countrs.next())
		totalRec=countrs.getInt("cnt");
	countrs.close();
	stm.close();
	intPageCount=(totalRec+pageLine-1)/pageLine;
	stm=con.createStatement();
	String sqlt="select * from number_info";	
	ResultSet rs=stm.executeQuery(sqlt);
	if(intPageCount>0){
		for(i=1;i<=(intPage-1)*pageLine;i++)
    		rs.next();
   	for(i=0;i<pageLine;i++){
		if(rs.next()){	
		 number = rs.getString("number_id");	 	 
		 number_address = rs.getString("number_address");
		 number_address=new String(number_address.getBytes("ISO-8859-1"),"gb2312");	
		 number_type=rs.getString("number_type");
		 number_type=new String(number_type.getBytes("ISO-8859-1"),"gb2312");	
		 op_name=rs.getString("op_name");
		 op_time=rs.getString("op_time");	   
%>
        <tr> 
          <td height="22" valign="middle"><a href="modify1.jsp?number=<%=number%>"><%=number%></a></td>
          <td valign="middle"> <div align="center"><%=number_address%></div></td>
          <td valign="middle"> <div align="center"><%=number_type%></div></td>
          <td valign="middle"><%=op_name%></td>
          <td align="center" valign="middle"><%=op_time%></td>
		  <td width="71" align="center" valign="middle"><a href="delete.jsp?number=<%=number%>">删除</a></td>
        </tr>
        <tr> 
          <td height="2"></td>
          <td></td>
          <td></td>
          <td></td>
          <td></td>
        </tr>
<%    
   		}
   	}
   }rs.close();
    stm.close();
    con.close();
}
catch(SQLException e)
{
	e.printStackTrace(System.out);
}
out.print("<font size='2'>");
out.print("<tr>");
if(intPageCount*pageLine<totalRec)
	intPageCount++;
if(intPage>intPageCount)
	intPage=intPageCount;
if(intPage<1)
	intPage=1;
out.print("<form method='POST' name=pageNum action='findmessage_admin.jsp'>");
out.print("<p align='left'>&gt;&gt;分页&nbsp;");
if(intPage<2)
	out.print("首页 上一页&nbsp;");
else
{
	out.print("<a href='findmessage_admin.jsp?page=1'>首页</a>&nbsp;");
	out.print("<a href='findmessage_admin.jsp?page="+(intPage-1)+"'>上一页</a>&nbsp;");
}
if(intPage-intPageCount>=0)
	out.print("下一页 尾页");
else
{
	out.print("<a href='findmessage_admin.jsp?page="+(intPage+1)+"'>下一页&nbsp;</a>");
	out.print("<a href='findmessage_admin.jsp?page="+intPageCount+"'>尾页</a>");}
	out.print("&nbsp;页次：<strong><font color=red>"+intPage+"</font>/"+intPageCount+"</strong>页");
	out.print("&nbsp;共<b>"+totalRec+"</b>条记录<b>"+pageLine+"</b>条/页");
	out.print("转到第<input type='text' name='page' size=2 maxlength=10 class=smallInput value="+intPage+">");
	out.print("页<input class=buttonface type='submit' value='GO' name='cndok'>");
	out.print("</span></p></form>");
	out.print("</font>");
%>
      </table></td>
  </tr>
</table>
<br><br><br>			
		   <table cellspacing=0 cellpadding=0 width=606 align=center border=0>
            <tr>
             <td align=middle>
              <script language=JavaScript src="image/bottom.js"></script>
             </td>
           </tr>
          </table>				   
		 </TD>
	</TR>	
</TABLE>
</body>
</html>
💿 文件大小 56 K
👤 上传用户 asdzxcliu
📂 所属分类 OA系统
🏷️ 相关标签

#Oracle #JSP #管理系统
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -