ºÜ¼òµ¥µÄÎÊÌâ ´ÓMYsqlÈ¡Êý¾Ý

Java code:

ResultSet rs=null;
endtime="2009-11-04"
String sql="select * from serverLogbyIP where date="+endtime;
System.out.println("hello");
rs=st.executeQuery(sql);



Ϊʲôȡ²»µ½Êý¾Ý
Êý¾Ý¿âÖÐÓÐÊý¾Ý

---

°Ñsql´ò³öÀ´,¿´ÔÚÊý¾Ý¿âÖÐÄܲ鵽Êý¾ÝÂð
System.out.println(sql);

---

Java code:

ResultSet rs=null;
endtime="2009-11-04"
String sql="select * from serverLogbyIP where date='"+endtime+"'";
System.out.println("hello");
rs=st.executeQuery(sql);

---

String sql="select * from serverLogbyIP where date=to_date("+endtime"+)";
ÕâÑùÊÔÊÔ

---

ÒýÓÃ

dateÊÇmysqlµÄ¹Ø¼ü×Ö£¬¼ÓEsc¼üÏÂÃæµÄÄǸö·ûºÅ£¬ÒªÃ´»»Ò»¸ö×Ö¶ÎÃû
String sql="select * from serverLogbyIP where `date`='"+endtime+"'";

Ê®·Ö¸Ðл¡£¡£¡£