用反射写出通用SqlDao的增删改查

查询通用Dao

public static List<Object> queryall(Object o) throws Exception{
   
		List<Object> lp=new ArrayList<Object>();
		Connection conn = BaseDao.getcon();
		Class c=o.getClass();
		Field[] f1 = c.getDeclaredFields();
		StringBuffer sb=new StringBuffer();
		sb.append("select * from "+c.getSimpleName());
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		try {
   
			pstmt = conn.prepareStatement(sb.toString());
			rs = pstmt.executeQuery();
			ResultSetMetaData metaData = rs.getMetaData();
			int count = metaData.getColumnCount();
			while(rs.next()){
   
				Object obj = cs.newInstance();
				for(int i=0;i<f1.length;i++) {
   
					for(int j=0;j<count;j++) {
   
						String lm = metaData.getColumnName(j+1);
		if(f1[i].getName().toUpperCase().equals(lm.toUpperCase())) {
   
							f1[i].setAccessible(tru