畫面隱藏按鈕

<script type="text/javascript">form1.按鈕名稱.style.display='none';</script>

清除按鈕功能

不需要被清除的field
clearDefault="初始值" 或 <script type="text/javascript">form1.fieldName.clearDefault="初始值";</script>
清除按鈕 onclick="clearValue();"

function clearValue(){
 for(var i=0; i<document.forms[0].elements.length; i++){
  obj = document.forms[0].elements[i];
  if("field_Q" == obj.className){
   if( undefined == obj.clearDefault ){
    if("text" == obj.type) {
     obj.value = "";
    } else if("checkbox" == obj.type) {
     obj.checked = false;
    } else if("radio" == obj.type) {
     obj.checked = false;
    } else if("select" == obj.type) {
     obj.selectedIndex = 0;
    }
   } else {
    if("text" == obj.type) {
      obj.value = obj.clearDefault;
    } else if("checkbox" == obj.type) {
     if(obj.value == obj.clearDefault) obj.checked = true;
    } else if("radio" == obj.type) {
     if(obj.value == obj.clearDefault) obj.checked = true;
    } else if("select" == obj.type) {
     obj.options.value = obj.clearDefault;
    }
   }
  }
 }
}

不需要下面list，不需要執行queryAll()

將整個queryone()的JSP展開。
<div id="formContainer"> 改成 <div id="formContainerAll">

SuperBean.java 執行 db.excuteSQL(sql.toString());會出現Exception

參照：
SuperBean.java
public void insert2SYSLog(String action_flag, String[] sqlArray)



解決：在執行db.excuteSQL之前，將sql replace所有\n為空白即可。

原因：java.lang.Exception: java.sql.SQLException: Invalid SQL statement or JDBC escape, terminating ''' not found.
at util.Database.excuteSQL(Database.java:237)
at util.SuperBean.insert2SYSLog(SuperBean.java:334)
at util.SuperBean.insert(SuperBean.java:221)
at org.apache.jsp.cri.nu.crinu010f_jsp._jspService(crinu010f_jsp.java:137)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:386)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at filter.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:123)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.sql.SQLException: Invalid SQL statement or JDBC escape, terminating ''' not found.
at net.sourceforge.jtds.jdbc.SQLParser.parse(SQLParser.java:1155)
at net.sourceforge.jtds.jdbc.SQLParser.parse(SQLParser.java:156)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:584)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1042)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:999)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
at $java.sql.Wrapper$$EnhancerByProxool$$dde8129e.executeUpdate(<generated>)
at util.Database.excuteSQL(Database.java:233)
... 24 more

登入系統後，IE視窗直接關閉

解決方式：關閉快顯封鎖程式

解決在首頁要登入2次

「網際網路選項」→「安全性」→「雜項」顯示混合內容 → 啟用

資料維護畫面(查詢、新增、刪除、修改) 問題集

原因：
queryAll正常, 點選list其中一筆, 執行queryOne後, 有些值無法傳至上方form位置。
解決：
將所有變數第一個字元改成小寫, 即可正常運作。
特殊：
LName，前兩個字元都得小寫lname。

---

原因：
查詢後，所有欄位變成可輸入狀態。
解決方式：
在<body> onLoad加入whatButtonFireEvent('<%=obj.getState()%>');