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

SqlserverÖеıí¸üв»ÁË

SqlserverÖеıí¸üв»ÁË£¬ÎÒÓÐÒ»¸öthreads±í£¬
ÀïÃæÓлظ´Êý£¬±êÌâʲôµÄÔÙ³ÌÐòÖÐ×ö£¬¸üÐÂ
²»ÁËÊý¾Ý¿â£¬ÔÚÊý¾Ý¿âÈËΪµÄ¿ÉÒÔ¸üС£
²»ÖªµÀʲôԭÒò£¬¸ú±íÖ®¼äµÄ¹ØÏµÓйØÂð£¿
´óÏÀÃÇ£¬°ï°ïæ°¡£¿£¿£¿
¸Ð¾õ³ÌÐòû´íµÄ¡£

public int modifyThreads(Threads threads) {
int num=0;
String sql="update threads set fid=?,author=?,authorid=?,subject=?,dateline=?,lastPost=?,lastPoster=?,views=?,replies=?,displayOrder=?,highLight=?,digest=?,attachment=?,moderated=? where tid="+threads.getTid();
this.openConn();
try {

pstmt=conn.prepareStatement(sql);
pstmt.setInt(1,threads.getFid());
pstmt.setString(2, threads.getAuthor());
pstmt.setInt(3, threads.getAuthorid());
pstmt.setString(4,threads.getSubject());
System.out.println(threads.getSubject());
pstmt.setString(5,threads.getDateline().toString());
pstmt.setString(6,threads.getLastPost().toString());
pstmt.setString(7,threads.getLastPoster());
pstmt.setInt(8,threads.getViews());
pstmt.setInt(9,threads.getReplies());
pstmt.setByte(10,threads.getDisplayOrder());
pstmt.setByte(11,threads.getHighLight());
pstmt.setByte(12,threads.getDigest());
pstmt.setByte(13,threads.getAttachment());
pstmt.setByte(14,threads.getModerated());
num=pstmt.executeUpdate();
} catch (SQLException e) {


Ïà¹ØÎÊ´ð£º

¹ØÓÚSQLSERVERµ×²ãÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»


ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡

¹Ø×¢¡«¡«

Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......

java³ÌÐòÁ¬½ÓSQlServerµÄÎÊÌâ - Java / Java SE

import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class QueryTest&n ......

Atom N280Äܰ²×°²¢Ê¹ÓÃvs.net2008ºÍsqlServerÂð

ÇëÓùýµÄÅóÓѸæÖªÏ£¬Ð»Ð»£¡
ÃÀµÄÄã,ÄÇÍæÒâÖ»ÄÜ×°×°ULTRAEDIT

ÄãÊÔ¹ý£¿È·Êµ²»ÐУ¿

¸çÃÇ  ÄãÓÃ586ÅÜÅÜ WIN vista ÊÔÊÔ

ûÄÇôÑÏÖØ£¬ÎÞ·ÇÊÇËÙ¶ÈÂýµã¶øÒÑ£¬¶ÔÓÚvs2008À´Ëµ£¬Äڴ滹ÊǸö¸üÖØÒªµÄÒòËØ¡£
......

ÈçºÎÉèÖÃSqlserverÊý¾Ý¿âÈÕÖ¾Ôö³¤·½Ê½

ÈçÌâ¡£
ÎÒÏ붨ÆÚÖ´ÐгÌÐò£¬É¾³ý²»ÓõÄÊý¾Ý£¬ÊÕËõÒ»ÏÂÊý¾Ý¿â£¬Æ½Ê±Ê¹ÓõÄʱºò£¬ÈÕÖ¾×î´óÎļþ´óСΪÏÞÖÆ200MB£¬
µ«ÊÇÊÕËõµÄʱºò£¬»á²úÉú´óÁ¿ÈÕÖ¾£¬Èç¹û³¬¹ýÏÞÖÆ£¬ÔòÊÕËõÊý¾Ý¿âʱ»áʧ°Ü£¬ÎÒÏë¸ÄΪ×î´óÎļþ´óС²»Ê ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ