META-INF.resources.WEB-INF.jsp.cms.database-show-stru.jsp Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of ajaxjs-cms Show documentation

The newest version!

<%@ page language="java" contentType="text/html; charset=UTF-8"
	import="java.util.*, java.sql.*, com.ajaxjs.cms.controller.DataBaseShowStruController, com.ajaxjs.mvc.filter.DataBaseFilter,com.ajaxjs.orm.JdbcConnection"
	pageEncoding="UTF-8"%>
<%@taglib uri="/ajaxjs" prefix="c"%>
<%
	DataBaseFilter.initDb();
	Connection conn = JdbcConnection.getConnection();
	
	List tables = DataBaseShowStruController.getAllTableName(conn);
	Map tablesComment = DataBaseShowStruController.getCommentByTableName(conn, tables);
	Map>> infos = DataBaseShowStruController.getColumnCommentByTableName(conn, tables);
%>



	
	表设计文档
	


	
		
 
 

		${aj_allConfig.site.titlePrefix} 表设计文档
		
		
			
			
				${item}
			
			
		

		
			
			Powered by AJAXJS Framework!
			
		
	
	
		<%
			for (String tableName : tables) {
				if ("template".equals(tableName))
					continue;
				List> info = infos.get(tableName);
		%>
		
		<%=tableName%>
		<%=tablesComment.get(tableName)%>

		
		<%
			for (Map i : info) {
					request.setAttribute("info", i);
		%>
			

		<%
			}
		%>

		
			
				字段名
				类型（长度）
				允许为空
				字段说明
			

				${info.name}
				${info.type.toUpperCase()}
				${info['null'].toLowerCase()}
				${info.comment}
			
		<%
			}
			JdbcConnection.closeDb();
			JdbcConnection.clean();
		%>