AccessÊý¾Ý¿âupdateÓï¾äÎÊÌ⣬´óϺÃÇ°ïæ¿´¿´

public void UpDataComm() {
        ResultSet rs = null;
        Connection conn = null;
        PreparedStatement ps = null;
        Statement st = null;
        String sql = "update test set number=4 where seq=1";

        conn = GetConnUtil.getConn();//дµÄ»ñÈ¡ConnectionµÄ·½·¨£¬Ã»ÎÊÌâ¿ÉÒÔÔÚMain·½·¨ÀïÊä³öÀ´
        try {
            st = conn.createStatement();
            ps=conn.prepareStatement(sql);
            ps.executeUpdate();//Õâ¾äÊDZ¨´íµÄÔ­Òò£¬ÎÒÓÃStatementÒ²ÊÔ¹ý£¬²»ÐÐ
        } catch (SQLException ex) {
            Logger.getLogger(GetUserResultSetFindByTypeId.class.getName()).log(Level.SEVERE, null, ex);
        }

    }
±¨´íÈçÏ£º
ÑÏÖØ: null
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] UPDATE Óï¾äµÄÓï·¨´íÎó¡£

---

Äã°ÑsqlÓï¾äÔÚaccessÀïÔËÐп´ÓÐûÓÐÎÊÌâ¡£

---

ÒýÓÃ

public void UpDataComm() {
        ResultSet rs = null;
        Connection conn = null;
        PreparedState