`
文章列表

SQL题目

Year      Salary 2000        1000 2001        2000 2002        3000 2003        4000 想得到如下形式的查询结果 Year      Salary 2000      1000 2001      3000 2002      6000 2003      10000 sql语句怎么写? create table TT ( YEARS NUMBER(4) not null, SALARY VARCHAR2(20) not null ) select b.ye ...

oracle查询锁表

SELECT /*+ rule */ s.username, decode(l.type,'TM','TABLE LOCK', 'TX','ROW LOCK', NULL) LOCK_LEVEL, o.owner,o.object_name,o.object_type, s.sid,s.serial#,s.terminal,s.machine,s.program,s.osuser FROM v$session s,v$lock l,dba_objects o WHERE l.sid = s.sid AND l.id1 = o.object_id(+) AND s.username is NOT ...
首先在创建DWR例子需要下载DWR.JAR包,先放在博客中下载 然后需要在WEB-INF下面创建一个dwr.xml文件 <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE dwr PUBLIC "-//GetAhead Limited//DTD Direct Web Remoting 2.0//EN" "http://getahead.org/dwr/dwr20.dtd"> <dwr> <allow> ...
则控制台输出错误信息 页面显示 HTTP Status 501 - Error. Details logged to the console 内部错误 警告: Unhandled Exception java.lang.SecurityException: Access to debug pages is denied. 未设置 <init-param> <param-name>debug</param-name> <param-value>true</param-value> </init-par ...
今天想跑通一下自己的AJAX+JSON+STRUTS1.2的程序。 MyJson.jsp <script src="Json/json.js"></script> <script type="text/javascript" > var myjosn = { "people": [ {"name":"aaa","age":"10","bir ...
package com.yl.servlet; import java.io.BufferedOutputStream; import java.io.BufferedReader; import java.io.ByteArrayOutputStream; import java.io.IOException; import java.io.OutputStream; import java.io.PrintWriter; import javax.servlet.ServletException; import javax.servlet.http.HttpServl ...
package com.test; import java.io.BufferedReader; import java.io.BufferedWriter; import java.io.File; import java.io.FileWriter; import java.io.InputStream; import java.io.InputStreamReader; import java.io.OutputStream; import java.io.OutputStreamWriter; import java.net.HttpURLConnection; ...
/** * * 方法描述:XX审计结果输出到Excel去中 * @param auditVOList * @param type */ private String numDataWriteExcel(List auditVOList) { Date todate=new Date(); SimpleDateFormat sdf=new SimpleDateFormat("yyMMddHHmmss"); String fileName=& ...
closed

返回参数类

    博客分类:
  • JAVA
public class ReturnVO { private int returnCode = 0; private String returnMsg = ""; private Object[] returnMsgParameters = new Object[0]; //错误信息参数数组 private int totalItems = 0; //总记录数 resultCount private int totalPage = 0; //总页数 pageCount private int realPage = 1; //当 ...
1.ACTION //*************************************** // 直接通过 <html:error/> 输出String的错误提示 youLong add 2009.3.3 //*************************************** else if(retVO.getretVO() instanceof String) { ActionErrors errors = new ActionErrors(); String errorss = (String) retVO.ge ...

下拉框

    博客分类:
  • JAVA
1.VO属性设为MAP: private HashMap cityHm = null; /** * 设置城市信息 * @param id 城市ID * @param desc 城市显示名 */ public void setCityHm(String id,String desc) { if(cityHm == null){ cityHm = new HashMap(); } cityHm.put(id,desc); } ...

成功则alert()

    博客分类:
  • JAVA
OPEN出窗体后进行操作然后提交,如果返回的是成功则alert()出一个窗口说明已成功,点击确定后关闭当前窗体并刷新父窗体列表。 1.在Action中用request.setAttribute("flag","success"); 保存值。 然后 return actionMapping.findForward("success"); 跳转到成功页面。 2.在成功页面写入一下代码。 <% String flag = (String)request.getAttribute("flag&q ...

流下载

    博客分类:
  • JAVA
private ActionForward doExportPrefixData(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) { String fileName=request.getParameter("fileName"); //页面传来的文件名 String filePath=ServerInfo.getDownloadPath()+fileName;//路径+文件名 ...

ZIP操作

    博客分类:
  • JAVA
public String  prefixZip(Object obj) throws FrameException {         String str = "";         PrintWriter dataos = null;         String strPath = ServerInfo.getDownloadPath();         try         {             File file = null;             file = new File(strPath);             file.mkdirs( ...
Global site tag (gtag.js) - Google Analytics