sexpert.java

来自「这个程序是花了好几十万请人开发的」· Java 代码 · 共 47 行

package javabean;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Vector;

public class Sexpert 
{
		dbconnect db=new dbconnect();
		public Vector getExpert(String sql)
		{
		  Vector vec=new Vector();
		  ResultSet rs=null;
		  String memo="";

		  try 
		  {	    
		  rs=db.executeQuery(sql);
		  while(rs.next())
		  {
			  Expert show=new Expert();
		      
			  show.setId(rs.getInt("ID"));  
			  show.setRname(rs.getString("RNAME"));		   
			  show.setSex(rs.getString("SEX"));
			  show.setZhiwu(rs.getString("ZHIWU"));
			  show.setZhiche(rs.getString("ZHICHE"));
		      
			  memo=rs.getString("MEMO").trim();
			  if(memo.length()>55)
			 {
				memo=memo.substring(0,55)+"...";
			 }		    	  
			  show.setMemo(memo);
			  show.setPhoto(rs.getString("PHOTO"));
			  vec.add(show);
		   }
		  rs.close();
		   return vec;
		}  
		  catch (SQLException e) { return null;}	

		}

}