im trying to update a column using jsp
here i want my count column value to be updated as zero
count = 0
how can i do that. through this code value is not updating
       
       String code = request.getParameter("code");
       Connection conn = null;
       Statement st=null;
       ResultSet rs = null;
       PreparedStatement ps = null;
       int count = 0;
   
       try{
	     conn = DataBaseConnection.initializeDatabase();
	     
        String query1 = null;
	     conn.setAutoCommit(false);
         query1 = "update employee set count = ? where code= '" +code+ "' ";
         	ps = conn.prepareStatement(query1);
         	ps.setInt(1, count);
            ps.executeUpdate();
            }
            catch (Exception e) {
            e.printStackTrace();
            }
here is my record in db
           employee table
           CODE          VARCHAR2(12) 
           COUNT          NUMBER(3)

"update employee set count = ? where code= ' + code + ' ";

"update employee set count = ? where code= '" + code + "' ";

"update employee set count = ? where code= 'xyz' ";

query1 = "update employee set count = ? where code= ?";
ps = conn.prepareStatement(query1);
ps.setInt(1, count);
ps.setString(2, code);