Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : sql

JSP º¬ÖÐÎÄ sqlÓï¾ä²»Ê¶±ð

ÎÒÒª½øÐÐÖÐÎĵÄÊý¾Ý¿â²Ù×÷¡£
ÔÚͨ¹ý±íµ¥½øÐвÙ×÷ºó£¬ÎÒ½«µÃµ½µÄString ͨ¹ýÈçÏ·½·¨ÄÜÕý³£ÏÔʾÖÐÎÄ
public String getStr(String str) {
try {
String tmp = str;
byte[] tmps = tmp.getBytes("ISO8859-1");
String temp = new String(tmps);
return temp;
} catch (Ex ......

ÐÂÊÖÇó½ÌÔõôÔÚjspÖÐÓÃsqlÓï¾ä¼ÓÈë±íÄÚÈÝ ÔÚÏßµÈ

String sql="CREATE TABLE why(a int,b int, c int, d int)";
  ResultSet rs = null;
try {
rs = stmt.executeQuery(sql);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
ÏÖÔÚÄܹ»´´½¨Ðµıíwhy¡£µ«ÊDz»ÖªµÀÔõôÏòÕâ ......

SQLÓëmySQLÄĸö¸üÊʺÏÓÚ×öC#¿ª·¢µÄÊý¾Ý¿âÄØ£¿

    ÇëÎÊ´ó¼Ò°¡£¬ÓÃC#×öÏîÄ¿£¬Êý¾Ý¿âÓÃʲôºÃÄØ£¿SQL£¿»¹ÊÇmySQL£¿
ËûÃǵÄÓŵ㲻×ã·Ö±ðΪʲô£¿
ÕâµÃ¿´ÄãʹÓõķ¶Î§ºÍÊý¾ÝÁ¿µÄ´óС.

Ã²ËÆSQL SERVER ±ÈMYSQL¸üÓÅԽЩ.

ѧϰ up

΢Èí×Ô¼ºµÄ²úÆ·
¶¼ÊÇΪ×Ô¼º½áºÏ¶øÉèµÄ
ËùÒÔvs2008+Sql server
......

SQL ±í¶ªÊ§

ÓÃdatabase desktop ¹¤¾ß×·¼ÓItem.db±í£¬µ½SQL ±íItemÖÐ(×ֶεÈÏàͬ£©¡£ÌáʾGeneral SQL error
²é¿´SQL±í£¬·¢ÏÖItem²»¼ûÁË¡£
Êý¾Ý¿â ¹ÊÕÏ»¹Ô­Ä£Ê½ Ϊ <¼òµ¥>
ʹÓÃlog explorer¹¤¾ßÎÞ·¨²é³öµ±Ê±µÄÈÕÖ¾¼Ç¼

ʹÓà ÈÕÖ¾ »Ö¸´Ö¸¶¨ÈÕÆÚ£¬LNSÌ«Íí¡££¨Ô­ÒòÊÇÔçÆÚ±¸·ÝÊý¾Ý¿âʱ£¬¹ÊÕÏģʽΪ¼òµ¥£¬ÈÕÖ¾±¸·ÝΪÍê ......

ÇóÒ»sqlÓï¾ä!!

  ¼ÙÈçÎÒÓÐÁ½±íA£¬B ÎÒÏÖÔÚÐÞ¸ÄA±íÖеÄÒ»Ìõ¼Ç¼£¬Ð޸ĺóµÄÕâÌõÊý¾ÝҪͬʱ²åÈëµ½AºÍB±íÖУ¬¸ÃÔõôдÕâ¸ösqlÓï¾äÄØ£¿ÎÒÓõÄÊÇsqlserver2000Êý¾Ý¿â,ÒªÇóÊÇÔÚ´úÂëÀïÍê³É,±ÈÈçÎÒÓÐÕâ¶Î´úÂë:
    public void updateMessageInfo(Phone p) {
String sql = "update phone set mc=?,jg=?,number=?,datet ......

Õâ¸ösqlÔõôд

sqlÓï¾ä
ÎÒÓÐ5¸ö±í(¼ÙÈçÊÇA¡¢B¡¢C¡¢D¡¢E)£¬ÀïÃæ¶¼ÓÐid,title,timestartÕâÈý¸ö×Ö¶Î
ÎÒÏëͬʱ´ÓÕâ5¸ö±íÀï°ÑÕâ3¸ö×Ö¶ÎÑ¡³öÀ´£¬Ó¦¸ÃÔõôд

ÏÖÔÚÖªµÀµÄд·¨ÊÇ
select A.id,B.id,C.id,A.title,B.title,C.title,A.timestart,B.timestart,C.timestart from A,B,C....
ÓÐûÓиü¼òµ¥µÄд·¨

£¿£¿£¿£¿£¿£¿£¿£¿£ ......
×ܼǼÊý:3315; ×ÜÒ³Êý:553; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [275] [276] [277] [278] 279 [280] [281] [282] [283] [284]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ