尚筹网：数据库逆向工程以及显示页面

港控/mmm° 2023-06-27 11:18 114阅读 0赞

# 创建模型 #

CREATE TABLE t_role (
    	`id` INT (11) NOT NULL auto_increment,
    	`name` VARCHAR (255),
    	PRIMARY KEY (id)
    );

# 逆向工程 #

1、修改/atcrowdfunding-reverse/src/main/resources/generatorConfig.xml

选择pom.xml----》 Run as —》 Maven build … —》将Goal的值设置为：mybatis-generator:generate----》Run

2、调整Role.java：生成无参构造器、有参构造器和toString方法

3、逆向工程生成的资源各归各位

*  将atcrowdfunding-reverse/src/main/java目录下的com.atguigu.crowd.funding.entity包调整到atcrowdfunding-admin-4-entity模块的/src/main/java下
 *  atcrowdfunding-reverse/src/main/java目录下的com.atguigu.crowd.funding.mapper包放到component模块的/src/main/java下
 *  在**atcrowdfunding-admin-1-webui**/src/main/resources/mybatis/mapper目录，然后将com.atguigu.crowd.funding.mapper包的AdminMapper.xml放在atcrowdfunding-admin-1-webui模块的/src/main/resources下

# 创建组件 #

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poaXpoZW5nZ3Vhbg_size_16_color_FFFFFF_t_70]

# 前往角色维护页面 #

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poaXpoZW5nZ3Vhbg_size_16_color_FFFFFF_t_70 1]  
在/atcrowdfunding-admin-1-webui/src/main/webapp/WEB-INF/include-sidebar.jsp修改角色维护超链接

在spring-web-mvc.xml文件中配置view-controller

<mvc:view-controller path="/role/to/page.html" view-name="role-page"/>

创建/atcrowdfunding-admin-1-webui/src/main/webapp/WEB-INF/role-page.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    	pageEncoding="UTF-8"%>
    <!DOCTYPE html>
    <html lang="UTF-8">
    <%@ include file="/WEB-INF/include-head.jsp"%>
    <body>
    
    	<%@ include file="/WEB-INF/include-nav.jsp"%>
    	<div class="container-fluid">
    		<div class="row">
    			<%@ include file="/WEB-INF/include-sidebar.jsp"%>
    			<div class="col-sm-9 col-sm-offset-3 col-md-10 col-md-offset-2 main">
    				<div class="panel panel-default">
    					<div class="panel-heading">
    						<h3 class="panel-title">
    							<i class="glyphicon glyphicon-th"></i> 数据列表
    						</h3>
    					</div>
    					<div class="panel-body">
    						<form class="form-inline" role="form" style="float: left;">
    							<div class="form-group has-feedback">
    								<div class="input-group">
    									<div class="input-group-addon">查询条件</div>
    									<input class="form-control has-success" type="text"
    										placeholder="请输入查询条件">
    								</div>
    							</div>
    							<button type="button" class="btn btn-warning">
    								<i class="glyphicon glyphicon-search"></i> 查询
    							</button>
    						</form>
    						<button type="button" class="btn btn-danger"
    							style="float: right; margin-left: 10px;">
    							<i class=" glyphicon glyphicon-remove"></i> 删除
    						</button>
    						<button type="button" class="btn btn-primary"
    							style="float: right;" onclick="window.location.href='form.html'">
    							<i class="glyphicon glyphicon-plus"></i> 新增
    						</button>
    						<br>
    						<hr style="clear: both;">
    						<div class="table-responsive">
    							<table class="table  table-bordered">
    								<thead>
    									<tr>
    										<th width="30">#</th>
    										<th width="30"><input type="checkbox"></th>
    										<th>名称</th>
    										<th width="100">操作</th>
    									</tr>
    								</thead>
    								<tbody>
    									<tr>
    										<td>1</td>
    										<td><input type="checkbox"></td>
    										<td>PM - 项目经理</td>
    										<td>
    											<button type="button" class="btn btn-success btn-xs">
    												<i class=" glyphicon glyphicon-check"></i>
    											</button>
    											<button type="button" class="btn btn-primary btn-xs">
    												<i class=" glyphicon glyphicon-pencil"></i>
    											</button>
    											<button type="button" class="btn btn-danger btn-xs">
    												<i class=" glyphicon glyphicon-remove"></i>
    											</button>
    										</td>
    									</tr>
    								</tbody>
    								<tfoot>
    									<tr>
    										<td colspan="6" align="center">
    											<ul class="pagination">
    												<li class="disabled"><a href="#">上一页</a></li>
    												<li class="active"><a href="#">1 <span
    														class="sr-only">(current)</span></a></li>
    												<li><a href="#">2</a></li>
    												<li><a href="#">3</a></li>
    												<li><a href="#">4</a></li>
    												<li><a href="#">5</a></li>
    												<li><a href="#">下一页</a></li>
    											</ul>
    										</td>
    									</tr>
    
    								</tfoot>
    							</table>
    						</div>
    					</div>
    				</div>
    			</div>
    		</div>
    	</div>
    </body>
    </html>

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poaXpoZW5nZ3Vhbg_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200106145720578.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poaXpoZW5nZ3Vhbg==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poaXpoZW5nZ3Vhbg_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20200106145855422.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poaXpoZW5nZ3Vhbg==,size_16,color_FFFFFF,t_70