往数据库写如一个时间类型的错误
我想通过jsp页面往数据库插入一个时期,Access数据库里的列名是time,类型是文本
下面是jsp代码
<%!
String getStr(String str) throws Exception
{
if(str.length()==0)
return null;
String temp=str;
byte[] temp_p=temp.getBytes("8859_1");
return new String(temp_p);
}
%>(转换函数)
<%
int year=0;
int month=0;
int day=0;
int hour=0;
int minute=0;
int second=0;
String time;
GregorianCalendar calendar;
calendar=new GregorianCalendar();
year=calendar.get(calendar.YEAR);
month=calendar.get(calendar.MONTH)+1;
day=calendar.get(calendar.DAY_OF_MONTH);
hour=calendar.get(calendar.HOUR_OF_DAY);
minute=calendar.get(calendar.MINUTE);
second=calendar.get(calendar.SECOND);
time=year+"年"+month+"月"+day+"日"+hour+":"+minute+":"+second;
time=getStr(time);
Connection conn=guestbook.GetConn();//通过(bean)连接数据库
Statement sqlrs= conn.createStatement() ;
String sql="insert into Guestbook(username,tx,email,url,qq,content,ip,sex,time) values('"+username+"','"+tx+"','"+email+"','"+url+"','"+qq+"','"+content+"','"+ip+"','"+sex+"','"+time+"')";
sqlrs.executeUpdate(sql);
response.sendRedirect("index.jsp");
%>
编译提示总是SQL错误,请各位多多指教!