自己无聊写的一个dao方法（本想不用写sql语句）_JAVA_编程开发_程序员俱乐部

package com.xinnuo;

import java.util.Vector;
import com.xinnuo.core.dao.BaseDaoSupport;

public class Sql extends BaseDaoSupport{
//getRecord 为之前的方法	
// table为表名，word为要查询的字段，where为条件语句，wherevalue为条件语句的值
	public Vector select(String table ,String[] word ,String where,String[] wherevalue ) {
		String sql="";
		Vector rs=new Vector();	
		sql="select ";
		for (int i = 0; i < word.length; i++) {
			sql += word[i]+",";
		}
		sql=sql.replaceAll(",$", "");
		sql += " from "+table+" where "+where;
		try {
			rs=getRecord(sql,wherevalue);			
		} catch (Exception e) {			
		}
		
		System.out.println("sql===="+sql);
		System.out.println("rs==="+rs.toString());
		
		return rs;
	}
	
	public static void main(String[] args) {
		String table="power";
		String[] word={"Power_ID","Power_Name"};
		String where="Power_ID=?";
		String[] wherevalue={"16"};
		Sql sql=new Sql();
		sql.select(table,word,where,wherevalue);
	}

}