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ÊÔÒ
Ïà¹ØÎÊ´ð£º
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& ......
ʹÓÃjavaÔÚwindows7 32λÏÂÁ¬½ÓMSSQL¡£
Á½Ì¨»úÆ÷£¬windows7 32룬ÔÚ¿ØÖÆÃæ°åÀïÃæÈ«²¿ÉèÖÃÓïÑÔºÍÇøÓòÑ¡Ïî¶¼english-unitedstates
Î¨Ò»Çø±ðÖ»ÓÐÔÚ°²×°SQL server 2008µÄʱºò Ñ¡ÔñµÄ×Ö·û¼¯²»Ò»Ñù£¬
exec sp_helpsor ......
insert into [ScholarshipManagement].[dbo].[department] ([department],[specialization] ,[grade]) output inserted.departmentID values(? ,? ,? )
ÇëÎÊ´ó¸çÃÇÕâ¸ösql Óï¾äÓ¦¸ÃÓÃJavaÀïµÄÄǸöÊý¾Ý¿â²Ù×÷·½·¨£¿ ......
ÏÖÔÚ²»ÏëÓÃ<a> </a> ±êÇ© £¬ÒòΪµã»÷ºó»á³öÏÖÒ³ÃæÖØ¶¨Î»£¬¸øÎÄ×Ö¼ÓÉÏcssÑùʽ¾Í¿ÉÒÔ¿´ÆðÀ´ ÊÇhrefÔõôʵÏÖÕâÑùµÄcss
text-decoration:underline; cursor:hand;
ÒýÓÃ
text-decoration:underline; cur ......