jspÎÞ·¨ÏòoracleÖвåÈëÊý¾Ý(¼±) - Java / Web ¿ª·¢
String patchno = request.getParameter("pac");
String appprov = requestgetParameter("province");
String apptime = requestgetParameter("apptime");
String developer = requestgetParameter("dvp");
String describe = requestgetParameter("dscrb");
String instruction = requestgetParameter("instruction");
String questionno = requestgetParameter("questions_use_patch");
Connection conn = null;
Statement stmt = null;
String sql = "INSERT INTO HRDF_PATCH(PK_HRDF_PATCH,PATCH_PROVINCE,FUNC_DESCRIPTION,TS,PATCH_DEVELOPERS,QUESTIONS_USE_PATCH,PATCH_INSTRUCTION) VALUES("+patchno+","+appprov+","+describe+","+apptime+","+developer+","+questionno+","+instruction+")";
//ResultSet rs = null;
try {
conn = DBConnection.getConnection();
stmt = conn.createStatement();
//Ö´ÐÐÔö¼Ó¼Ç¼²Ù×÷£º
stmt.executeUpdate(sql);
conn.commit();
}catch(Exception e){e.printStackTrace();}
finally{
if(stmt!=null) stmt.close();
if(conn!=null) conn.close();
}
³ÌÐòÄÜÔËÐУ¬µ«¾ÍÊDz岻½øÊý¾Ý£¬Ò²²»±¨Òì³££¬¸÷λ´óÏÀ£¬ÕâÊÇΪʲô°¡£¿Ð¡µÜÇó½ÌÁË¡£
ÔÚstmt.executeUpdate(sql);´¦Éè¸ö¶Ïµã£¬debugÒ»ÏÂ
ÊDz»ÊÇ×Ö·û±àÂëÎÊÌ⣬»òÕß¿ÉÄÜÊÇÖ÷¼üÖµ³åÍ»
È¥µôcommitÊÔÒ
Ïà¹ØÎÊ´ð£º
µ±ÖªµÀÒ»¸öÈÕÆÚ£¬ÈçºÎ°ÑÕâ¸öÈÕÆÚËùÔÚÑ®µÄÇ°ºóÁ½¸öÈÕÆÚÈ¡³ö
±ÈÈçÊäÈë20090905£¬¾ÍÊäÈë20090901 20090910
Êä³ö20090901 20090910
È¡µÃÌìÊýºó×÷Ò»ÏÂÅжÏÔÙ°ÑÕâ¸ö·½·¨ÓÃÏÂvoid set(int field, int value)
......
JSPÒ³ÃæÖÐÓжà¸öradio°´Å¥
JSPÒ³Ã潫²ÎÊýPOST¸øservlet
ÒªÇóÈçÏÂ;
1.Ñ¡ÔñÒ»¸öradio£¬µ÷ÓÃservlet servletÖиù¾Ý²ÎÊýµ÷ÓÃÆäËû½Ó¿Ú£¬³ý·ÇÑ¡ÖиÃradio²¢µã»÷JSPÖеÄʵР......
org.apache.jasper.JasperException: Unable to compile class for JSP:
An error occurred at line: 52 in the jsp file: /vip_info.jsp
ÕË cannot be resolved
49: <table border="1& ......
ÎÒÊǸöÐÂÊÖ£¬Íû¸ßÊÖ½â´ð
ÎÒÏÖÔÚÒѾ°²×°ÁËmysql£¬Ò²ÓÐmysqlµÄjdbc¡£µ«ÎÒÔõôÅäÖú󣬲ÅÄÜÔÚMyEclipseÀï²Ù×÷mysqlÄØ£¿Çë¸ßÊÖ˵Ïêϸµã
´ò¿ªMyeclipse----window---open perspective---MyEclipse database explorer-- ......
ллÌÆÈËÀÏ´óµÄÖ¸µã£¬Ð»Ð»¸÷λ¸ßÊÖµÄÖ¸µã£¡
°²×°10g Enterprise¡£ÉÏÍøÏÂÁËMLDNµÄOracleÊÓƵ£¬¸ú×ÅÊÓƵÉϵÄÅäÖÃ×ߣ¬°²×°³É¹¦ÁË£¬µ«ÊÇûÍêÕûµØÅäÖá£
µã»÷½øÈ룺Database Configuration Assistant
1. ´´½¨Êý¾Ý¿â£»
......