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
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