查找数据库对应的表中的字段名和注释

public class ModelTool  extends SpringBeanAutowiringSupport  {

@Autowired
private CompanyService comservice;
 
   public void columns(ModelMap model,String tablename) throws IOException{
   /*获取数据库名字*/
Properties props = Resources.getResourceAsProperties("application.properties");
String url = props.getProperty("jdbc.url");
String[] sp1=url.split("/");
String DataName=sp1[3].split("\\?")[0];
String sql="SELECT column_name,column_comment FROM information_schema.Columns "
+ "WHERE table_name='"+tablename+"' AND table_schema='"+DataName+"'";
List ls=comservice.GetListByCondition(sql);
List lss=new ArrayList();
JSONArray jsonArray = JSONArray.fromObject (ls);
model.addAttribute("columns", jsonArray);
   }
}

注：@Autowired为自动装配，若该类为非控制类@controller，则必须继承SpringBeanAutowiringSupport