資源簡(jiǎn)介
在一個(gè)JSP頁(yè)面里面根據(jù)條件動(dòng)態(tài)的加載另一個(gè)jsp頁(yè)面,另一個(gè)jsp頁(yè)面是根據(jù)條件從數(shù)據(jù)庫(kù)中提取的數(shù)據(jù)表格。

代碼片段和文件信息
package?com.zz.dztd;
import?java.net.URLEncoder;
import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;
import?java.text.DecimalFormat;
import?javax.naming.InitialContext;
import?javax.sql.DataSource;
import?com.sinoasp.dbcon.DBOperate;
import?com.sinoasp.dbcon.SessionFactory;
public?class?dztd?{
/**
?*?@param?args
?*/
??Connection???con???=???null;?
??
??private?String?CK_KEY?=?null;
??
??private?String?HQCK_KEY_EX;
??private?String?HQCK_FHDH_EX;
??????
?
??private?String?U_KEY?;
??private?String?HQCK_TDH?;
??private?String?PINMING?;
??private?String?GG1;
??private?String?GG2?;
??private?String?GG3?;
??private?String?CZ?;
??private?String?CHANGJIA?;
??private?String?GONGYI?;
??private?String?PINZHI?;
??private?String?QTSX?;
??private?String?HQCK_THR?;
??private?String?JLFS?;
??private?String?FHFS?;
??private?String?FHLX?;
??private?String?HQCK_CKKZ?;
??private?String?HQCK_KPJS?;
??private?String?HQCK_KPSL?;
??private?String?HQCK_KPFB?;
??private?String?HQCK_KPZL?;
??private?String?BZDW?;
??private?String?FLDW?;
??private?String?ZLDW?;
??private?String?STATUS?;
??private?String?HQCK_KDSJ?;
??private?String?HQCK_KDR?;
??private?String?HQCK_FHSJ?;
??private?String?HQCK_FHR?;
??private?String?HQCK_GXR?;
??private?String?HQCK_GXSJ?;
??private?String?BZ?;
??private?String?U_NAME?;
??private?String?LSTDH?;
?
??private?String?U_JC?;
??private?String?HPBH?;
??private?String?THCH?;
??
??private?boolean?admin_flag=false; //管理員標(biāo)志
??private?String?DwNO=null; //公司名稱
??private?String?sql?=?null;
??private?int?count=0;?? //記錄結(jié)果集的行數(shù)
??
??
??private?String?starttime;
??private?String?endtime;
??
??
//下面接著寫(xiě)方法,還有去查找一下事務(wù)的使用方法
public?boolean?insert_dztd()?throws?Exception?
{
boolean?success?=?false;
//新新配法
String?sql?=?null;??
/*sql?=?“insert?into?iep.ob_hqck_ex?(HQCK_KEY_EX?HQCK_FHDH_EX?U_KEY?HQCK_TDH?PINMING?GG1??“?+
“?GG2?GG3?CZ?CHANGJIA?GONGYI?PINZHI?QTSX?HQCK_THR?JLFS?FHFS?FHLX?HQCK_CKKZ??“?+
“?HQCK_KPJS?HQCK_KPSL?HQCK_KPFB?HQCK_KPZL?BZDW?FLDW?ZLDW?STATUS?HQCK_KDSJ?HQCK_KDR?“?+
“??HQCK_GXR?HQCK_GXSJ?BZ?U_NAME?LSTDH?CK_KEY?HPBH?THCHU_JC?)“?+
“?values(??????????????????????????????????????????????????“?+
“???to_date(?‘yyyy-mm-dd?hh24:mi:ss‘)?????to_date(?‘yyyy-mm-dd?hh24:mi:ss‘)??????????????)“;
*/
sql?=?“insert?into?iep.ob_hqck_ex?(HQCK_KEY_EX?HQCK_FHDH_EX?U_KEY?HQCK_TDH?PINMING?GG1??“?+
“?GG2?GG3?CZ?CHANGJIA?GONGYI?PINZHI?HQCK_THR?JLFS?FHFS?FHLX?HQCK_CKKZ??“?+
“?HQCK_KPJS???HQCK_KPZL?BZDW??ZLDW?STATUS??HQCK_KDR?“?+
“??HQCK_GXR??BZ?U_NAME?LSTDH?CK_KEY?HPBH?THCHU_JC?HQCK_KDSJ?HQCK_GXSJ??)“?+
“?values(IEP.SEQ_OB_HQCK_EX.nextv
?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????文件???????2261??2009-01-22?15:36??jquery\do_getzy.jsp
?????文件??????17968??2009-01-22?14:10??jquery\dztd.jsp
?????文件???????2964??2009-02-03?12:37??jquery\說(shuō)明.txt
?????文件??????29786??2009-01-22?10:05??jquery\dztd.java
?????文件?????100272??2008-06-26?22:10??jquery\jquery.js
?????目錄??????????0??2009-02-03?11:49??jquery
-----------?---------??----------?-----??----
???????????????153251????????????????????6
評(píng)論
共有 條評(píng)論