数据库 sql server 2000获得时间的代码
SimpleDateFormat sdf=new SimpleDateFormat("yyyyMMdd");
String dates=sdf.format(new Date());
插入数据库的语句
String s="insert into regis_tb values('"+firstname+"','"+surname+"','"+authcode+"','"+dates+"')";
产生的异常信息:
insert into regis_tb values('admin','admin','1000000000000004','20100327')
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]对象名 'regis_tb' 无效。
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSExecuteRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.postImplExecute(Unknown Source)
at com.microsoft.jdbc.base.BasePreparedStatement.postImplExecute(Unknown Source)
SimpleDateFormat sdf=new SimpleDateFormat("yyyyMMdd");
String dates=sdf.format(new Date());
插入数据库的语句
String s="insert into regis_tb values('"+firstname+"','"+surname+"','"+authcode+"','"+dates+"')";
产生的异常信息:
insert into regis_tb values('admin','admin','1000000000000004','20100327')
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]对象名 'regis_tb' 无效。
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSExecuteRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.postImplExecute(Unknown Source)
at com.microsoft.jdbc.base.BasePreparedStatement.postImplExecute(Unknown Source)
insert into regis_tb values('admin','admin','1000000000000004','20100327')
插入时正常的
从报错可以看出你的代码执行db操作的时候找不到regis_tb这个表这个时候就不要再去分析日期字段了,很大可能原因不在它
而有可能是你本地链接db有问题,或连库不正确造成的要是以上两点都排除,那么把你db操作的代码贴出来