一個奇怪的現象:在java應用程序中結果是ok,但在jsp中是err!
<%@ page session="true" %>
<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="Control.*" %>
<%@ page import="java.io.*" %>
<%@ page import="java.lang.*" %>
<jsp:useBean id="user" class="UserBean.wdye"/>
<html>
<head>
<title>land</title>
</head>
<body>
<%
String userid=request.getParameter("username");
String password=request.getParameter("password");
//user.format();
userid=userid.trim();
password=password.trim();
try{
Connection cn;
Statement stm;
connDatabase cndb;
cndb=new connDatabase();
cn=cndb.connODBC("test");
stm=cn.createStatement( ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String strsql;
int rows;
rows=0;
strsql="select * from user where userid='"+userid+"'";
ResultSet rs=stm.executeQuery(strsql);
if (rs.next())
{%>
Ok!
<%}else{%>
falust!
<%}
}
catch(Exception e)
{%>
err
<%}
/* boolean blnche ;
blnche=false;
try
{
user.setUserid(userid);
user.setPassword(password);
blnche=user.searchuser();
if (blnche)
{
%>
Wellcome in <%= userid %>
<%}else{%>
land fault <%= user.getUserid() %> USER: <%= user.getPassword() %>
<%}
}
catch(Exception e)
{%>
err:<%=e %>
<%}*/ %>
</body>
</html>