ÎÒÒª½øÐÐÖÐÎĵÄÊý¾Ý¿â²Ù×÷¡£
ÔÚͨ¹ý±íµ¥½øÐвÙ×÷ºó£¬ÎÒ½«µÃµ½µÄ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 ......
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»ÖªµÀÔõôÏòÕâ ......
ÇëÎÊ´ó¼Ò°¡£¬ÓÃC#×öÏîÄ¿£¬Êý¾Ý¿âÓÃʲôºÃÄØ£¿SQL£¿»¹ÊÇmySQL£¿
ËûÃǵÄÓŵ㲻×ã·Ö±ðΪʲô£¿
ÕâµÃ¿´ÄãʹÓõķ¶Î§ºÍÊý¾ÝÁ¿µÄ´óС.
Ã²ËÆSQL SERVER ±ÈMYSQL¸üÓÅԽЩ.
ѧϰ up
΢Èí×Ô¼ºµÄ²úÆ·
¶¼ÊÇΪ×Ô¼º½áºÏ¶øÉèµÄ
ËùÒÔvs2008+Sql server
......
ÓÃdatabase desktop ¹¤¾ß×·¼ÓItem.db±í£¬µ½SQL ±íItemÖÐ(×ֶεÈÏàͬ£©¡£ÌáʾGeneral SQL error
²é¿´SQL±í£¬·¢ÏÖItem²»¼ûÁË¡£
Êý¾Ý¿â ¹ÊÕÏ»¹Ôģʽ Ϊ <¼òµ¥>
ʹÓÃlog explorer¹¤¾ßÎÞ·¨²é³öµ±Ê±µÄÈÕÖ¾¼Ç¼
ʹÓà ÈÕÖ¾ »Ö¸´Ö¸¶¨ÈÕÆÚ£¬LNSÌ«Íí¡££¨ÔÒòÊÇÔçÆÚ±¸·ÝÊý¾Ý¿âʱ£¬¹ÊÕÏģʽΪ¼òµ¥£¬ÈÕÖ¾±¸·ÝΪÍê ......
¼ÙÈçÎÒÓÐÁ½±íA£¬B ÎÒÏÖÔÚÐÞ¸ÄA±íÖеÄÒ»Ìõ¼Ç¼£¬Ð޸ĺóµÄÕâÌõÊý¾ÝҪͬʱ²åÈëµ½AºÍB±íÖУ¬¸ÃÔõôдÕâ¸ösqlÓï¾äÄØ£¿ÎÒÓõÄÊÇsqlserver2000Êý¾Ý¿â,ÒªÇóÊÇÔÚ´úÂëÀïÍê³É,±ÈÈçÎÒÓÐÕâ¶Î´úÂë:
public void updateMessageInfo(Phone p) {
String sql = "update phone set mc=?,jg=?,number=?,datet ......
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....
ÓÐûÓиü¼òµ¥µÄд·¨
£¿£¿£¿£¿£¿£¿£¿£¿£ ......