jspÖÐÈçºÎ¹¹Ô춯̬sqlÓï¾ä
1 String n = user.getName();
2 String pass = user.getPassword();
3 String sql = "select * from user where name = " + n + " and password = " + pass;
4 PreparedStatement ps = con.prepareStatement(sql);
µÚÈý¾äÓÐÎÊÌâ
MySQLSyntaxErrorException: Unknown column 'huoyingfans' in 'where clause'
ÄǸönÓ¦¸ÃÔÙ¼Ó¸öµ¥ÒýºÅ°É£¬ÎҼǵÃÊÇÕâÑùµÄ¡£
nǰºó¼Ó¸öµ¥ÒýºÅ
Íü¼Ç»¹ÓÐpasswordÁË Ò²Òª¼Ó
²»Ðеİ¡ £¡
// ¼ìÑéµÇ¼Óû§µÄºÏ·¨ÐÔ
public boolean checkUser() throws Exception {
boolean flag = false;
if (user != null) {
try {
String n = user.getName();
String pass = user.getPassword();
£¿£¿£¿£¿£¿ String sql = "select * from user where name = " +
'n' + " and password = " + 'pass';
PreparedStatement ps = con.prepareStatement(sql);
if (null != ps.executeQuery()) {
flag = true;
}
// ¹Ø±ÕÁ¬½Ó
ps.close();
con.close();
} catch (Exception e) {
e.printStackTrace();
}
}
return flag;
}
ÕâÑùд ÓÐÓï·¨´íÎó
ûÓÐÄÇÁÐ
ÎҾ;õµÃûÄÇÁÐ
Unknown column 'huoyingfans&
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......
ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд
ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jas ......
<html><head><title>[@title]</title>
<meta http-equiv=Content-Type content="text/html; charset=gb2312">
<script language='javascript'>
function diyCheck ......
Ïë×öÒ»¸öjspµÄµç×ÓÉÌÎñÍøÕ¾£¬ÏëÕÒһЩԴ´úÂ룬ÇëÎÊÄǸöÍøÕ¾ÓкõÄ×ÊÔ´¡£Ð»Ð»£¡
ËÑË÷Ï塃 ¿ªÔ´µÄÒ²ÓÐ
csdn¾ÍÓÐÏàËÆµÄÔ´Â룬¥Ö÷ËÑÒ»ÏÂ
java ¿ªÔ´´óÈ«
¸ÄÄ£°åºÃÂ鷳Ŷ£¬»¹²»Èç×Ô¼ºÐ´¸öÁËÄØ
jf
¶¥Ò» ......