jsp中提交数据到ORACLE数据库,SQL语句怎么写
这是截取的一段代码,主要帮我看看这sql写得对不?A_JSD是表,后面的括号内的是数据段名字,在后面便是数据值
request.setCharacterEncoding( "GB2312 ");
response.setContentType( "text/html;charset=GB2312 ");
PrintWriter out = response.getWriter();
String para=request.getParameter( "JSD_BH ");
String para1=request.getParameter( "HW_CODE ");
String para2=request.getParameter( "CZGC ");
String para3=request.getParameter( "YARDPOS ");
String para4=request.getParameter( "JS ");
String para5=request.getParameter( "POS_VIRTUAL ");
String para6=request.getParameter( "JSD_DATE ");
String para7=request.getParameter( "GONGBAN ");
String para8=request.getParameter( "MARK_ACTUAL ");
String para9=request.getParameter( "OPID ");
String para0=request.getParameter( "CANGD ");
String para11=request.getParameter( "PACKAGE ");
String sql= "INSERT INTO A_JSD "+
"( JSD_BH, HW_CODE ,CZGC,YARDPOS,JS,POS_VIRTUAL, " +
"JSD_DATE,GONGBAN,MARK_ACTUAL,TAKE_COMPANY,DIRECT_FLOW " +
"THDH,BEIZHU,OPID,CANGD,PACKAGE,ZL,DZ_SOURCE_CODE) " +
" VALUES ( 'para ', 'para1 ', 'para2 ', 'para3 ', 'para4 ', 'para5 ', 'para6 ', 'para7 ', 'para8 ', 'null ', 'null ', 'null ', 'null ', 'para9 ', 'para0 ', 'para11 ', 'null ', 'null ') ";
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
String result= " ";
String anItem=null;
commonServlet.initial();
commonServlet.executeUpdate(sql);
out.println( "Success Insert Into A_JSD... ");
try{
rs.close();
stmt.close();
conn.close();
}catch(Exception e){}
------解决方案-------------------- " VALUES ( ' " + para + " ', ' " + para1 + " ', ' " + para2+ " ', ' "+.......+para11+ " ', ', ' ', ' ') "
null 是为空直接用 ' '就可以了