picbean.java

完整的JAVA工程

package employee;

import java.util.*;
import java.sql.*;
import javax.swing.*;

/**
 *有关职工照片信息数据库操作的类
 */
 public class PicBean{
 	String sql;
 	ResultSet rs=null;
 	
 	String colName;//列名
	String colValue;//列值
 	String pEid;
 	String pUrl;
 	
	/**
	 * 职工照片信息综合查询(按照一个条件进行查询)
	 */
	public String[][] picAllSearch(String colname,String colvalue){
		this.colName = colname;
		this.colValue = colvalue;

		Database DB = new Database();
		String[][] sn = null;
		int row = 0;
		int i = 0;

		DB.toGBK(colvalue);
		
		if(colValue == null||colValue.equals("")){
			sql = "select eid,ename,sex,photo from emppic";
		}
		else{
			sql = "select eid,ename,sex,photo from emppic where "+colName+" = '"+colValue+"'";
		}
		try{
			DB.OpenConn();
			rs = DB.executeQuery(sql);

			if(rs.last()){
				row = rs.getRow();
			}
			
			if(row == 0){
				sn = null;
			}
			else{
				sn = new String[row][4];
				rs.first();
				rs.previous();
				while(rs.next()){
					sn[i][0] = rs.getString("eid");
					sn[i][1] = rs.getString("ename");
					sn[i][2] = rs.getString("sex");
					sn[i][3] = rs.getString("photo");
					i++;
				}
			}
		}
		catch(Exception e){
		}
		finally {
			DB.closeStmt();
			DB.closeConn();
		}
		return sn;
	}
 }