两个问题,帮忙,并借此机会感谢长期以来帮助我的师兄弟,师姐妹

sha wen ti mei xi wang le
fang qi ba
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>社区就业服务</title>
<script language="JavaScript" type="text/JavaScript">

</script>
</head><%//声名
java.sql.Connection sqlConn;
java.sql.Statement sqlStmt;
java.sql.ResultSet sqlRst;
//regiester jdbc driver
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
//connect to the database
sqlConn=java.sql.DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=biyesheji;SelectMethod=direct","sa","sa");
//create the driver handle
sqlStmt=sqlConn.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);
//excute sql
sqlRst=sqlStmt.executeQuery("select * from log");%>
<%!
public String getStr(String str)
{
try
{
String temp_p=str;
byte[] temp_t=temp_p.getBytes("ISO8859-1");
String temp=new String(temp_t);
return temp;
}
catch(Exception e)
{

}
return "null";
}
%><%!
String logname,logpass,memberkind;
int temp=0;
boolean loginAttempt = false;
boolean loginOK = false;
String errorMessage = "请您登陆";
%>
<%
if(request.getParameterValues("login") != null
&& request.getParameterValues("login")[0].trim().equals("GO!")
&&request.getParameterValues("logname") != null
&&request.getParameterValues("logpass") != null
&&request.getParameter("memberkind")!=null)
{
loginAttempt = true;
}
if (loginAttempt)
{
//logname=request.getParameter("logname");
logpass=request.getParameter("logpass");
memberkind=request.getParameter("memberkind");
//logname=getStr(logname);
logpass=getStr(logpass);
memberkind=getStr(memberkind);
if(memberkind.equals("normal")){
      logname=new String( "普通会员".getBytes("gb2312"),"iso-8859-1" )+request.getParameter("logname");
      logname=getStr(logname);
      String sql="select * from log where logname='"+logname+"' and password='"+logpass+"'";
          sqlRst=sqlStmt.executeQuery(sql);                    }

else if(memberkind.equals("community")){
      logname=new String( "社区会员".getBytes("gb2312"),"iso-8859-1" )+request.getParameter("logname");
      logname=getStr(logname);
      String sql="select * from member where logname='"+logname+"' and password='"+logpass+"'";
          sqlRst=sqlStmt.executeQuery(sql);                           }

else if(memberkind.equals("company")){
      logname=new String("企业会员".getBytes("gb2312"),"iso-8859-1" )+request.getParameter("logname");
      logname=getStr(logname);
//        out.print(logname);
      String sql="select * from company where logname='"+logname+"' and password='"+logpass+"'";
          sqlRst=sqlStmt.executeQuery(sql);                          }
int rowscount=0;
try
{
while(sqlRst.next())
{
rowscount++;
}
}
catch(Exception e)
{ }
if(rowscount!=0)
{
errorMessage="成功登陆";
session.setAttribute("username",logname);
session.putValue("username",logname);
loginOK=true;

if(loginOK&&memberkind.equals("community"))
     {temp=1;//response.sendRedirect("http://localhost:8080/biyesheji/member/memberindexset.jsp");
}
if(loginOK&&memberkind.equals("company"))
     {temp=2;//response.sendRedirect("http://localhost:8080/biyesheji/company/companyindexFrameset.jsp");
} //String url;
//url=request.getParameter("url");
//out.println(url);
// if(url==null){
// response.sendRedirect("http://localhost:8080/jspbook/ec");
// }
// else{
// response.sendRedirect("http://localhost:8080"+url);
// }
//}//sqlRst.close();
//sqlStmt.close();
//sqlConn.close(); }else{
errorMessage="您的用户名或者密码不正确";
session.setAttribute("username","");
response.sendRedirect("login.jsp");
}}
%>
<%
sqlRst.close();
sqlStmt.close();
sqlConn.close();
%>
<body>
<%@ include file="header.inc"%>
<table width="760" border="0" align="center">
  <tr>
    <td width="22%" bgcolor="#99CCFF">
<div align="center"> <font size="2">
        <%if(session.getAttribute("username")!=null){out.println(session.getAttribute("username"));}%>
        您好 </font></div></td>
    <form name="form1" method="post" action="">
<input name="temp" type="hidden" value="<%=temp%>">
      <td width="18%" bgcolor="#99CCFF">
<div align="center"><font size="2">用户名</font>：
          <input name="logname" type="text" size="8">
        </div></td>
      <td width="16%" bgcolor="#99CCFF">
<div align="center"><font size="2">密码</font>：
          <input name="logpass" type="password" size="8">
        </div>
      <td width="24%" bgcolor="#99CCFF">
<div align="center"><font size="2">会员种类</font>：
          <select name="memberkind">
            <option value="nochoice">--请选择--</option>
            <option value="normal">普通会员</option>
            <option value="community">社区会员</option>
            <option value="company">企业会员</option>
          </select>
        </div></td>
      <td width="20%" bgcolor="#99CCFF">
<div align="center"><input type="submit" name="login" value="GO!" onClick="sub()">
           <a href="befreg.jsp"><font size="2">注册</font></a> <font size="2">找回密码</font></div></td>
    </form>
  </tr>
</table>
<p> </p>
</body>
</html>
<script language="JavaScript" type="text/javascript">
function sub()//判断转到的页面

{if(form1.temp.value==1)
{window.open("http://localhost:8080/biyesheji/member/memberindexset.jsp" );}
if(form1.temp.value==2)
{window.open("http://localhost:8080/biyesheji/company/companyindexFrameset.jsp" );}
}
</script>
代码出来了,有什么地方不明白我可以解释

调试易

两个问题,帮忙,并借此机会感谢长期以来帮助我的师兄弟,师姐妹

解决方案 »