string sql = "update leadspeak set images=@images,content=@content,author=@author,title=@title where id=@id";
OleDbParameter[] para = new OleDbParameter[]{
new OleDbParameter("@id",leadSpeak.Id),
new OleDbParameter("@images",leadSpeak.Images),
new OleDbParameter("@content",leadSpeak.Content),
new OleDbParameter("@author",leadSpeak.Author),
new OleDbParameter("@title",leadSpeak.Title)
};
int num= DBHelper.ExecuteNonQuery(sql, CommandType.Text, para);
²»±¨´íÎ󣬵«¸üв»ÁË£¬·µ»ØµÄÊÇ0£¬Ð»Ð»£¡£¡
¸Ä³É£¿ÔÙÊÔÊÔ
C# code:
string sql = "update leadspeak set images=?,content=?,author=?,title=? where id=?";
OleDbParameter[] para = new OleDbParameter[]{
new OleDbParameter("?",leadSpeak.Id),
new OleDbParameter("?",leadSpeak.Images),
new OleDbParameter("?",leadSpeak.Content),
new OleDbParameter("?",leadSpeak.Author),
new OleDbParameter("?",leadSpeak.Title)
};
int num= DBHelper.ExecuteNonQuery(sql, CommandType.Text, para);
rt£¬ÎÒÊÔÁËÍøÉÏÖ±Á¬AccesÊý¾Ý¿âµÄ·½·¨,windowsÏÂûÓÐÎÊÌâ,µ«ÊÇÔÚlinuxϲ»ÐУ¬ËÄܸøµãÌáʾ£¿Ð»Ð»
ÄãÔõôÁ¬µÄ£¿
AccesÊý¾Ý¿â..
ÄãÔõôÁ·µÄÄØ£¿
Java code:
static String DBDRIVER = "sun.jd ......
ÎÒÊÖ¶¯Ìí¼Ó»ùÓÚCRecordSetÀàµÄÅÉÉúÀàCODBCDemoSetÀà,ÊÇÀûÓÃclass wizardÌí¼ÓµÄ¡£²¢ÇÒ¶¨ÒåÁËÒ»¸öÈ«¾Ö±äÁ¿CODBSDemoSet*m_pCommon.µ«ÊÇÎÒ³ÌÐò²»ÄÜÔËÐС£ÎÒ¸ú×ÙÁËһϣ¬µ½ÁËm_pCommon->Isopen£¨£©´¦·¢Éú´íÎ󣬣 ......