Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

´ø²ÎÊýµÄSQLÓï¾ä

String sql="insert into author values(?£¬?, ?);";
super.updateBySql(sql, new IParamBinding(){
public void bindParam(PreparedStatement pstmt) throws SQLException{
System.out.print("asd");
pstmt.setInt(1, model.getId());
pstmt.setString(2,model.getFirstname());
pstmt.setString(3,model.getLastname());
}
                       
ÇëÎÊÎÒÕâ¸öSQLÓï·¨ÓдíÎóÂð£¿ÎÒÊÇÁ´½ÓMYSQLµÄ    TOMCAT×ÜÊÇ˵No value specified for parameter 1
String sql="insert into author values(?£¬?, ?);";

×¢ÒâÒ»ÏÂÕâ¸ö·ûºÅ£¬Èç¹ûÈÔÓÐÎÊÌ⣬½¨Òéµ½ java°æ»ò web°æÈ¥ÎÊһϡ£

ÒýÓÃ
String sql="insert into author values(?£¬?, ?);";

×¢ÒâÒ»ÏÂÕâ¸ö·ûºÅ£¬Èç¹ûÈÔÓÐÎÊÌ⣬½¨Òéµ½ java°æ»ò web°æÈ¥ÎÊһϡ£


ÎÒÖªµÀ×Ô¼º´ò´í£¬µ«ÎÒÔÚMYECLIPSEÊÇûÓдò´íµÄ£¬ÕâÖÖÓï·¨ÔÚmysqLÓ¦¸Ãû´í°É£¿

String sql="insert into author values(?£¬?, ?);";
java
ÀïÃæÃ»·ÖºÅ

Column count doesn't match value count at row 1
ÄÇÕâ¸öÊÇʲô´íÎ󣬿ÉÒÔÖ¸µãÏÂÂð£¿

Õâ¸öÊÇ˵ÄãµÄ£¿¸öÊýºÍÄãsetʱºò²ÎÊý²»Æ¥Åä

¾ÍÊÇÄãûÍêÈ«ÉèÖòÎÊý

Ó¦¸ÃÊÇÄãsetµÄʱºòÓпÉÄÜûֵ

String sql="insert into author values(?,?,?)";
PreparedStatement pstmt = con.createPreparedStatement(sql);


Ïà¹ØÎÊ´ð£º

sql ʱ¼äÎÊÌâ

sql table±íÓиöÎı¾ÀàÐ͵Äa×ֶΣ¬´æ´¢µÄÄÚÈÝÈ«²¿ÊÇÊý×Ö£¬ÀýÈç2009001£¬2008578ÕâÑùµÄ¸ñʽ£»b×Ö¶ÎÎı¾ÀàÐÍ£¬´æµÄÒ²ÊÇÊý×ÖÀýÈç 001£¬123
aspÀïÃæ strday=100£¬strb=001

ÎÒÏë¶Á³ö£¬´Óa×ֶεÄÊý×Ö°´´óµ½Ð¡µÄË ......

sql ²éѯ

  ÎÒÓÐÒ»¸öÔºÍÈÕ×é³ÉµÄÊý×Ö£¬ÓÐÁ½×éÔºÍÈÕ
ÏëÔÚÉí·ÝÖ¤ºÅÖÐÌôÑ¡³öÔڸøÃÁ½×éÔÂÈÕÖ®¼ä³öÉúµÄÈË£¬²»ÖªµÀÓ¦¸ÃÔõôд.
Éí·ÝÖ¤ºÅÓпÉÄÜÊÇ15λ»òÕß18λ

ÔÂÈÕ×éºÏµÄÐÎʽÈçÏÂ
10-17/04-20
ÔÂ-ÈÕ/ÔÂ- ......

sqlÎļþ£¨Êý¾Ýº¬ÖÐÎÄ£©DOSÃüÁî´°¿ÚÎÞ·¨µ¼ÈëÎÊÌâ

ÎÒÓõÄÊÇmysql5.1£¬Êý¾Ý¿â×Ö·û¼¯Îªutf8

ͨ¹ýdosÃüÁîÐе¼ÈëSQLÎļþ ³ö´í£¬ÎÞ·¨µ¼Èë¡£

½«SQLÎļþÖеÄÊý¾ÝÈ«²¿Ê¹ÓÃÓ¢ÎÄ ¿ÉÒÔµ¼Èë

ÇëÎÊÎÊÌâÔÚÄÄ£¿
×°¸öÖÐÎÄÈí¼þ¼´¿É.

ºÜ¶àÄêÒÔǰ,Óùý¸öÒ»¸ ......

sql ÎÊÌâ

DateTime startTime=DateTime(em_1.Text)
DateTime endTime=DateTime(em_2.Text)

string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+"') and (EndTime ......

SQLÓï¾äЧÂÊÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / ÆäËûÊý¾Ý¿â

´ó¼Ò°ïæ¿´¿´Õâ2¸ösqlÓï¾äÄĸö²éѯµÄËٶȸü¿ìµã¡£Ð»Ð»°ïæ¡£±È½Ï׿±¡£ÔÚ×öÐÔÄܲâÊÔ¡£
select * from
  ±íA LEFT OUTER JOIN ±íB ON (±íA.id || ' ' =±íB.id) ,±íC , ±íD, ±íE
WhereÆäËûÌõ¼þ
select * ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ