- 博客(3)
- 资源 (45)
- 收藏
- 关注
RSS订阅原创 高分请教DB2中中分组统计中,如何显示COUNT结果为0的行?
select orgNo from table_A where MDL='mbmbrsig' 显示的结果如: 1100 1200 2200 3600 SELECT orgNo,count(*) FROM table_B group by orgNo 显示的结果如下: 1200 56 2200 98 问题是如何是1100,3300机构没有数据统计的时
2013-05-02 12:47:41
1515
2
原创 请问页面上关于时间校验问题。
请问页面上关于时间比较的问题开始时间和结束时间可以由控件得到(格式:yyyy-mm-dd)，但提交时开始时间得小于结束时间不知怎么处理？
2005-11-26 20:46:00
837
原创 请教页面上根据多选框里选项内容的查询问题？多谢！
JSP页面： 后台处理的部分代码： public List searchJob(HttpServletRequest request) throws Exception{ String city[] = request.getParameterValues("city"); Criteria crit = new Criteria(); List
2005-11-26 20:32:00
897
站内邮箱(jsp+java+ajax)
此系统包括站内邮箱。是OA办公自动化系统的重要模块。用jsp+java+ajax语言，数据库是server sql 2005。不足之处，请多指教！
2010-02-03
jfreechart-0.9.20.jar包
JFreeChart它主要是用来制作各种各样的图表，这些图表包括：饼图、柱状图(普通柱状图以及堆栈柱状图)、线图、区域图、分布图、混合图、甘特图以及一些仪表盘等等。
2009-09-17
MySQL数据库移植到Oracle
先有个免费工具，但每个表只能移植5条记录(clob blob等大数据类型都能处理)。若要代码自动批量移植,请MSN联系：dy-fairy@hotmail.com
2009-09-17
java实现读PDF文件
请下载这个包PDFBox-0.7.3.jar
import java.io.File;
import java.io.FileOutputStream;
import java.io.OutputStreamWriter;
import java.io.Writer;
import java.net.MalformedURLException;
import java.net.URL;
import org.pdfbox.pdmodel.PDDocument;
import org.pdfbox.util.PDFTextStripper;
public class PdfReader
{
public void readFdf(String file) throws Exception
{
// 是否排序
boolean sort = false;
// pdf文件名
String pdfFile = file;
// 输入文本文件名称
String textFile = null;
// 编码方式
String encoding = "UTF-8";
// 开始提取页数
int startPage = 1;
// 结束提取页数
int endPage = Integer.MAX_VALUE;
// 文件输入流，生成文本文件
Writer output = null;
// 内存中存储的PDF Document
PDDocument document = null;
try
{
try
{
// 首先当作一个URL来装载文件，如果得到异常再从本地文件系统//去装载文件
URL url = new URL(pdfFile);
//注意参数已不是以前版本中的URL.而是File。
document = PDDocument.load(pdfFile);
// 获取PDF的文件名
String fileName = url.getFile();
// 以原来PDF的名称来命名新产生的txt文件
if (fileName.length() > 4)
{
File outputFile = new File(fileName.substring(0, fileName
.length() - 4)
+ ".txt");
textFile = outputFile.getName();
}
}
catch (MalformedURLException e)
{
// 如果作为URL装载得到异常则从文件系统装载
//注意参数已不是以前版本中的URL.而是File。
document = PDDocument.load(pdfFile);
if (pdfFile.length() > 4)
{
textFile = pdfFile.substring(0, pdfFile.length() - 4)
+ ".txt";
}
}
// 文件输入流，写入文件倒textFile
output = new OutputStreamWriter(new FileOutputStream(textFile),
encoding);
// PDFTextStripper来提取文本
PDFTextStripper stripper = null;
stripper = new PDFTextStripper();
// 设置是否排序
stripper.setSortByPosition(sort);
// 设置起始页
stripper.setStartPage(startPage);
// 设置结束页
stripper.setEndPage(endPage);
// 调用PDFTextStripper的writeText提取并输出文本
stripper.writeText(document, output);
}
finally
{
if (output != null)
{
// 关闭输出流
output.close();
}
if (document != null)
{
// 关闭PDF Document
document.close();
}
}
}
/**
* @param args
*/
public static void main(String[] args)
{
// TODO Auto-generated method stub
PdfReader pdfReader = new PdfReader();
try
{
// 取得E盘下的SpringGuide.pdf的内容
pdfReader.readFdf("E:\\test.pdf");
}
catch (Exception e)
{
e.printStackTrace();
}
}
}
2009-09-17
Java Oracle分页处理
package com.list.struts.util;
import java.util.ArrayList;
public class Page {
//当前跳转的页面情况
private String pagetype;
private PaginationBean pagination;
private ArrayList result;
//构造函数实例化接收一个pagetype和PaginationBean对象
public Page(String pagetype, PaginationBean pagination) {
this.pagetype = pagetype;
this.pagination = pagination;
}
/**
*
*
*/
public boolean isEmpty() {
if (pagetype == null || pagetype.equals("")) {
return true;
} else {
return false;
}
}
/**
*
*
*
*/
public ArrayList getResult() {
if (!isEmpty()) {
if (pagetype.equals("nextPage")) {
result = pagination.getNextPage();
}
else if (pagetype.equals("previousPage")) {
result = pagination.getPreviouspage();
}
else if (pagetype.equals("lastPage")){
result = pagination.getLastPage();
}
else if (pagetype.equals("firstPage")){
result = pagination.getFirstPage();
}
else{
result=pagination.getJumpPage(pagetype);
}
} else {
result = pagination.getProducts();
}
return result;
}
/**
*
*
*
*/
//此对象中保存了页面的所有情况，包括多少页等信息
public PaginationBean getPagePagination() {
return pagination;
}
/**
*
*
*/
//实例化PaginationBean的构造函数
public void Init(ArrayList result) {
this.result = result;
pagination = new PaginationBean(result);
}
}
------------------------------
import java.util.ArrayList;
import java.util.List;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import com.list.struts.form.ListForm;
import com.list.struts.util.Page;
import com.list.struts.util.PageBean;
import com.list.struts.util.PaginationBean;
import com.list.struts.vo.newgetResouce;
public class ListAction extends Action {
/*
* Generated Method
2009-07-10
java文件上传和下载的包及样例
mport java.io.*;
import javax.servlet.http.HttpServletRequest;
import java.util.HashMap;
public class AttachUploadServlet
{
public static final int MAX_SIZE = 1024 * 1024 * 100;
public static final String FILE_DIR = "d:/temp/";
private int file_Size = 0;
private String file_Path = "";
private HashMap hm = new HashMap();
public String upLoad(HttpServletRequest req)
{
String tmpString = "";
String result = "";
DataInputStream dis = null;
try
{
dis = new DataInputStream(req.getInputStream());
String content = req.getContentType();
if (content != null && content.indexOf("multipart/form-data") != -1)
{
int reqSize = req.getContentLength();
byte[] data = new byte[reqSize];
int bytesRead = 0;
int totalBytesRead = 0;
int sizeCheck = 0;
while (totalBytesRead < reqSize)
{
// check for maximum file size violation
sizeCheck = totalBytesRead + dis.available();
if (sizeCheck > MAX_SIZE) result = "文件太大不能上传...";
bytesRead = dis.read(data, totalBytesRead, reqSize);
totalBytesRead += bytesRead;
}
tmpString = new String(data);
hm = parseAnotherParam(tmpString);
int postion = arrayIndexOf(data, "\r\n".getBytes());
byte[] split_arr = new byte[postion];
System.arraycopy(data, 0, split_arr, 0, postion);
postion = arrayIndexOf(data, "filename=\"".getBytes());
byte[] dataTmp = new byte[data.length - postion];
System.arraycopy(data, postion, dataTmp, 0, dataTmp.length);
data = null;
data = dataTmp.clone();
String filePath = null;
postion = arrayIndexOf(data, "Content-Type:".getBytes()) - 2;
dataTmp = null;
dataTmp = new byte[postion];
System.arraycopy(data, 0, dataTmp, 0, dataTmp.length);
filePath = new String(dataTmp);
if (filePath == null && filePath.equals("")) return "";
// 分离contentType 并赋值
postion = arrayIndexOf(data, "Content-Type:".getBytes());
dataTmp = null;
dataTmp = new byte[data.length - postion];
System.arraycopy(data, postion, dataTmp, 0, dataTmp.length);
data = null;
data = dataTmp.clone();
postion = arrayIndexOf(data, "\n".getBytes()) + 1;
dataTmp = null;
dataTmp = new byte[data.length - postion];
System.arraycopy(data, postion, dataTmp, 0, dataTmp.length);
data = null;
data = dataTmp.clone();
// 分离文件信息 获得最终想要的字节
postion = arrayIndexOf(data, split_arr);
split_arr = null;
dataTmp = null;
dataTmp = new byte[postion - 2];
System.arraycopy(data, 2, dataTmp, 0, dataTmp.length);
data = null;
data = dataTmp.clone();
postion = arrayLastIndexOf(data, "\n".getBytes()) - 1;
dataTmp = null;
dataTmp = new byte[postion];
System.arraycopy(data, 0, dataTmp, 0, dataTmp.length);
data = null;
String file_path = getFileName(filePath);
if (null != file_path)
{
if (writeFile(dataTmp, FILE_DIR + file_path))
{
this.file_Size = dataTmp.length;
this.file_Path = FILE_DIR + file_path;
result = "文件上传完毕";
}
else
{
result = "文件上传失败";
}
}
else
{
result = "文件名为空";
}
dataTmp = null;
}
else
{
result = "content 必须为 multipart/form-data";
}
}
catch (UnsupportedEncodingException ex4)
{
result = "UnsupportedEncodingException错误";
}
catch (NullPointerException e)
{
result = "NullPointerException错误";
}
catch (IOException ex1)
{
result = "IOException 错误 ";
}
catch (Exception ex1)
{
result = "Exception 错误 ";
}
return result;
}
public String getFilePath()
{
return this.file_Path;
}
public int getFileSize()
{
return this.file_Size;
}
public boolean writeFile(byte[] data, String path)
{
File f = null;
FileOutputStream fos = null;
try
{
f = new File(path);
f.createNewFile();
fos = new FileOutputStream(f);
fos.write(data, 0, data.length);
}
catch (FileNotFoundException e)
{
return false;
}
catch (IOException e)
{
return false;
}
finally
{
try
{
fos.close();
}
catch (IOException e)
{
return false;
}
}
return true;
}
public String getFileName(String arg)
{
String path = "";
if (arg.equals("\"\""))
{
return null;
}
if (arg.indexOf("\"") > -1) path = arg.substring(arg.indexOf("\"") + 1,
arg.lastIndexOf("\""));
else
path = arg;
path = path.substring(path.lastIndexOf("\\") + 1);
return path;
}
//判断两个byte数组的值是否相等
private boolean arrayEquals(byte[] src, byte[] value)
{
if (src == null || value == null) return false;
if (src.length != value.length) return false;
for (int i = 0; i < src.length; i++)
{
if (src[i] != value[i]) return false;
}
return true;
}
//找出value数组在src中的位置, 从前往后
private int arrayIndexOf(byte[] src, byte[] value)
{
if (src == null || value == null) return -1;
if (src.length < value.length) return -1;
int postion = -1;
for (int i = 0; i < src.length - value.length; i++)
{
postion = i;
byte[] tmp = new byte[value.length];
System.arraycopy(src, i, tmp, 0, tmp.length);
if (arrayEquals(tmp, value))
{
tmp = null;
return postion;
}
else
{
postion = -1;
tmp = null;
}
}
return postion;
}
//找出value数组在src中的位置
private int arrayLastIndexOf(byte[] src, byte[] value)
{
if (src == null || value == null) return -1;
if (src.length < value.length) return -1;
int postion = -1;
for (int i = src.length - value.length; i > -1; i--)
{
postion = i;
byte[] tmp = new byte[value.length];
System.arraycopy(src, i, tmp, 0, tmp.length);
if (arrayEquals(tmp, value))
{
tmp = null;
return postion;
}
else
{
postion = -1;
tmp = null;
}
}
return postion;
}
public HashMap parseAnotherParam(String str)
{
HashMap<String, String> hm = new HashMap<String, String>();
String key = "";
String value = "";
int startindex = 0;
int endindex = 0;
startindex = str.indexOf("Content-Disposition: form-data; name=\"")
+ "Content-Disposition: form-data; name=\"".length();
endindex = str.indexOf("\"\r\n\r\n");
while (startindex > -1 && endindex > -1)
{
key = str.substring(startindex, endindex);
if (!str.substring(endindex, endindex + 5).equals("\"\r\n\r\n"))
{//去掉没有value的元素
str = str.substring(endindex);
startindex = str
.indexOf("Content-Disposition: form-data; name=\"")
+ "Content-Disposition: form-data; name=\"".length();
endindex = str.indexOf("\"\r\n\r\n");
continue;
}
if (key.indexOf("\";") > -1)
{//去掉上传文件的参数以及编码
str = str.substring(str.indexOf("\";") + 2);
startindex = str
.indexOf("Content-Disposition: form-data; name=\"")
+ "Content-Disposition: form-data; name=\"".length();
endindex = str.indexOf("\"\r\n\r\n");
continue;
}
else
str = str.substring(endindex + 5);
value = str.substring(0, str.indexOf("\r\n"));
str = str.substring(str.indexOf("\r\n") + 2);
hm.put(key, value);
startindex = str.indexOf("Content-Disposition: form-data; name=\"")
+ "Content-Disposition: form-data; name=\"".length();
endindex = str.indexOf("\"\r\n\r\n");
}
return hm;
}
public String getParameter(String param)
{
return (String) hm.get(param);
}
}
2009-07-10
DBConnectionPool
import java.sql.*;
import java.util.*;
import java.util.Date;
/**
* JDBC数据库连接池类。<p>
*
*/
public class DBConnectionPool {
//可用连接池
private Vector ConnectionPool = new Vector();
//最大连接数
private int maxConn;
//连接数量
private int connNumb;
//数据库参数
private String strURL;
private String strUser;
private String strPassword;
//连接池名
private String strName;
private final static int DEFAULT_MAX_CONNECTIONS = 30;
/**
* 构造方法。
*
* @param URL URL
* @param URL
*/
public DBConnectionPool(String URL) {
this(URL, DEFAULT_MAX_CONNECTIONS);
} //end DBConnectionPool()
/**
* 构造方法。
} //end DBConnectionPool class
详见附件
2009-06-22
javax 的jms包
例子：
import java.util.Hashtable;
import javax.jms.*;
import javax.naming.*;
import javax.naming.directory.*;
public class sample
{
protected QueueConnectionFactory factory = null;
protected QueueConnection connection;
protected QueueSession queueSession;
protected TextMessage outMessage;
protected QueueSender queueSender;
protected QueueReceiver queueReceiver;
public static final String qcfLookup = "EXAMPLEQCF";
public static final String qLookup = "EXAMPLEQL";
public static final String icf = "com.sun.jndi.fscontext.RefFSContextFactory";
public String url = "file:/d:/temp";
public void sampleInit() throws Exception
{
Hashtable environment = new Hashtable();
environment.put(Context.INITIAL_CONTEXT_FACTORY, icf);
environment.put(Context.PROVIDER_URL, url);
environment.put(Context.REFERRAL, "throw");
Context ctx = new InitialDirContext(environment);
factory = (QueueConnectionFactory) ctx.lookup(qcfLookup);
Queue q1 = null;
q1 = (Queue) ctx.lookup(qLookup);
connection = factory.createQueueConnection();
queueSession = connection.createQueueSession(false,
Session.AUTO_ACKNOWLEDGE);
queueSender = queueSession.createSender(q1);
queueSender.setDeliveryMode(DeliveryMode.NON_PERSISTENT);
outMessage = queueSession.createTextMessage();
queueReceiver = queueSession.createReceiver(q1);
connection.start();
}
public void sendMessageOut(String message) throws JMSException
{
outMessage.setText(message);
queueSender.send(outMessage);
}
public String receiveMessage() throws Exception
{
return ((TextMessage) queueReceiver.receive()).getText();
}
public void sampleClose() throws JMSException
{
queueSession.close();
connection.close();
}
public static void main(String[] args){
String rec;
sample sp = new sample();
try {
sp.sampleInit();
sp.sendMessageOut("Hello World!");
java.lang.Thread.sleep(4000);
rec=sp.receiveMessage();
System.out.println("Receive text is : "+rec);
sp.sampleClose();
}catch(Exception e) {
e.printStackTrace();
}
}}
2010-03-12
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人