一个注册页的问题
accsk 2005-01-25 12:39:15 我想弄个注册页 可当点 submit后tomcat提示 列accsk无效(accsk为我注册的logname)
请问 这里说的无效是什么原因
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page language="java" import="java.sql.*" %>
//调用用来执行数据库操作的bean
<jsp:useBean id="workM" scope="page" class="webmail.conn"/>
//处理中文问题的自定义函数
<%!
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)
{
e.printStackTrace();
}
return "null";
}
%>
<%! String logname,realname,passwd1,passwd2,email;
boolean regAttempt=false;
String errorMessage="";
%>
<% logname=request.getParameter("logname");
realname=request.getParameter("realname");
passwd1=request.getParameter("passwd1");
passwd2=request.getParameter("passwd2");
email=request.getParameter("email");
logname=getStr(logname);
realname=getStr(realname);
passwd1=getStr(passwd1);
passwd2=getStr(passwd2);
email=getStr(email);
%>
<%//进行数据库操作
String sql="select * from member where logname="+logname+"";
ResultSet RS=workM.executeQuery(sql);
out.println(sql);
int rowscount=0;
try
{
while(RS.next())
{
rowscount++;
}
}
catch(Exception e)
{
e.printStackTrace();
}
if(rowscount==0)
{ //成功登录
regAttempt=true;
}
else
{
//输入的用户名已经存在
response.sendRedirect("reg_again.jsp?reg=error");
}
if(regAttempt==true)
{
String sqlinsert;
sqlinsert="insert into member(logname,realname,password,email)";
sqlinsert=sqlinsert+"Values('"+logname+"','"+realname+"','"+passwd1+"','"+email+"')";
workM.executeQuery(sqlinsert);
//注册成功
response.sendRedirect("reg_success.jsp");
}
%>
谢谢