Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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+ASP

....½Óµ½Ò»¸öС³ÌÐò..¹¤×÷Ô­À´´ó¸ÅÊÇÕâÑùµÄ...ǰ̨ÊÇWEB·þÎñÆ÷.¼Ü¹¹¾ÍÊÇASP+SQL..ǰ̨ÓÉASPÏòSQLÌí¼Ó·þÎñÀà±ð(±íµ¥).È»ºóÓÖºǫ́³ÌÐò¶ÁÈ¡±íµ¥..Ҫʵʱ¶ÁÈ¡..È»ºóÏÔʾÔÚ·þÎñÆ÷ÉÏÃæ..´ÓÀíÂÛÉÏÃæÄÜÐÐͨ²»?Èç¹û¿ÉÒÔ..ºǫ́ ......

sql ʱ¼äÎÊÌâ

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

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

sql ÎÊÌâ

PBÖпª·¢µÄ¡£

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

string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+&q ......

sql server ³¬Ê±ÎÊÌâ

ÕýÔÚ×ösql server 2000Êý¾Ý¿â¿ª·¢£¬Êý¾Ý¿â¼Ç¼ÊýºÜ¶à£¬¶à´ïǧÍòÌõ£¬Öظ´µÄÒ²ºÜ¶à£¬ÓÃgroup byдÁËÒ»ÌõÈ¥ÖØµÄÓï¾ä£¬delete from table where (id not in (select min(id) from table group by ×Ö¶Î1))
Óòéѯ·ÖÎöÆ ......

SQL²éѯÎÊÌâÇó½Ì£¿


select a.fyear,b.fname,
'1ÔÂ'=case when fperiod=1 then sum(a.fendbal) else 0 end ,
'2ÔÂ'=case when fperiod=2 then sum(a.fendbal) else 0 end ,
'3ÔÂ'=case when fperi ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ