blocks|key|660957|text|你试过cal.getTime()吗？这将获取日期表示。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|660958|您可能还想看看javadoc。|660959|entityMap^0|3|D|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|M|8|@]|D|@]|E|$]]|$1|H|3|-4|5|6|7|N|8|@]|D|@]|E|$]]]|I|$]]

Did you try <code>cal.getTime()</code>? This gets the date representation.

You might also want to look at the javadoc.

blocks|key|660980|text|使用stmt.setDate(1,+new+java.sql.Date(cal.getTimeInMillis()))|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|660981|entityMap^0|2|1L|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

Use <code>stmt.setDate(1, new java.sql.Date(cal.getTimeInMillis()))</code>

blocks|key|661020|text|转换很容易，设置日期和时间就有点麻烦了。下面是一个例子：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|661021|Calendar+cal+=+Calendar.getInstance();
cal.set(Calendar.YEAR,+2000);
cal.set(Calendar.MONTH,+0);
cal.set(Calendar.DAY_OF_MONTH,+1);
cal.set(Calendar.HOUR_OF_DAY,+1);
cal.set(Calendar.MINUTE,+1);
cal.set(Calendar.SECOND,+0);
cal.set(Calendar.MILLISECOND,+0);
stmt.setDate(1,+new+java.sql.Date(cal.getTimeInMillis()));|code-block|syntax|javascript|661022|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Converting is easy, setting date and time is a little tricky. Here's an example:

<pre><code>Calendar cal = Calendar.getInstance();
cal.set(Calendar.YEAR, 2000);
cal.set(Calendar.MONTH, 0);
cal.set(Calendar.DAY_OF_MONTH, 1);
cal.set(Calendar.HOUR_OF_DAY, 1);
cal.set(Calendar.MINUTE, 1);
cal.set(Calendar.SECOND, 0);
cal.set(Calendar.MILLISECOND, 0);
stmt.setDate(1, new java.sql.Date(cal.getTimeInMillis()));
</code></pre>

blocks|key|661064|text|我发现这段代码可以工作：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|661065|SimpleDateFormat+sdf+=+new+SimpleDateFormat("yyyy+MMM+dd+HH:mm:ss");++++
Calendar+calendar+=+new+GregorianCalendar(2013,0,31);
System.out.println(sdf.format(calendar.getTime()));++|code-block|syntax|javascript|661066|您可以在本教程中找到其余部分：|661067|http://www.mkyong.com/java/java-date-and-calendar-examples/|offset|length|661068|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|0|0|1N|0|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|U|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|V|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|W|8|@]|9|@$K|X|L|Y|1|Z]]|A|$]]|$1|M|3|-4|5|6|7|10|8|@]|9|@]|A|$]]]|N|$O|$5|P|Q|R|A|$S|J]]]]

I found this code works: 

<pre><code>SimpleDateFormat sdf = new SimpleDateFormat("yyyy MMM dd HH:mm:ss"); 
Calendar calendar = new GregorianCalendar(2013,0,31);
System.out.println(sdf.format(calendar.getTime())); 
</code></pre>

you can find the rest in this tutorial: 
<a href="http://www.mkyong.com/java/java-date-and-calendar-examples/" rel="nofollow">http://www.mkyong.com/java/java-date-and-calendar-examples/</a>

blocks|key|446651|text|下面是一种将Calendar值转换为Date实例的简单方法。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|446652|Calendar+C+=+new+GregorianCalendar(1993,9,21);

Date+DD+=+C.getTime();

System.out.println(DD);|code-block|syntax|javascript|446653|entityMap^0|6|8|I|4|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]|$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|R|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|S|8|@]|D|@]|E|$]]]|L|$]]

Here is a simple way to convert <code>Calendar</code> values into <code>Date</code> instances.

<pre><code>Calendar C = new GregorianCalendar(1993,9,21);

Date DD = C.getTime();

System.out.println(DD);
</code></pre>

blocks|key|661127|text|stmt.setDate(1,+new+java.sql.Date(cal.getTime().getTime()));|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|661128|entityMap^0|0|1O|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

<code>stmt.setDate(1, new java.sql.Date(cal.getTime().getTime()));</code>

blocks|key|661132|text|Calendar+cal+=+Calendar.getInstance();+//This+to+obtain+today's+date+in+our+Calendar+var.

java.sql.Date+date+=+new+Date+(cal.getTimeInMillis());|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|661133|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>Calendar cal = Calendar.getInstance(); //This to obtain today's date in our Calendar var.

java.sql.Date date = new Date (cal.getTimeInMillis());
</code></pre>

<pre><code>Calendar cal;
String sql = "INSERT INTO ttable (dt) values (?);"
//dt is a dateTime field in ttable

PreparedStatement stmt = connection.prepareStatement(sql);

stmt = setDate(1,cal); //not working

stmt.execute();
stmt.close();
</code></pre>

I would like to convert cal to a Date type to insert into table.

How to convert Calendar to java.sql.Date in Java?

Calendar cal;String sql = "INSERT INTO ttable (dt) values (?);"//dt is a dateTime field in ttablePreparedStatement stmt = connection.prepareStatement(sql);stmt ...

问如何在Java中将日历转换为java.sql.Date？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在Java中将日历转换为java.sql.Date？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在Java中将日历转换为java.sql.Date？
EN