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ÊÔÒ
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
JSPÒ³ÃæÖÐÓжà¸öradio°´Å¥
JSPÒ³Ãæ½«²ÎÊýPOST¸øservlet
ÒªÇóÈçÏÂ;
1.Ñ¡ÔñÒ»¸öradio£¬µ÷ÓÃservlet servletÖиù¾Ý²ÎÊýµ÷ÓÃÆäËû½Ó¿Ú£¬³ý·ÇÑ¡ÖиÃradio²¢µã»÷JSPÖеÄʵР......
ÎÒÔÚ javaºËÐļ¼ÊõÉÏ ¿´ÁËÒ»¸ö ÀûÓà Java socket emailµÄÀý×Ó ¿ÉÊÇÔõôҲ ²»³É¹¦ Ϊʲô£¿
Ô´Âë
Java code:
package cn.com.test.email;
import java.awt.GridBagLayout;
import java.awt.event.Action ......
ΪʲôHTMLÒÔ¼°Ò»Ð©ÆäËü±êÇ©»áÏÔÊ¾Ò»Ð©ÌØ¶¨±íÏÖÐÎÊ½ÄØ£¿ÈçHTMLÖеĻ»ÐбêÇ©<BR/>ÔڵײãÊÇÔõÑùʵÏÖµÄÄØ£¿ÏÖʵµÄÔÀíÊÇÊ²Ã´ÄØ
È¥W3C¹Ù·½ÍøÕ¾ÉÏ£¬¿´¿´°É£¡ÎÒÏëÒ»¿´Äã¾ÍÃ÷°×ÁË
ÎҲºͱàÒëÔÀíÓйأ¬ä¯ÀÀÆ÷Àï¿É ......
ʹÓÃjavaÔÚwindows7 32λÏÂÁ¬½ÓMSSQL¡£
Á½Ì¨»úÆ÷£¬windows7 32룬ÔÚ¿ØÖÆÃæ°åÀïÃæÈ«²¿ÉèÖÃÓïÑÔºÍÇøÓòÑ¡Ïî¶¼english-unitedstates
Î¨Ò»Çø±ðÖ»ÓÐÔÚ°²×°SQL server 2008µÄʱºò Ñ¡ÔñµÄ×Ö·û¼¯²»Ò»Ñù£¬
exec sp_helpsor ......