java.util.Date cannot be cast to java.sql.Date 将date类型的数据存入数据库
来源:互联网 发布:慈溪行知职业 编辑:程序博客网 时间:2024/05/22 10:22
页面接受的date是java.util.date,放入数据库要用java.sql.date,实现两者之间的转化:
1.user.java
package model;
import java.util.Date;
public class User {
public String username,password,address,email;
Date birth;
public User(){
}
public User(String username, String password, String address, String email, Date birth) {
super();
this.username = username;
this.password = password;
this.address = address;
this.email = email;
this.birth = birth;
}
//getter,setter方法。。略
}
2.add.jsp:注册页面(我写的是struts2项目,但是将date放入数据库的例子是常见的)
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<!-- struts2标签库调用声明 -->
<%@taglib prefix="s" uri="/struts-tags" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>注册</title>
</head>
<body>
<s:form action="add" methods="post">
<s:fielderror/>
<table width="60%" height="76" border="0">
<s:textfield name="user.username" label="用户名"/>
<s:password name="user.password" label="密 码"/>
<s:textfield name="user.email" label="邮 箱"/>
<s:textfield name="user.address" label="地 址"/>
<s:textfield name="user.birth" format="yyyy-MM-dd" nice="false" label="出生日期"/>
<!--<s:textfield name="user.birth" label="出生日期"/>-->
<s:submit value="注册" align="center"/>
</table>
</s:form>
</body>
</html>
3.AddAction.java
package com;
import com.opensymphony.xwork2.ActionSupport;
import java.util.*;
import dao.AddDao;
import model.User;
public class AddAction extends ActionSupport{
private static String FORWARD=null;//页面导向
private User user =new User();
//private User user;
public User getUser() {
return user;
}
public void setUser(User user) {
this.user = user;
}
public String execute() throws Exception{
AddDao dao=new AddDao();
User u=new User();
u=dao.findName(this.user.getUsername());
if(u.getUsername()==null){
System.out.println("注册成功");
// System.out.println(this.user.getUsername());
// System.out.println(u.getUsername());
// System.out.println(u.getBirth());
dao.add(this.user);//在AddDao中
FORWARD="success";
}
else{
System.out.println("注册失败");
FORWARD="input";
}
return FORWARD;
}
}
4.AddDao.java
package dao;
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.PreparedStatement;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import model.User;
public class AddDao {
Connection con;
String driver="com.mysql.jdbc.Driver";
String url="jdbc:mysql://localhost:3306/struts2";
public AddDao(){
try{
Class.forName(driver);
this.con=DriverManager.getConnection(url,"root","root");
}catch(Exception e){
e.printStackTrace();
}
}
/*
public void add(User user){
String sql="INSERT INTO user(username,password,address,email,birth) VALUES ( ?, ?, ?, ? ,?)";
try {
PreparedStatement cmd=this.con.prepareStatement(sql);
cmd.setString(1, user.getUsername());
cmd.setString(2, user.getPassword());
cmd.setString(3, user.getAddress());
cmd.setString(4, user.getEmail());
cmd.setDate(5, new java.sql.Date(user.getBirth().getTime()));//重点
cmd.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
...
}
- java.util.Date cannot be cast to java.sql.Date 将date类型的数据存入数据库
- java.util.Date cannot be cast to java.sql.Timestamp
- java.util.Date cannot be cast to java.sql.Timestamp
- java.lang.String cannot be cast to java.util.Date
- java.lang.String cannot be cast to java.util.Date
- java.sql.Timestamp cannot be cast to java.sql.Date
- java.sql.Timestamp cannot be cast to java.sql.Date
- java.sql.Timestamp cannot be cast to java.sql.Date的问题
- 将Date类型的数据存入数据库
- java.util.date和java.sql.date在存入数据库的区别
- java.util.Date to java.sql.Date
- java中报错java.sql.Timestamp cannot be cast to java.sql.Date
- java.sql.Timestamp cannot be cast to java.sql.Date求助
- java.lang.ClassCastException: java.lang.Long cannot be cast to java.util.Date at org.hibernate.type.TimestampType.deepCopyNotNul
- 用java存oracle数据库的date类型精确到秒【java.sql.Date 和java.util.Date的区别】
- java.sql.Date数据库日期类型计算及与java.util.Date的转换
- jdbc的Date类型处理,解决java.util.date与java.sql.date的时间数据丢失
- JAVA java.sql.Date、java.util.Date与数据库中的Date字段的转换方法
- 【DP】TEST20170511
- 基数排序
- java基础零碎练手<一>
- Python网络爬虫与信息提取(中国大学mooc)
- 基于Arduino的GPS数据解析程序
- java.util.Date cannot be cast to java.sql.Date 将date类型的数据存入数据库
- c++中的某些重点知识点
- SpringMVC+ajaxFileUpload.js实现文件上传
- 均值漂移
- 微型技术报告(3)
- URL.createObjectURL和URL.revokeObjectURL
- 如何调用内核未导出的函数
- LINUX内核分析第一周学习总结:计算机是如何工作的?
- windows下安装centOS7遇到的几个问题