stmt = conn.prepareStatement("update counter set today=? first=first+1 where date=?");
stmt.setInt(1, today);
stmt.setDate(2, new java.sql.Date(calendar.getTimeInMillis()));
stmt.execute();

how can find MYSQL filed data.
sample:rs="??????"

how can I get every note. in MYSQL.

if(!rs.next()); "rs" it need go find note.

or <%=rs("name")%> they need rs log data.

sql="update counter where date=?";
PreparedStatement stmt=con.prepareStatement(sql);
stmt.setDate(1, new java.sql.Date(calendar.getTimeInMillis()));
rs=stmt.execute();
up red "rs" can't use. it will display "An error occurred at line: 24 in the jsp file: /count.jsp
Type mismatch: cannot convert from boolean to ResultSet"