jsp 链接Oracle的连接池和查询跳转代码（带登录）

最新推荐文章于 2021-04-06 21:27:15 发布

ttt015651

最新推荐文章于 2021-04-06 21:27:15 发布

阅读量745

点赞数 1

分类专栏： jsp 文章标签： oracle jsp string border button exception

本文链接：https://blog.csdn.net/ttt015651/article/details/4558165

版权

jsp 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

'-------------------------------------------------------------------以下是登录代码

<%@ page contentType="text/html; charset=gb2312"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>信息查询系统</title>
<style type="text/css">

</style></head>
<body scroll="no">
<table width="1024" border="0" align="center" cellpadding="0" cellspacing="0" background="images/d.jpg" height="473">
<tr>
    <td width="328" height="136"> </td>
    <td width="430"> </td>
    <td width="266"> </td>
</tr>
<tr>
    <td> </td>
    <td valign="top"><table width="100%" border="0" cellspacing="3" cellpadding="0">
   <form name="biaodan" action="cx.jsp" method="post" id="formCard">
     <tr>
    <td height="25" valign="top" colspan="2">  带有<font color="#FF0000">* </font>号为必填项,两项都必须填写</td>
     </tr>
     <tr>
    <td width="32%" height="35" align="right" >编号：</td>
    <td><input type="text" name="aac157" class="text" />
       <font color="#FF0000">* </font></td>
     </tr>
     <tr>
    <td height="35" align="right">姓名：</td>
    <td><input name="name" type="text" class="text" />
       <font color="#FF0000">* </font></td>
     </tr>
     <tr>
    <td height="35" colspan="2" align="center" valign="top"><label>
                 <input type="submit" name="button" id="button" style="background:url(images/tj.gif); border:none; width:84px; height:30px;" value="" onClick="commit();"/>
                 
<input type="reset" name="button" id="button" style="background:url(images/cz.gif); border:none; width:84px; height:30px;" value="" />
        
    </label></td>
     </tr>
     </form>
   </table></td>
    <td> </td>
</tr>
<tr>
    <td> </td>
    <td> </td>
    <td> </td>
</tr>
</table>

</body>
</html>

'-----------------------------------------------------------------------------------------------------以下是cx.jsp

<%@page import="java.sql.*"%>
<%@ page language="java" import="java.util.*" pageEncoding="GB2312"%>
<%
    Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
    String url="jdbc:oracle:thin:@192.168.80.5:1521:admin111";
    String user="admin";
    String password="admin";
    Connection conn= null;
    Statement stmt = null;
    ResultSet rs = null;
    String name=new String(request.getParameter("name").trim().getBytes("ISO-8859-1"),"GB2312");
    String aac157 = request.getParameter("aac157")==null?"":request.getParameter("aac157");
    name = name==null?"":name;
    String number = request.getParameter("number")==null?"":request.getParameter("number");
    String sql="";
    try{
     conn= DriverManager.getConnection(url,user,password);
     stmt=conn.createStatement();
     if(!aac157.trim().equals("")){
        sql=" iscode='"+aac157+"'";//aac157，传值给iscode
     }
     if(!name.trim().equals("")){
        sql=sql+" and psname like '%"+name+"%'";//name，传值给psname
     }
    if(!number.trim().equals("")){
       sql=sql+" and CPCODE='"+number+"'";//number码，传值给CPCODE号
    }
     String countSQL="select * from shan where "+sql ;
     rs = stmt.executeQuery(countSQL);
  String PSSENO="";
        if(rs.next()){
  PSSENO=rs.getString("PSSENO");
      response.sendRedirect("../person/person_result.jsp?psseno="+PSSENO);
   }
}catch (Exception ex){
                    ex.printStackTrace();
                  }finally{
                    try{
                      if (rs != null) {
                        rs.close();
                      }
                      if (stmt != null) {
                        stmt.close();
                      }
                      if (conn != null) {
                        conn.close();
                      }
                    }catch (Exception ex){
                      ex.printStackTrace();
                    }
                  }
%>

ttt015651

关注

1
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
jsp 链接Oracle的连接池和查询跳转代码（带登录）

-------------------------------------------------------------------以下是登录代码 http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">http://www.w3.org/1999/xhtml"> 信息查询系统body { margin-left: 0px; m
复制链接

扫一扫