java³ÌÐò±¨´í£¡¸ßÊÖÖ¸µã - Java / Web ¿ª·¢
Caused by: java.sql.SQLException: No value specified for parameter 1
ÏÂÃæÊdzÌÐò£º
String sql="insert into teacrepl_classtimedispense(teacherreplaceid,classtimedispenseid,replaceksnum,replacetime) values("+
teacreplacemaxid+","+chooseclasstimedispenseid+","+replaceKSnum+","+replaceDate+")";
Session session=this.getHibernateTemplate().getSessionFactory().openSession();
Transaction tx=null;
try{
tx=session.beginTransaction();
session.createSQLQuery(sql).executeUpdate();
}catch(Exception e){
if(tx!=null) tx.rollback();
e.printStackTrace();
}
finally{
session.flush();
session.close();
}
}
×Ô¼º¶¥£¡
²»ÊÇ˵µÄºÜÃ÷È·Âð£¿
ûÓиøÐÂÔöÊý¾ÝµÄµÚÒ»ÁÐÖ¸¶¨Öµ
char£¬varchar,date,timestampÕâÑùµÄ×Ö¶ÎÐèÒª¼Ó''¡£¡£ÄãÊÔÊÔ¡£
ËùνµÄÐÂÔöµÚÒ»ÁÐÖ¸µÄÊÇÖ÷¼üÂð£¿
ÄãÄѵÀûÓÐÉ趨Ö÷¼ü£¿£¿£¿
ÎÒÏëÎÊÏ£¬ÓÃssh´î½¨µÄ¿ò¼Ü£¬ÔõôÄܹ»×Ô¶¯±£´æÁ½¸ö±íµÄÖмäÓ³Éä±íÄØ£¿ÎÒ²åÈëµÄÕâ¸öÊý¾Ý¾ÍÊÇÍùÖмä±í²åÈ룬ÓÉÓÚhql²»»á£¬ËùÒÔÖ»ÄÜʹÓÃsqlÁË
µ÷ÊÔÒ»ÏÂŶ£¬°ÑµÃµ½µÄSQL¿½³öÀ´£¬·Åµ½Êý¾Ý¿âÖ´ÐÐһϿ©
{{---
Ïà¹ØÎÊ´ð£º
µ±ÖªµÀÒ»¸öÈÕÆÚ£¬ÈçºÎ°ÑÕâ¸öÈÕÆÚËùÔÚÑ®µÄǰºóÁ½¸öÈÕÆÚÈ¡³ö
±ÈÈçÊäÈë20090905£¬¾ÍÊäÈë20090901 20090910
Êä³ö20090901 20090910
È¡µÃÌìÊýºó×÷Ò»ÏÂÅжÏÔÙ°ÑÕâ¸ö·½·¨ÓÃÏÂvoid set(int field, int value)
......
¸÷·´óÏÀ¸ø¸ö˼·£¬²»ÊÇÔÚÏßµÄÄÇÖÖ£¬¾ÍÊÇÒ»¸ö×öÆÕͨµÄÓ¦ÓóÌÐò¡£
´Ê¿âÔõôÉú³ÉÄØ£¿
²»»á¡£
ÒýÓÃ
´Ê¿âÔõôÉú³ÉÄØ£¿
ÕÒ±¾×Öµä
ÒýÓÃ
´Ê¿âÔõôÉú³ÉÄØ£¿
Êý¾Ý¿â ºÇºÇ
ÓÃmap ¼üÖµ¶ÔÓ¦
Èç¹ûÓÃÊý¾Ý¿ ......
ÎÒÔÚ javaºËÐļ¼ÊõÉÏ ¿´ÁËÒ»¸ö ÀûÓà Java socket emailµÄÀý×Ó ¿ÉÊÇÔõôҲ ²»³É¹¦ Ϊʲô£¿
Ô´Âë
Java code:
package cn.com.test.email;
import java.awt.GridBagLayout;
import java.awt.event.Action ......
id name datetime
1 a 2010-05-13 10:15:00
2 b 2010-05-14 09:10:00
3 d 2010-05-14 10:10:00
ÈçºÎ½«¾àÀëĿǰ×î½üµÄÄǸö¼Ç¼µÄname ¸üÐÂΪ¡°x¡±ÄØ
лл¿© °¡ ºÇºÇ
update table_n ......
ÏÖÔÚ²»ÏëÓÃ<a> </a> ±êÇ© £¬ÒòΪµã»÷ºó»á³öÏÖÒ³ÃæÖØ¶¨Î»£¬¸øÎÄ×Ö¼ÓÉÏcssÑùʽ¾Í¿ÉÒÔ¿´ÆðÀ´ ÊÇhrefÔõôʵÏÖÕâÑùµÄcss
text-decoration:underline; cursor:hand;
ÒýÓÃ
text-decoration:underline; cur ......