teste.jsp

这是我写的简单智能网上答疑系统

<%@ page contentType="text/html;charset=gb2312" %>
<jsp:directive.page import="java.sql.ResultSet"/>
<%
java.sql.Connection conn;
//java.lang.String  strConn;
java.sql.Statement sqlStmt;
java.sql.ResultSet sqlRst=null;
int flag=0;
//java.lang.String strConn;
try{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();
conn =java.sql.DriverManager.getConnection("jdbc:sqlserver://localhost;user=sa;password=987613");
conn.setCatalog("QandA");
sqlStmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
String sqlQuery="select * from Expert";
sqlRst=sqlStmt.executeQuery(sqlQuery);
response.setContentType("text/html;charset=gb2312");
while(sqlRst.next()){
if(request.getParameter("username").equals(sqlRst.getString("Eno")))
{
if(request.getParameter("password").equals(sqlRst.getString("pwd")))
{
%>
<jsp:forward page="addA.jsp">
<jsp:param name="name" value=""/>
</jsp:forward>
<% } 
else {flag=1;}
}

%>
<% 
}
if(flag==1)
{
%>
密码错误
<%

 %>
<a href=log.jsp>返回</a>
<%
}
if(flag==0)
{
 %>
请先注册
<a href=log.jsp>返回</a>
<%
}
sqlRst.close();
sqlStmt.close();
conn.close();
}catch(java.sql.SQLException e){
out.println(e.toString());
}
%>