TAG:
|
<% //java.text.DateFormat df= new java.text.SimpleDateFormat("yyyy-MM-dd");//格 式化成年月日的格式 String csrq=request.getParameter("select8")+"-"+request.getParameter("select9")+"-" +request.getParameter("select10"); String ht_begin=request.getParameter("select5")+"-"+request.getParameter("select6") +"-"+request.getParameter("select7"); String ht_end=request.getParameter("select11")+"-"+request.getParameter("select12") +"-"+request.getParameter("select13"); //java.util.Date date_csrq = df.parse(csrq);//把字符串格式转换成日期格式 //java.util.Date date_begin = df.parse(ht_begin); //java.util.Date date_end = df.parse(ht_end); //java.util.Date date1 = new java.util.Date();取的系统时间 //java.text.DateFormat df1 = new java.text.SimpleDateFormat("yyyy-MM-dd");// 格式化成年月日的格式 //String sDate = df1 .format(date1); 把日期格式转换成字符串格式 Class.forName("oracle.jdbc.driver.OracleDriver").newInstance(); String url="jdbc:oracle:thin:@guidb:1521:oradb"; //oradb为数据库的SID String user="system "; String password="guiqi728"; //载入驱动程式类别 Connection con = DriverManager.getConnection(url,user,password); //建立资料库连线 Statement stmt = con.createStatement(); //建立Statement物件, 并设定记录指标类型为可前後移动 String strSQL = "insert into employee_basic(em_num,em_name,em_email,em_sex,em_birthday,"+ "em_native,em_nation,em_idcard,em_clan,em_marriage,em_el,em_begin,em_end) "+ "values (''"+request.getParameter("textfield1")+"'',''"+request.getParameter("textfield 2")+"'',"+ "''"+request.getParameter("textfield6")+"'',''"+request.getParameter("select")+ "'',"+ "''+to_date(csrq,''yyyy-mm-dd'')+'',''"+request.getParameter("textfield4")+"'',"+ "''"+request.getParameter("textfield3")+"'',''"+request.getParameter("textfield 5")+"'',"+ "''"+request.getParameter("select2")+"'',''"+request.getParameter("select4")+"'' ,"+ "''"+request.getParameter("select3")+"'',''+to_date(ht_begin,''yyyy-mm-dd'')+'',''+ to_date(ht_end,''yyyy-mm-dd'')+'')"; //欲执行查询的SQL叙述 stmt.executeUpdate(strSQL); //rs.close(); //关闭ResultSet物件 stmt.close(); //关闭Statement物件 con.close(); //关闭Connection物件 出现如下错误: 500 Servlet Exception java.sql.SQLException: ORA-00917: 缺少逗号 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891) at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1093) at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2047 ) at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java :2709) at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:796) at _luru__jsp._jspService(/luru.jsp:54) at com.caucho.jsp.JavaPage.service(JavaPage.java:75) at com.caucho.jsp.Page.subservice(Page.java:497) at com.caucho.server.http.FilterChainPage.doFilter(FilterChainPage.java:182) at com.caucho.server.http.Invocation.service(Invocation.java:315) at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135) at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:246) at com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:163) at com.caucho.server.TcpConnection.run(TcpConnection.java:139) at java.lang.Thread.run(Thread.java:536) 请问怎么办?还有如何判断已成功插入一条记录？谢谢!! (GDB) |