MySQL in Java - INSERT and DELETE statements not working properly -

• there 2 tables chat_users , chat_lines.
• insert , select work on chat_user
• update on chat_user not working
• insert chat_lines doesn't work either

source listing chat_user_model.java

package model; import beans.chatlinebeans; import beans.chatuserbeans; import java.security.timestamp; import java.sql.connection; import java.sql.drivermanager; import java.sql.preparedstatement; import java.sql.resultset; import java.sql.sqlexception; import java.util.logging.level; import java.util.logging.logger; /** * * @author user */ public class chat_user_model extends dbconnection { public static void add_user(chatuserbeans user ) throws classnotfoundexception { try { connection conn = createconnection(); preparedstatement s; s = conn.preparestatement ( "insert chat_users (name, gravatar) values(?,?)"); s.setstring (1,user.getusername()); s.setstring (2, user.getgravatar()); int count = s.executeupdate (); s.close (); conn.close(); //system.out.println (count + " rows inserted"); } catch (sqlexception ex) { logger.getlogger(chat_user_model.class.getname()).log(level.severe, null, ex); } } public static chatuserbeans find_user(string name ) { chatuserbeans user=new chatuserbeans(); try { connection con = createconnection(); preparedstatement stmt = con.preparestatement("select * chat_users name=? "); stmt.setstring(1, name); resultset result= stmt.executequery(); while(result.next()) { user.setusername(result.getstring("name")); user.setgravatar(result.getstring("gravatar")); } stmt.close(); stmt.close(); con.close(); } catch (sqlexception ex) { logger.getlogger(chat_user_model.class.getname()).log(level.severe, null, ex); } return user ; } public static void add_line(chatlinebeans line ) throws classnotfoundexception { try { connection conn = createconnection(); preparedstatement s; s = conn.preparestatement ( "insert chat_lins (aurther, gravatar,text) values(?,?,?)"); s.setstring (1,line.getauther()); s.setstring (2, line.getgravatar()); s.setstring (3, line.gettext()); int count = s.executeupdate (); s.close (); conn.close(); //system.out.println (count + " rows inserted"); } catch (sqlexception ex) { logger.getlogger(chat_user_model.class.getname()).log(level.severe, null, ex); } } public static void delete_user(string name ) throws classnotfoundexception { try { connection conn = createconnection(); preparedstatement s; s = conn.preparestatement ( "dlete chat_users name=?"); s.setstring (1,name); int count = s.executeupdate (); s.close (); conn.close(); } catch (sqlexception ex) { logger.getlogger(chat_user_model.class.getname()).log(level.severe, null, ex); } } } 

and connection file

 package model; import java.sql.connection; import java.sql.drivermanager; import java.sql.sqlexception; import java.util.logging.level; import java.util.logging.logger; public class dbconnection { private static string hostname = "localhost"; private static string port = "3306"; private static string dbname ="120623085702"; private static string username = "root"; private static string password=""; public static connection createconnection(){ try { class.forname("com.mysql.jdbc.driver"); string url = "jdbc:mysql://" + hostname + ":" + port + "/" + dbname; system.out.println(url); connection con = drivermanager.getconnection(url,username,password); return con; } catch (sqlexception ex) { logger.getlogger(dbconnection.class.getname()).log(level.severe, null, ex); } catch (classnotfoundexception ex) { logger.getlogger(dbconnection.class.getname()).log(level.severe, null, ex); } return null; } } 

any suggestion how solve issue.

thanks in advance.

you misspelled delete in query. cause of delete statement not working. reason you're not seeing error might logging's not set correctly. if that's case, going wrong insert statement, , wouldn't know (e.g. columns/tables missing, accidentally inserting null non-nullable column). try not catching sqlexceptions, , see if see errors then.