这是完整的页面
<%@ page import="javax.naming.InitialContext"%>
<%@ page import="java.sql.*"%>
<%@ page import="com.gwfg.dbconn.*"%>
<%@ page import="com.gwfg.info.*"%>
<%@ page import="com.gwfg.work.*"%>
<%@ page import="com.gwfg.publicbean.*"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>用户登录验证</title>
<jsp:useBean id="userinfo" scope="session" class="com.gwfg.info.UserInfo"/>
<jsp:setProperty name="userinfo" property="*"/>
</head><body>
<%
try {
CharDisposal cd = new CharDisposal();
UserWork uw=new UserWork();
userinfo.setUSER_NAME(cd.trans(userinfo.getUSER_NAME()));
//try{
Connection conn = null;
Statement stmt=null;
ResultSet rst=null;
conn = DatabaseConn.getConnection();
out.print("数据库测试");
String sql="select * from t_user where USER_NAME='"+userinfo.getUSER_NAME().trim()+"' and USER_PASSWORD='"+userinfo.getUSER_PASSWORD().trim()+"'";
if(conn!=null)
{
out.println("Connection is OK!");
out.println("<br>");
stmt=conn.createStatement();
rst=stmt.executeQuery(sql);
out.println("以下是从数据库中读取出来的数据");
while(rst.next())
{
out.println("用户编码:"+rst.getString("USER_ID"));
out.println(" 用户编码:"+cd.trans(rst.getString("USER_NAME")));
out.println(" 密码:"+rst.getString("USER_PASSWORD"));
out.println("<br>"); }
}else{
out.println("Fail!");
}
}catch(Exception ne)
{
out.println(ne);
}
//out.print(userinfo.getUSER_DEPARTMENT()+"<br>");
//out.print(userinfo.getUSER_NAME()+"<br>");
//out.print(userinfo.getUSER_PASSWORD()+"<br>");
//String flag=uw.QueryUser(userinfo);
//out.print(flag+"<br>"); /*int flag=uw.QueryUser(userinfo);
if (flag==1)
{
//密码正确
session.setAttribute("ses_userinfo", userinfo);//将userBean放入Session对象中
response.sendRedirect("glory/glory_index.jsp") ; }else {
//密码错误
response.sendRedirect("fail.jsp") ;
}
}catch(Exception e)
{
out.print("<table width=\"100%\" height=\"100\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">");
out.print("<tr>");
out.print(" <td class=\"msg\" align=\"center\" valign=\"middle\">数据库访问出错,请联系系统管理员!</td>");
out.print("</tr>");
out.print("</table>");
}*/
%>
</body>
</html>运行后出现以下错误:
java.sql.SQLException: General error message from server: "Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (gb2312_chinese_ci,COERCIBLE) for operation '='"
<%@ page import="javax.naming.InitialContext"%>
<%@ page import="java.sql.*"%>
<%@ page import="com.gwfg.dbconn.*"%>
<%@ page import="com.gwfg.info.*"%>
<%@ page import="com.gwfg.work.*"%>
<%@ page import="com.gwfg.publicbean.*"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>用户登录验证</title>
<jsp:useBean id="userinfo" scope="session" class="com.gwfg.info.UserInfo"/>
<jsp:setProperty name="userinfo" property="*"/>
</head><body>
<%
try {
CharDisposal cd = new CharDisposal();
UserWork uw=new UserWork();
userinfo.setUSER_NAME(cd.trans(userinfo.getUSER_NAME()));
//try{
Connection conn = null;
Statement stmt=null;
ResultSet rst=null;
conn = DatabaseConn.getConnection();
out.print("数据库测试");
String sql="select * from t_user where USER_NAME='"+userinfo.getUSER_NAME().trim()+"' and USER_PASSWORD='"+userinfo.getUSER_PASSWORD().trim()+"'";
if(conn!=null)
{
out.println("Connection is OK!");
out.println("<br>");
stmt=conn.createStatement();
rst=stmt.executeQuery(sql);
out.println("以下是从数据库中读取出来的数据");
while(rst.next())
{
out.println("用户编码:"+rst.getString("USER_ID"));
out.println(" 用户编码:"+cd.trans(rst.getString("USER_NAME")));
out.println(" 密码:"+rst.getString("USER_PASSWORD"));
out.println("<br>"); }
}else{
out.println("Fail!");
}
}catch(Exception ne)
{
out.println(ne);
}
//out.print(userinfo.getUSER_DEPARTMENT()+"<br>");
//out.print(userinfo.getUSER_NAME()+"<br>");
//out.print(userinfo.getUSER_PASSWORD()+"<br>");
//String flag=uw.QueryUser(userinfo);
//out.print(flag+"<br>"); /*int flag=uw.QueryUser(userinfo);
if (flag==1)
{
//密码正确
session.setAttribute("ses_userinfo", userinfo);//将userBean放入Session对象中
response.sendRedirect("glory/glory_index.jsp") ; }else {
//密码错误
response.sendRedirect("fail.jsp") ;
}
}catch(Exception e)
{
out.print("<table width=\"100%\" height=\"100\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">");
out.print("<tr>");
out.print(" <td class=\"msg\" align=\"center\" valign=\"middle\">数据库访问出错,请联系系统管理员!</td>");
out.print("</tr>");
out.print("</table>");
}*/
%>
</body>
</html>运行后出现以下错误:
java.sql.SQLException: General error message from server: "Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (gb2312_chinese_ci,COERCIBLE) for operation '='"
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货