求教！有关Date begintime = rs.getDate ( "begintime" )的有关问题
日期：2014-05-17 浏览次数：20648 次
求教！有关Date begintime = rs.getDate ( "begintime" )的问题
首先我是想实现修改的功能，后来显示出Value '0000-00-00' can not be represented as java.sql.Date这样一个问题，按照网上教的方法在连接数据库语句后面添加zeroDateTimeBehavior=convertToNull，结果所有date类型的值都为0000-00-00了，怎么办呢?其实不是很明白网上这个方法的用意，求指教！下面是修改页面和显示页面的代码：
update_cooperation.jsp：
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>无标题文档</title>
</head>
<body>
<%
Class.forName("com.mysql.jdbc.Driver").newInstance();
String url= "jdbc:mysql://localhost:3306/graduationproject?user=root&password=123&useUnicode=true&characterEncoding=GB2312&zeroDateTimeBehavior=convertToNull";
Connection connection=DriverManager.getConnection(url);
Statement statement = connection.createStatement();
String number=request.getParameter("number");
String sql="select * from cooperations where number='"+number+"'";
ResultSet rs = statement.executeQuery(sql);
%>
<table width="1572">
<tr>
<th width="169" scope="col"> 起始时间</th>
<th width="169" scope="col">结束时间</th>
<th width="166" scope="col">物料</th>
<th width="168" scope="col">项目编号</th>
<th width="169" scope="col"> 项目名称</th>
<th width="167" scope="col">ICP</th>
<th width="168" scope="col"> 供应商名称</th>
<th width="169" scope="col">合作价格</th>
<th width="169" scope="col">状态</th>
</tr>
</table>
<% while(rs.next()) {%>
<form id="form1" name="form1" method="post" action="deal_update_cooperation.jsp">
<table width="1698">
<tr>
<th width="168" height="49" scope="col">
<div align="center">
<input type="hidden" name="number" value="<%=request.getParameter("number")%>"/>
<input type="text" name="begintime" value="<%=rs.getTime("begintime")%>" />
</a></div></th>
<th width="168" scope="col">
<div align="center">
<input type="text" name="endtime" value="<%=rs.getTime("endtime")%>" />
</div></th>
<th width="168" scope="col">
<div align="center">
<input type="text" name="material" value="<%=rs.getString("material")%>" />
</div></th>
<th width="168" scope="col"><div align="center">
<input name="p_number" type="text" value="
首先我是想实现修改的功能，后来显示出Value '0000-00-00' can not be represented as java.sql.Date这样一个问题，按照网上教的方法在连接数据库语句后面添加zeroDateTimeBehavior=convertToNull，结果所有date类型的值都为0000-00-00了，怎么办呢?其实不是很明白网上这个方法的用意，求指教！下面是修改页面和显示页面的代码：
update_cooperation.jsp：
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>无标题文档</title>
</head>
<body>
<%
Class.forName("com.mysql.jdbc.Driver").newInstance();
String url= "jdbc:mysql://localhost:3306/graduationproject?user=root&password=123&useUnicode=true&characterEncoding=GB2312&zeroDateTimeBehavior=convertToNull";
Connection connection=DriverManager.getConnection(url);
Statement statement = connection.createStatement();
String number=request.getParameter("number");
String sql="select * from cooperations where number='"+number+"'";
ResultSet rs = statement.executeQuery(sql);
%>
<table width="1572">
<tr>
<th width="169" scope="col"> 起始时间</th>
<th width="169" scope="col">结束时间</th>
<th width="166" scope="col">物料</th>
<th width="168" scope="col">项目编号</th>
<th width="169" scope="col"> 项目名称</th>
<th width="167" scope="col">ICP</th>
<th width="168" scope="col"> 供应商名称</th>
<th width="169" scope="col">合作价格</th>
<th width="169" scope="col">状态</th>
</tr>
</table>
<% while(rs.next()) {%>
<form id="form1" name="form1" method="post" action="deal_update_cooperation.jsp">
<table width="1698">
<tr>
<th width="168" height="49" scope="col">
<div align="center">
<input type="hidden" name="number" value="<%=request.getParameter("number")%>"/>
<input type="text" name="begintime" value="<%=rs.getTime("begintime")%>" />
</a></div></th>
<th width="168" scope="col">
<div align="center">
<input type="text" name="endtime" value="<%=rs.getTime("endtime")%>" />
</div></th>
<th width="168" scope="col">
<div align="center">
<input type="text" name="material" value="<%=rs.getString("material")%>" />
</div></th>
<th width="168" scope="col"><div align="center">
<input name="p_number" type="text" value="
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
