Olha so pessoal, segue abaixo o jsp que deveria gravar no bd a data digitada:
<%@page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*" errorPage="" %>
<%@page import="java.text.SimpleDateFormat"%>
<%@page import="java.text.DateFormat"%>
<%
Connection conn = null;
PreparedStatement stmt = null;
ResultSet rs = null;
try{
Class c = Class.forName("com.mysql.jdbc.Driver");
}
catch(Exception e){
System.out.println("Erro: " + e);
}
try{
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/testedata","xxxxx","xxxxx");
}
catch(SQLException e){
System.out.println("Erro: " + e);
}
try{
stmt = conn.prepareStatement("insert into data(dataserv) VALUES (?)");
SimpleDateFormat f = new SimpleDateFormat("dd/mm/yyyy");
Date data = f.parse(request.getParameter("dataserv"));
stmt.setDate(1, data);
stmt.executeUpdate();
stmt.close();
conn.close();
}
catch(Exception e){
out.println(data);
out.println(e);
}
%>
e retorna o seguinte erro:
An error occurred at line: 6 in the jsp file: /web/testeData.jsp
Generated servlet error:
Type mismatch: cannot convert from java.util.Date to java.sql.Date
An error occurred at line: 6 in the jsp file: /web/testeData.jsp
Generated servlet error:
data cannot be resolved
O que pode estar errado?