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 > ======================================================================= >