/**
* Word导出
* @throws DocumentException
*/
public void exeportWord() throws DocumentException{
//放到tomcat下
String formName="word";
String pathName=ServletActionContext.getRequest().getSession().getServletContext().getRealPath("")+"\\export\\"+formName+".doc";
//4.1定义表头
String tableName="T_USER";
String tableCName = selectDataService.getString("select comments from user_tab_comments where table_name ='"+tableName+"'");
//4.2获取表的中文注释
List<Map> list=selectDataService.queryForList("select t.column_name,t.comments from user_col_comments t where table_name ='"+tableName+"'");
//4.2 创建一个list
List<String> columns=new ArrayList<String>();
Map<String, String> colmap=new TreeMap<String, String>();
for (Map map:list) {
//把数据库里的注释取出来,放到columns里
columns.add(map.get("COMMENTS").toString());
* Word导出
* @throws DocumentException
*/
public void exeportWord() throws DocumentException{
//放到tomcat下
String formName="word";
String pathName=ServletActionContext.getRequest().getSession().getServletContext().getRealPath("")+"\\export\\"+formName+".doc";
//4.1定义表头
String tableName="T_USER";
String tableCName = selectDataService.getString("select comments from user_tab_comments where table_name ='"+tableName+"'");
//4.2获取表的中文注释
List<Map> list=selectDataService.queryForList("select t.column_name,t.comments from user_col_comments t where table_name ='"+tableName+"'");
//4.2 创建一个list
List<String> columns=new ArrayList<String>();
Map<String, String> colmap=new TreeMap<String, String>();
for (Map map:list) {
//把数据库里的注释取出来,放到columns里
columns.add(map.get("COMMENTS").toString());