dear singgh I've tried to user the excuteUpdate but the errors appear detail is
java.sql.SQLException: Can not issue executeUpdate() for SELECTs at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2320) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2280) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2265) do you have any suggestion? thanks you very much 2009/12/8 Avlesh Singh <avl...@gmail.com> > Use #executeUpdate instead. > > Cheers > Avlesh > > On Tue, Dec 8, 2009 at 11:37 AM, Nguyen Xuan Son <yama...@gmail.com> > wrote: > > > sorry saini but i dont see any different from your answer > > thank you > > > > 2009/12/8 Sushim Saini <sushimsa...@gmail.com> > > > > > hi Nguyen Xuan Son > > > use > > > pstmtname.executeQuery() instead of pstmtname.executeQuery(); > > > > > > On Tue, Dec 8, 2009 at 11:29, Nguyen Xuan Son <yama...@gmail.com> > wrote: > > > > > > > dear all > > > > I've written > > > > Connection conn = null; > > > > PreparedStatement pstmtname = null; > > > > pstmtname = conn.prepareStatement(sql); > > > > sql = "UPDATE tbl_content_admin_accounts SET CA_PASSWORD = ? WHERE > > > ROW_ID > > > > = > > > > " + UserID; > > > > pstmtname.setString(1, "123456"); > > > > pstmtname.executeQuery(); > > > > > > > > there is no error appear but nothing is changed in the database > > > > do you have any suggestion? > > > > thank you very much > > > > > > > > -- > > > > > ======================================================================= > > > > Ritsumeikan University, Asia JinZai Project > > > > Master of Information Science > > > > Nguyen Xuan Son > > > > > > > > Add : Japan, Shiga-Ken, Kusatsu-Shi, Kasayama 3choume 1-18 > > > > ShiteiHaimu > > > > Rien, Room 103 > > > > Tel/Fax : 81-(0)90-3976 2246 > > > > Email : nr000...@ed.ritsumei.ac.jp > > > > Mobile : 81-(0)90-3976 2246 URL : http://www.ritsumei.jp > > > > > ======================================================================= > > > > > > > > > > > > > > > > -- > > > -- > > > Sushim Saini > > > > > > > > > > > -- > > ======================================================================= > > Ritsumeikan University, Asia JinZai Project > > Master of Information Science > > Nguyen Xuan Son > > > > Add : Japan, Shiga-Ken, Kusatsu-Shi, Kasayama 3choume 1-18 > > ShiteiHaimu > > Rien, Room 103 > > Tel/Fax : 81-(0)90-3976 2246 > > Email : nr000...@ed.ritsumei.ac.jp > > Mobile : 81-(0)90-3976 2246 URL : http://www.ritsumei.jp > > ======================================================================= > > > -- ======================================================================= Ritsumeikan University, Asia JinZai Project Master of Information Science Nguyen Xuan Son Add : Japan, Shiga-Ken, Kusatsu-Shi, Kasayama 3choume 1-18 ShiteiHaimu Rien, Room 103 Tel/Fax : 81-(0)90-3976 2246 Email : nr000...@ed.ritsumei.ac.jp Mobile : 81-(0)90-3976 2246 URL : http://www.ritsumei.jp =======================================================================