sorry use executeUpdate On Tue, Dec 8, 2009 at 11:53, Nguyen Xuan Son <yama...@gmail.com> wrote:
> 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 > ======================================================================= > -- -- Sushim Saini