util.java

JSP002网站流量统计、JSP002网站流量统计、JSP002网站流量统计、JSP002网站流量统计、JSP002网站流量统计、JSP002网站流量统计

package bean;


import java.sql.*;
import java.util.ArrayList;

public class Util {
	
	public String returnString(String str,int num){
		boolean blnFlag = false;
		int temp = 0;
		int length = 0;
		String strTemp = "";
		length = str.length();
		if (length<=num){
			strTemp = str;
			temp = num - length;
			for (int i = 0;i<temp;i++){
				strTemp="0"+strTemp;
			}
			blnFlag = true;
		}else if (length == num){
			strTemp = str;
			blnFlag = true;
		}else{
			blnFlag = false;
		}
		if (blnFlag==true){
			return strTemp;	
		}else{
			return null;
		}  
	}
	
	public ArrayList allMessage(){
		
		Connection conn=null;
		Statement st=null;
		ResultSet rs=null;
		ArrayList col = null;
		ArrayList al = new ArrayList();
		
		try{
			
			conn=DBConn.getConn();
			st=conn.createStatement();
			rs=st.executeQuery("select * from message");
			
			while(rs.next()){
				
				col = new ArrayList();
				col.add(rs.getString(4));
				col.add(rs.getString(5));
				
				al.add(col);
			}
		
		
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			try{
				if(rs!=null)rs.close();
				if(st!=null)st.close();
				if(conn!=null)conn.close();
			}catch(Exception ee){
				ee.printStackTrace();
			}
		}
		return al;
	}

}