不能第二次访问数据库,该怎么处理
日期：2014-05-18 浏览次数：20825 次
不能第二次访问数据库
<%@ page language= "java " import= "java.sql.* " pageEncoding= "GB18030 "%>
<%request.setCharacterEncoding( "gb2312 ");%>
<html>
<head>
</head>
<body bgColor=#4e7dd1>
<form action= "webedit.jsp " method= "post ">
<table align= "center ">
<tr> <td align= "center "> <FONT style= "FONT-SIZE: 15pt " color=#eff5fa> 后台网络收藏夹管理 </FONT> </td> </tr>
<jsp:useBean id= "resource " scope= "page " class= "sju.sjumis.yuanding.util.TeacherDBBean "> </jsp:useBean>
<%String address = request.getParameter( "webaddress ");
String name = "benwei ";
ResultSet rs = resource.executeQuery( "select * from collectioncontent where hrefaddress= ' "+address+ " ' and username= ' " +name+ " ' ");
if(rs.next())
{%>
<tr> <td> 网站名称: </td> <td> <input type= "text " name= "text1 " value= <%=rs.getString( "webname ")%> > </td> </tr>
<tr> <td> 网站地址: </td> <td> <input type= "text " name= "text2 " value= <%=rs.getString( "hrefaddress ")%> > </td> </tr>
<tr> <td> 网站名称: </td> <td> <input type= "text " name= "text3 " value= <%=rs.getString( "remark ")%> > </td> </tr>
<tr> <td> <input type= "hidden " name= "text4 " value= <%=rs.getString( "hrefaddress ")%> > </td> </tr>
<%}
else
{%>
<tr> <td> 网站名称: </td> <td> <input type= "text " name= "text1 "> </td> </tr>
<tr> <td> 网站地址: </td> <td> <input type= "text " name= "text2 "> </td> </tr>
<tr> <td> 网站名称: </td> <td> <input type= "text " name= "text3 "> </td> </tr>
<%}resource.closeStmt();%>
<tr>
<td align= "center "> <input name= " " type= "submit " value= "提交 " /> </td>
<td align= "center "> <input name= " " type= "reset " value= "重置 " /> </td>
</tr>
</table>
<%
String text1Value = request.getParameter( "text1 ");
String text2Value = request.getParameter( "text2 ");
String text3Value = request.getParameter( "text3 ");
String text4Value = request.getParameter( "text4 ");
if(text1Value == null && &nbs
<%@ page language= "java " import= "java.sql.* " pageEncoding= "GB18030 "%>
<%request.setCharacterEncoding( "gb2312 ");%>
<html>
<head>
</head>
<body bgColor=#4e7dd1>
<form action= "webedit.jsp " method= "post ">
<table align= "center ">
<tr> <td align= "center "> <FONT style= "FONT-SIZE: 15pt " color=#eff5fa> 后台网络收藏夹管理 </FONT> </td> </tr>
<jsp:useBean id= "resource " scope= "page " class= "sju.sjumis.yuanding.util.TeacherDBBean "> </jsp:useBean>
<%String address = request.getParameter( "webaddress ");
String name = "benwei ";
ResultSet rs = resource.executeQuery( "select * from collectioncontent where hrefaddress= ' "+address+ " ' and username= ' " +name+ " ' ");
if(rs.next())
{%>
<tr> <td> 网站名称: </td> <td> <input type= "text " name= "text1 " value= <%=rs.getString( "webname ")%> > </td> </tr>
<tr> <td> 网站地址: </td> <td> <input type= "text " name= "text2 " value= <%=rs.getString( "hrefaddress ")%> > </td> </tr>
<tr> <td> 网站名称: </td> <td> <input type= "text " name= "text3 " value= <%=rs.getString( "remark ")%> > </td> </tr>
<tr> <td> <input type= "hidden " name= "text4 " value= <%=rs.getString( "hrefaddress ")%> > </td> </tr>
<%}
else
{%>
<tr> <td> 网站名称: </td> <td> <input type= "text " name= "text1 "> </td> </tr>
<tr> <td> 网站地址: </td> <td> <input type= "text " name= "text2 "> </td> </tr>
<tr> <td> 网站名称: </td> <td> <input type= "text " name= "text3 "> </td> </tr>
<%}resource.closeStmt();%>
<tr>
<td align= "center "> <input name= " " type= "submit " value= "提交 " /> </td>
<td align= "center "> <input name= " " type= "reset " value= "重置 " /> </td>
</tr>
</table>
<%
String text1Value = request.getParameter( "text1 ");
String text2Value = request.getParameter( "text2 ");
String text3Value = request.getParameter( "text3 ");
String text4Value = request.getParameter( "text4 ");
if(text1Value == null && &nbs
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
