report.java

用java 实现的IE browser适合于学者

package com.hnjchina.securityView;
import	org.eclipse.swt.*;
import	org.eclipse.swt.widgets.*;
import	java.io.UnsupportedEncodingException;
import	java.sql.*;

public class Report {
	public  ResultSet result;
	private	int	colcnt;
	String[] labelname;
	StringBuffer	stringbuffer=new StringBuffer(200);
	public	void execsecurity(){
		String	ls_sql="select name,description,priority,status,user_type from	security_users";
		Logon	logon=new Logon();
		result=logon.exesql(ls_sql);
	}
	public	void	createtabletile(Table table) throws SQLException{
		if	(result==null){ execsecurity();}
		ResultSetMetaData	metadata=result.getMetaData();
		colcnt=metadata.getColumnCount();
		labelname=new String[colcnt];
		int[]	colwidth=new	int[colcnt];
		int	linewidth = 0;
		for (int i=0;i<colcnt;i++){
			TableColumn	column=new TableColumn(table,SWT.LEFT_TO_RIGHT);	
			labelname[i]=metadata.getColumnLabel(i+1);
			colwidth[i]=metadata.getColumnDisplaySize(i+1);
			if (colwidth[i]>15) {
				colwidth[i]=15;
			}
			column.setText(labelname[i]);
			column.setWidth(colwidth[i]*15);
		}
	}
	public	void	retrievetable(Table table){
		int		li_row=0,li_cnt=0;
		boolean	lb_isnext=false;
		Array	ls_array = null;
		String	ls_string=null;
		if	(result==null) {execsecurity();}
		try {
			if	(result.isAfterLast()){
				result.first();
			}
			li_row=0;
			String	ls_buffer="";
			while (result.next()){
			TableItem	tableitem=new	TableItem(table,SWT.NONE);
			for	(int i=0;i<colcnt;i++){
			ls_string=result.getString(i+1);
			if	(labelname[i].equals("description")) {
			try {
				ls_string =new  String(ls_string.getBytes("ISO-8859-1"));
			} catch (UnsupportedEncodingException e1) {
				e1.printStackTrace();
			}}
			tableitem.setText(i,ls_string);
			ls_buffer=ls_buffer+ls_string;
			}
			stringbuffer.insert(0,ls_buffer);
			stringbuffer.insert(0,"\n");
			ls_buffer="";
			li_row++;
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
}