表单登录问题，中文用户名登录不成功

[鱼塘一条大鱼鱼鱼yyy]

登录时用中文用户名登录不成功，显示用户名或密码错误
数据库里有用户名密码，中文的登录不行拼音的能登录。
//用户登录
@SuppressWarnings("unchecked")
public String login(HttpServletRequest request, HttpServletResponse response) throws Exception {
String username = request.getParameter("username");
String password = request.getParameter("password");
String sql = UserService.getSql()+ " where username = ? and password=?";
List<User> list = UserService.getUserList(JDBC.queryForList(sql,new Object[]{username,password}));
if(list.size() >0) {
HttpSession session = request.getSession();
User user = list.get(0);
session.setAttribute("user",user );
return "url:index.jsp;";
} else {
return "message:用户名或者密码错误;url:login.jsp;";
}
}


//用户注册
public String register2(HttpServletRequest request, HttpServletResponse response) throws Exception{
String username = new String(request.getParameter("username").getBytes("ISO-8859-1"),"UTF-8");
String password = new String(request.getParameter("password").getBytes("ISO-8859-1"),"UTF-8");
String name = new String(request.getParameter("name").getBytes("ISO-8859-1"),"UTF-8");
String phone = new String(request.getParameter("phone").getBytes("ISO-8859-1"),"UTF-8");
String sql = UserService.getSql()+" where username = ? ";
List<User> list = UserService.getUserList(JDBC.queryForList(sql,new Object[]{username}));
if(list.size()>0){
return "message:该用户名已经存在;url:register2.jsp;";
}else{
sql = "insert into t_user(createtime,name,password,role,username,phone) values(?,?,?,?,?,?)";
JDBC.insertData(sql, new Object[]{Util.getTime(),name,password,0,username,phone});
return "message:注册成功;url:login.jsp;";
}


}

//更新用户操作
public String userupdate2(HttpServletRequest request, HttpServletResponse response) throws Exception{
String name = new String(request.getParameter("name").getBytes("ISO-8859-1"),"UTF-8");
String password = new String(request.getParameter("password").getBytes("ISO-8859-1"),"UTF-8");
String phone = new String(request.getParameter("phone").getBytes("ISO-8859-1"),"UTF-8");
String id = new String(request.getParameter("id").getBytes("ISO-8859-1"),"UTF-8");
String sql = "update t_user set name=?,password=?,phone=? where id = ?";
JDBC.updateData(sql, new Object[]{name,password,phone,Integer.parseInt(id)});
return "message:操作成功:id:userlist:url:manage/user/userlist";
}

[乔不思]

估计是乱码了，debug看看，如果是乱码，转下码看看

[尼古拉斯-全蛋]

同意楼上，查下是不是哪乱码了

[约定终点]

乱码造成的 建议重新设置一下 request的编码方式 另外看一下 数据库的字符集哈

[菜 头]

把用户名转一下码，像你注册功能那样

[鱼塘一条大鱼鱼鱼yyy]

引用 4 楼 u011320740 的回复:

把用户名转一下码，像你注册功能那样

恩

[發V發]

在JSP页面添加设置编码集的语句，对于中文建议使用jbk编码，在后期使用框架时用utf-8

[我的小dn]

可以看看配置文件是不是没加数据库的转码character=utf8

[Intboy]

debug