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ʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»
ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡
¹Ø×¢¡«¡«
Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......