Jsp中用什么实现把数据库中的smalldatetime类型的字段读到页面上
数据库中的CSSJ(出生时间)为smalldatetime类型
ZXF为int类型
请问:怎么才能把该字段的值读到页面上?
<%@ page import="java.util.*" %>
Date cssj = new Date();
cssj = rs.getDate("CSSJ");
out.print(cssj);
int zxf=Integer.paresInt(rs.getString("ZXF"));
out.print(zxf);
上面代码为什么都报错?请各位多多指教?
问题点数:20、回复次数:8Top
1 楼doway(john)回复于 2006-03-05 16:56:17 得分 15
<%@ page import="java.util.*" %>
Date cssj = rs.getDate("CSSJ");
out.print(cssj);
int zxf=rs.getInt("ZXF"));
out.print(zxf);Top
2 楼cj_0910(朝阳)回复于 2006-03-05 18:45:27 得分 0
这样也照样报错的Top
3 楼cj_0910(朝阳)回复于 2006-03-05 18:49:03 得分 0
报这个错
C:\Tomcat 4.1\work\Standalone\localhost\examples\jsp\XSCJ\xsxx_jsp.java:97: reference to Date is ambiguous, both class java.util.Date in java.util and class java.sql.Date in java.sql match
Date cssj = rs.getDate("CSSJ");
Top
4 楼doway(john)回复于 2006-03-05 19:42:44 得分 0
java.util.Date
java.sql.Date
这两个东西楼主可能都 import 了。后者是前者的子类,因此两个里边挑一个用就可以了。
Top
5 楼cj_0910(朝阳)回复于 2006-03-05 21:58:48 得分 0
<%@ page language="java" import="java.sql.*"%>
<%@ page import="java.lang.*" errorPage="" %>
<%@ page import="java.util.Date"%>
<%Date cssj = rs.getDate("CSSJ");
out.print(cssj);
%>
还是有问题啊,报错
Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: [Microsoft][ODBC SQL Server Driver]无效的描述符索引
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:248)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:289)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:240)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260)
Top
6 楼doway(john)回复于 2006-03-05 23:59:00 得分 0
<%@ page import="java.util.Date"%>
这一句要删除。
Top
7 楼huguangwu(追风少年)回复于 2006-03-06 00:59:07 得分 5
呵呵,来迟了,楼上正解
去掉<%@ page import="java.util.Date"%>Top
8 楼cj_0910(朝阳)回复于 2006-03-06 12:59:28 得分 0
我昨天去掉<%@ page import="java.util.Date"%>也试过了也不行,所以我也很迷茫.
假如对一个Date类型的字段初始话是不是可以Date cssj=new Date('0000-00-00');
Top




