类型不匹配:无法从java.util.Date转换为java.sql.Date [英] Type mismatch: cannot convert from java.util.Date to java.sql.Date
问题描述
我正在尝试让我的代码与代码中的SimpleDateFormat类一起使用.有人知道为什么吗?祝朱莉有美好的一天
I am trying to get my code to work with the SimpleDateFormat class here in the code. Does anybody knows why? Have a nice day from Julie
当我在导入位置运行代码时:导入java.util.Date.我得到了错误: 这些行中的日期类型不明确":
When I run the code where I have imported: import java.util.Date. I get the error: "The type Date is ambiguous" in the lines:
Date startDate = format.parse(req.getParameter("startDate"));
Date endDate = format.parse(req.getParameter("endDate"));
当我在导入位置运行代码时:import java.sql.Date;我收到错误消息:
When I run the code where I have imported: import java.sql.Date; I get the error:
Date startDate = format.parse(req.getParameter("startDate"));
Date endDate = format.parse(req.getParameter("endDate"));
类型不匹配:无法从java.util.Date转换为java.sql.Date"
"Type mismatch: cannot convert from java.util.Date to java.sql.Date"
import java.sql.Date;
package WorkPackage;
import java.io.*;
import java.sql.*;
import java.text.SimpleDateFormat;
import javax.servlet.*;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.*;
import java.util.*;
import java.util.Date.*;
public void doPost(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException{
String connectionURL = "jdbc:mysql://localhost/NekiWork";
Connection connection=null;
//String startDate = req.getParameter("startDate");
//String endDate= req.getParameter("endDate");
try {
//Load database driver
Class.forName("com.mysql.jdbc.Driver");
//Connection to the database
connection = DriverManager.getConnection(connectionURL, "root", "");
//Getting the data from database
String sql = "SELECT *, (Day_hours + (Day_minutes / 60)) AS Allday_hours FROM Workdata "
+ "WHERE Date = startdate = ? AND endDate = ? ";
PreparedStatement pst = connection.prepareStatement(sql);
//Date startDate;
SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd");
Date startDate = format.parse(req.getParameter("startDate"));
Date endDate = format.parse(req.getParameter("endDate"));
pst.setDate(1,startDate);
pst.setDate(2, endDate);
推荐答案
java.util.Date
和 java.sql.Date
是不同的.数据库仅接受java.sql.Date
.
为此,您需要将java.util.Date
转换为java.sql.Date
.
java.util.Date
and java.sql.Date
are different. Database accepts only java.sql.Date
.
For that, you need to convert java.util.Date
into java.sql.Date
.
尝试一下:
java.util.Date util_StartDate = format.parse( req.getParameter("startDate") );
java.sql.Date sql_StartDate = new java.sql.Date( util_StartDate.getTime() );
现在,您可以使用此sql_StartDate
通过Prepared语句设置参数值.
Now you can use this sql_StartDate
to set parameter values using prepared statement.
pst.setDate( 1, sql_StartDate );
在其他特定于sql的日期上使用相同的过程,以与jdbc一起使用.
Use the same procedure on other sql specific dates to use with jdbc.
这篇关于类型不匹配:无法从java.util.Date转换为java.sql.Date的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!