对constrol.jsp文件修改试试:(仅供参考)
public String getStr(String str)
{
try{
String temp_p=str;
// byte[] temp_t=temp_p.getBytes("ISO8859-1");
// String temp=new String(temp_t);
//上面两句改为:String temp=new String(temp_p.getBytes("GB2312"),"ISO8859-1");
return temp;
}
catch(Exception e)
{
}
return "null";
}
public String getStr(String str)
{
try{
String temp_p=str;
// byte[] temp_t=temp_p.getBytes("ISO8859-1");
// String temp=new String(temp_t);
//上面两句改为:String temp=new String(temp_p.getBytes("GB2312"),"ISO8859-1");
return temp;
}
catch(Exception e)
{
}
return "null";
}
<%
user_name=request.getParameter("username");
pass_word=request.getParameter("password");
***System.out.println(user_name);
***System.out.println(pass_word);
user_name=getStr(user_name);
pass_word=getStr(pass_word);
***System.out.println(user_name);
***System.out.println(pass_word);sql="select * from login where name='"+user_name+"' and passwd='" + pass_word + "'";
rs=control.executeQuery(sql);
try
{
while(rs.next())
{
sql_name=rs.getString("name");
sql_pass=rs.getString("passwd");
***System.out.println(sql_name);
***System.out.println(sql_pass); }
}
{
while(rs.next())
{
sql_name=rs.getString("name");
sql_pass=rs.getString("passwd");
}
}
改成
try
{
while(rs.next()){
session.setAttribute("user_name",user_name);
response.sendRedirect("show.jsp");
}
else
{
session.setAttribute("user_name","");
response.sendRedirect("err.jsp");
}
}
{
session.setAttribute("user_name",user_name);
response.sendRedirect("show.jsp");
}
else
{
session.setAttribute("user_name","");
response.sendRedirect("err.jsp");
}这个判断就不要了
应该要import进来,同时要注意路径
<jsp:setproperty name="同id" property="bean中的属性名" param="jsp内对应的属性名">
(代码手写可能有误,你用工具再写下)
{
sql_name=rs.getString("name");
sql_pass=rs.getString("passwd");
}下面加几个语句
System.out.println("user_name"+user_name);
System.out.println(("pass_word"+pass_word);
System.out.println(("sql_name"+sql_name);
System.out.println(("sql_pass"+sql_pass);看看控制台喷出的是什么?是不是相等,然后再说吧
您好!我按你的指点我加了System.out.println(,,,,)进行测试:
<%
user_name=request.getParameter("username");
pass_word=request.getParameter("password");System.out.println("user_name"+user_name);
System.out.println(("pass_word"+pass_word);//(此处能正确输出user_name和pass_word); user_name=getStr(user_name);
pass_word=getStr(pass_word);sql="select * from login where name='"+user_name+"' and passwd='" + pass_word + "'";System.out.println("user_name"+user_name);
System.out.println(("pass_word"+pass_word);//(此处能正确输出user_name和pass_word);rs=control.executeQuery(sql);
try
{
while(rs.next())
{
sql_name=rs.getString("name");
sql_pass=rs.getString("passwd"); System.out.println(("sql_name"+sql_name);
System.out.println(("sql_pass"+sql_pass);//(此处能正确输出sql_name和sql_pass)
}
}
catch(Exception e) {
e.printStackTrace();
}
if(sql_name.equalsIgnoreCase(user_name) && sql_pass.equals(pass_word))
{
session.setAttribute("user_name",user_name);
response.sendRedirect("show.jsp");
System.out.println("user_name"+user_name);
System.out.println(("pass_word"+pass_word);
System.out.println(("sql_name"+sql_name);
System.out.println(("sql_pass"+sql_pass);//这个地方什么结果都不能输出,是那个地方错了呢?麻烦您再帮我看看好吗??谢谢!!
}
else
{
session.setAttribute("user_name","");
response.sendRedirect("err.jsp");
}rs.close();
%>
</body>
</html>