CGB2011JTday03

最新推荐文章于 2022-06-23 11:40:12 发布
最新推荐文章于 2022-06-23 11:40:12 发布
阅读量284 收藏
点赞数
文章标签： java
原文链接：https://blog.csdn.net/qq_16804847/article/details/114306250
版权
本文详细介绍了SpringBoot如何整合Mybatis-Plus进行数据库查询操作，包括根据ID和条件动态查询用户信息，并展示了如何删除name为空的数据。接着讲解了SpringBoot与Web资源的整合，创建项目、添加依赖、配置YML文件，实现了页面跳转到userList.jsp展示所有用户记录。最后，通过Ajax实现了异步请求，动态加载用户信息到表格中。
摘要由CSDN通过智能技术生成

1.MP案例学习

/**
	 * MP练习1: 查询
	 * 1. 根据Id查询数据 id=5的用
	 * 2. 根据name="唐僧" age=30    Sql: where name=xxx and age=xxx
	 */
	@Test
	public void testSelect01(){

	User user <span class="token operator">=</span> userMapper<span class="token punctuation">.</span><span class="token function">selectById</span><span class="token punctuation">(</span><span class="token number">5</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
	System<span class="token punctuation">.</span>out<span class="token punctuation">.</span><span class="token function">println</span><span class="token punctuation">(</span>user<span class="token punctuation">)</span><span class="token punctuation">;</span>

	User user2 <span class="token operator">=</span> <span class="token keyword">new</span> <span class="token class-name">User</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
	user2<span class="token punctuation">.</span><span class="token function">setName</span><span class="token punctuation">(</span><span class="token string">"唐僧"</span><span class="token punctuation">)</span><span class="token punctuation">.</span><span class="token function">setAge</span><span class="token punctuation">(</span><span class="token number">30</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
	<span class="token comment">//条件构造器 动态拼接where条件 原则: 根据对象中不为null的属性动态拼接where条件.</span>
	QueryWrapper queryWrapper <span class="token operator">=</span> <span class="token keyword">new</span> <span class="token class-name">QueryWrapper</span><span class="token punctuation">(</span>user2<span class="token punctuation">)</span><span class="token punctuation">;</span>
	<span class="token comment">//Sql: select xxx,xxx,xx from user where name="唐僧" and age=30</span>
	User user3 <span class="token operator">=</span> userMapper<span class="token punctuation">.</span><span class="token function">selectOne</span><span class="token punctuation">(</span>queryWrapper<span class="token punctuation">)</span><span class="token punctuation">;</span>
	System<span class="token punctuation">.</span>out<span class="token punctuation">.</span><span class="token function">println</span><span class="token punctuation">(</span>user3<span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token punctuation">}</span>

<span class="token comment">/**
 * 需求: 查询age&gt;18岁的 性别为女的用户  sex='女'
 * 特殊符号:  字段左侧 &gt; gt   &lt; lt   = eq
 * 		     &gt;= ge  &lt;= le
 */</span>
<span class="token annotation punctuation">@Test</span>
<span class="token keyword">public</span> <span class="token keyword">void</span> <span class="token function">testSelect02</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">{<!-- --></span>
	QueryWrapper queryWrapper <span class="token operator">=</span> <span class="token keyword">new</span> <span class="token class-name">QueryWrapper</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
	queryWrapper<span class="token punctuation">.</span><span class="token function">gt</span><span class="token punctuation">(</span><span class="token string">"age"</span><span class="token punctuation">,</span> <span class="token number">18</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
	queryWrapper<span class="token punctuation">.</span><span class="token function">eq</span><span class="token punctuation">(</span><span class="token string">"sex"</span><span class="token punctuation">,</span> <span class="token string">"女"</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
	List<span class="token generics function"><span class="token punctuation">&lt;</span>User<span class="token punctuation">&gt;</span></span> userList <span class="token operator">=</span> userMapper<span class="token punctuation">.</span><span class="token function">selectList</span><span class="token punctuation">(</span>queryWrapper<span class="token punctuation">)</span><span class="token punctuation">;</span>
	System<span class="token punctuation">.</span>out<span class="token punctuation">.</span><span class="token function">println</span><span class="token punctuation">(</span>userList<span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token punctuation">}</span>

<span class="token comment">/**
 * 案例3: 查询name中包含'精'字的用户,并且性别为女
 * 		  like %精%
 * 		  like 精%
 * 		  like %精
 */</span>
<span class="token annotation punctuation">@Test</span>
<span class="token keyword">public</span> <span class="token keyword">void</span> <span class="token function">testSelect03</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">{<!-- --></span>
	QueryWrapper queryWrapper <span class="token operator">=</span> <span class="token keyword">new</span> <span class="token class-name">QueryWrapper</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
	queryWrapper<span class="token punctuation">.</span><span class="token function">like</span><span class="token punctuation">(</span><span class="token string">"name"</span><span class="token punctuation">,</span> <span class="token string">"精"</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
	queryWrapper<span class="token punctuation">.</span><span class="token function">eq</span><span class="token punctuation">(</span><span class="token string">"sex"</span><span class="token punctuation">,</span> <span class="token string">"女"</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
	List<span class="token generics function"><span class="token punctuation">&lt;</span>User<span class="token punctuation">&gt;</span></span> userList <span class="token operator">=</span> userMapper<span class="token punctuation">.</span><span class="token function">selectList</span><span class="token punctuation">(</span>queryWrapper<span class="token punctuation">)</span><span class="token punctuation">;</span>
	System<span class="token punctuation">.</span>out<span class="token punctuation">.</span><span class="token function">println</span><span class="token punctuation">(</span>userList<span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token punctuation">}</span>

<span class="token comment">/**
 * 案例4: 要求age&gt;18岁, 并且name字段不为null的用户. 按照年龄降序排列.
 */</span>
<span class="token annotation punctuation">@Test</span>
<span class="token keyword">public</span> <span class="token keyword">void</span> <span class="token function">testSelect04</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">{<!-- --></span>
	QueryWrapper queryWrapper <span class="token operator">=</span> <span class="token keyword">new</span> <span class="token class-name">QueryWrapper</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
	queryWrapper<span class="token punctuation">.</span><span class="token function">gt</span><span class="token punctuation">(</span><span class="token string">"age"</span><span class="token punctuation">,</span> <span class="token number">18</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
	queryWrapper<span class="token punctuation">.</span><span class="token function">isNotNull</span><span class="token punctuation">(</span><span class="token string">"name"</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
	queryWrapper<span class="token punctuation">.</span><span class="token function">orderByDesc</span><span class="token punctuation">(</span><span class="token string">"age"</span><span class="token punctuation">)</span><span class="token punctuation">;</span>

	List<span class="token generics function"><span class="token punctuation">&lt;</span>User<span class="token punctuation">&gt;</span></span> userList <span class="token operator">=</span> userMapper<span class="token punctuation">.</span><span class="token function">selectList</span><span class="token punctuation">(</span>queryWrapper<span class="token punctuation">)</span><span class="token punctuation">;</span>
	System<span class="token punctuation">.</span>out<span class="token punctuation">.</span><span class="token function">println</span><span class="token punctuation">(</span>userList<span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token punctuation">}</span>

<span class="token comment">/**
 * 案例5:
 * 		 查询用户信息  有2个参数,但是2个参数可能部分为null 动态查询
 * 		 根据sex和age查询  sex  和 age 可能为null???
 * 		 逻辑运算符  age &gt; 18  and sex="女"
 *
 */</span>
<span class="token annotation punctuation">@Test</span>
<span class="token keyword">public</span> <span class="token keyword">void</span> <span class="token function">testSelect05</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">{<!-- --></span>
	User user <span class="token operator">=</span> <span class="token keyword">new</span> <span class="token class-name">User</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">;</span>	<span class="token comment">//模拟用户传参</span>
	user<span class="token punctuation">.</span><span class="token function">setAge</span><span class="token punctuation">(</span><span class="token number">18</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
	<span class="token comment">//user.setSex("女");</span>

	QueryWrapper queryWrapper <span class="token operator">=</span> <span class="token keyword">new</span> <span class="token class-name">QueryWrapper</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">;</span>

	<span class="token comment">//动态sql写法 condition如何条件为true时,该条件才拼接.</span>
	queryWrapper<span class="token punctuation">.</span><span class="token function">gt</span><span class="token punctuation">(</span>user<span class="token punctuation">.</span><span class="token function">getAge</span><span class="token punctuation">(</span><span class="token punctuation">)</span> <span class="token operator">!=</span>null <span class="token operator">&amp;&amp;</span> user<span class="token punctuation">.</span><span class="token function">getAge</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token operator">&gt;</span><span class="token number">0</span><span class="token punctuation">,</span> <span class="token string">"age"</span><span class="token punctuation">,</span> user<span class="token punctuation">.</span><span class="token function">getAge</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
	queryWrapper<span class="token punctuation">.</span><span class="token function">eq</span><span class="token punctuation">(</span><span class="token operator">!</span><span class="token string">""</span><span class="token punctuation">.</span><span class="token function">equals</span><span class="token punctuation">(</span>user<span class="token punctuation">.</span><span class="token function">getSex</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">)</span> <span class="token operator">&amp;&amp;</span> user<span class="token punctuation">.</span><span class="token function">getSex</span><span class="token punctuation">(</span><span class="token punctuation">)</span> <span class="token operator">!=</span>null<span class="token punctuation">,</span><span class="token string">"sex"</span><span class="token punctuation">,</span>user<span class="token punctuation">.</span><span class="token function">getSex</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">;</span>

	List<span class="token generics function"><span class="token punctuation">&lt;</span>User<span class="token punctuation">&gt;</span></span> userList <span class="token operator">=</span> userMapper<span class="token punctuation">.</span><span class="token function">selectList</span><span class="token punctuation">(</span>queryWrapper<span class="token punctuation">)</span><span class="token punctuation">;</span>
	System<span class="token punctuation">.</span>out<span class="token punctuation">.</span><span class="token function">println</span><span class="token punctuation">(</span>userList<span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token punctuation">}</span>

<span class="token comment">/**
 * 案例6:
 * 		查询用户Id = 1,3,5,6,7
 * Sql: select * from user where id in (1,3,5,6,7)
 */</span>
<span class="token annotation punctuation">@Test</span>
<span class="token keyword">public</span> <span class="token keyword">void</span> <span class="token function">testSelect06</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">{<!-- --></span>
	<span class="token comment">//规则: 如果数组需要转化集合则使用包装类型</span>
	Integer<span class="token punctuation">[</span><span class="token punctuation">]</span> ids <span class="token operator">=</span> <span class="token punctuation">{<!-- --></span><span class="token number">1</span><span class="token punctuation">,</span><span class="token number">3</span><span class="token punctuation">,</span><span class="token number">5</span><span class="token punctuation">,</span><span class="token number">6</span><span class="token punctuation">,</span><span class="token number">7</span><span class="token punctuation">}</span><span class="token punctuation">;</span>
	<span class="token comment">//将数组转化为集合</span>
	List<span class="token generics function"><span class="token punctuation">&lt;</span>Integer<span class="token punctuation">&gt;</span></span> idList <span class="token operator">=</span> Arrays<span class="token punctuation">.</span><span class="token function">asList</span><span class="token punctuation">(</span>ids<span class="token punctuation">)</span><span class="token punctuation">;</span>
	QueryWrapper queryWrapper <span class="token operator">=</span> <span class="token keyword">new</span> <span class="token class-name">QueryWrapper</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
	queryWrapper<span class="token punctuation">.</span><span class="token function">in</span><span class="token punctuation">(</span><span class="token string">"id"</span><span class="token punctuation">,</span>idList<span class="token punctuation">)</span><span class="token punctuation">;</span>
	List<span class="token generics function"><span class="token punctuation">&lt;</span>User<span class="token punctuation">&gt;</span></span> userList <span class="token operator">=</span> userMapper<span class="token punctuation">.</span><span class="token function">selectList</span><span class="token punctuation">(</span>queryWrapper<span class="token punctuation">)</span><span class="token punctuation">;</span>
	<span class="token comment">//方法2:</span>
	List<span class="token generics function"><span class="token punctuation">&lt;</span>User<span class="token punctuation">&gt;</span></span> userList2 <span class="token operator">=</span> userMapper<span class="token punctuation">.</span><span class="token function">selectBatchIds</span><span class="token punctuation">(</span>idList<span class="token punctuation">)</span><span class="token punctuation">;</span>
	System<span class="token punctuation">.</span>out<span class="token punctuation">.</span><span class="token function">println</span><span class="token punctuation">(</span>userList<span class="token punctuation">)</span><span class="token punctuation">;</span>
	System<span class="token punctuation">.</span>out<span class="token punctuation">.</span><span class="token function">println</span><span class="token punctuation">(</span>userList2<span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token punctuation">}</span>

<span class="token comment">/**
 * 删除name为null的数据
 */</span>
<span class="token annotation punctuation">@Test</span>
<span class="token keyword">public</span> <span class="token keyword">void</span> <span class="token function">delete</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">{<!-- --></span>
	QueryWrapper queryWrapper <span class="token operator">=</span> <span class="token keyword">new</span> <span class="token class-name">QueryWrapper</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
	queryWrapper<span class="token punctuation">.</span><span class="token function">isNull</span><span class="token punctuation">(</span><span class="token string">"name"</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
	userMapper<span class="token punctuation">.</span><span class="token function">delete</span><span class="token punctuation">(</span>queryWrapper<span class="token punctuation">)</span><span class="token punctuation">;</span>
	System<span class="token punctuation">.</span>out<span class="token punctuation">.</span><span class="token function">println</span><span class="token punctuation">(</span><span class="token string">"删除成功!!!"</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token punctuation">}</span>

<span class="token comment">/**
 * 更新操作
 * 案例1:  将id=74的用户的名称改为 你好SpringBoot age=18 sex="其他"
 * 案例2:  将name="测试Mybatis" 的数据改为 age=100 sex=男
 */</span>
<span class="token annotation punctuation">@Test</span>
<span class="token keyword">public</span> <span class="token keyword">void</span> <span class="token function">update</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">{<!-- --></span>
	User user <span class="token operator">=</span> <span class="token keyword">new</span> <span class="token class-name">User</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
	user<span class="token punctuation">.</span><span class="token function">setId</span><span class="token punctuation">(</span><span class="token number">74</span><span class="token punctuation">)</span><span class="token punctuation">.</span><span class="token function">setName</span><span class="token punctuation">(</span><span class="token string">"你好SpringBoot"</span><span class="token punctuation">)</span><span class="token punctuation">.</span><span class="token function">setAge</span><span class="token punctuation">(</span><span class="token number">18</span><span class="token punctuation">)</span><span class="token punctuation">.</span><span class="token function">setSex</span><span class="token punctuation">(</span><span class="token string">"其他"</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
	<span class="token comment">//Sql: update user set name="xxx", age=18,sex='xx' where id=xx</span>
	<span class="token comment">//Sql形成的原则 根据对象中不为null的属性当做  set条件. 并且将Id当做where条件</span>
	userMapper<span class="token punctuation">.</span><span class="token function">updateById</span><span class="token punctuation">(</span>user<span class="token punctuation">)</span><span class="token punctuation">;</span>

	User userTemp <span class="token operator">=</span> <span class="token keyword">new</span> <span class="token class-name">User</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
	userTemp<span class="token punctuation">.</span><span class="token function">setAge</span><span class="token punctuation">(</span><span class="token number">100</span><span class="token punctuation">)</span><span class="token punctuation">.</span><span class="token function">setSex</span><span class="token punctuation">(</span><span class="token string">"男"</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
	UpdateWrapper<span class="token generics function"><span class="token punctuation">&lt;</span>User<span class="token punctuation">&gt;</span></span> updateWrapper <span class="token operator">=</span> <span class="token keyword">new</span> <span class="token class-name">UpdateWrapper</span><span class="token operator">&lt;</span><span class="token operator">&gt;</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
	updateWrapper<span class="token punctuation">.</span><span class="token function">eq</span><span class="token punctuation">(</span><span class="token string">"name"</span><span class="token punctuation">,</span> <span class="token string">"测试Mybatis"</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
	userMapper<span class="token punctuation">.</span><span class="token function">update</span><span class="token punctuation">(</span>userTemp<span class="token punctuation">,</span>updateWrapper<span class="token punctuation">)</span><span class="token punctuation">;</span>
	System<span class="token punctuation">.</span>out<span class="token punctuation">.</span><span class="token function">println</span><span class="token punctuation">(</span><span class="token string">"更新成功!!!"</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token punctuation">}</span>
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130
  • 131
  • 132
  • 133
  • 134
  • 135
  • 136
  • 137
  • 138

2.SpringBoot整合Web资源

2.1 创建项目

在这里插入图片描述

2.2 添加新jar包文件

<!--springBoot整合JSP添加依赖  -->
		<!--servlet依赖 -->
		<dependency>
			<groupId>javax.servlet</groupId>
			<artifactId>javax.servlet-api</artifactId>
		</dependency>

	<span class="token operator">&lt;</span><span class="token operator">!</span><span class="token operator">--</span>jstl依赖 <span class="token operator">--</span><span class="token operator">&gt;</span>
	<span class="token generics function"><span class="token punctuation">&lt;</span>dependency<span class="token punctuation">&gt;</span></span>
		<span class="token generics function"><span class="token punctuation">&lt;</span>groupId<span class="token punctuation">&gt;</span></span>javax<span class="token punctuation">.</span>servlet<span class="token operator">&lt;</span><span class="token operator">/</span>groupId<span class="token operator">&gt;</span>
		<span class="token generics function"><span class="token punctuation">&lt;</span>artifactId<span class="token punctuation">&gt;</span></span>jstl<span class="token operator">&lt;</span><span class="token operator">/</span>artifactId<span class="token operator">&gt;</span>
	<span class="token operator">&lt;</span><span class="token operator">/</span>dependency<span class="token operator">&gt;</span>

	<span class="token operator">&lt;</span><span class="token operator">!</span><span class="token operator">--</span>使jsp页面生效 html jsp<span class="token operator">--</span><span class="token operator">&gt;</span>
	<span class="token generics function"><span class="token punctuation">&lt;</span>dependency<span class="token punctuation">&gt;</span></span>
		<span class="token generics function"><span class="token punctuation">&lt;</span>groupId<span class="token punctuation">&gt;</span></span>org<span class="token punctuation">.</span>apache<span class="token punctuation">.</span>tomcat<span class="token punctuation">.</span>embed<span class="token operator">&lt;</span><span class="token operator">/</span>groupId<span class="token operator">&gt;</span>
		<span class="token generics function"><span class="token punctuation">&lt;</span>artifactId<span class="token punctuation">&gt;</span></span>tomcat<span class="token operator">-</span>embed<span class="token operator">-</span>jasper<span class="token operator">&lt;</span><span class="token operator">/</span>artifactId<span class="token operator">&gt;</span>
	<span class="token operator">&lt;</span><span class="token operator">/</span>dependency<span class="token operator">&gt;</span>
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18

2.3 添加web资源页面

说明: 在springBoot项目的根目录中添加webapp文件目录.格式如下
在这里插入图片描述
2).修改打包方式
在这里插入图片描述

2.4 编辑YML配置文件

server:
  port: 8090
  servlet:
    #项目默认发布路径/根目录
    context-path: /

#SpringBoot数据源配置
spring:
datasource:
url: jdbc:mysql://127.0.0.1:3306/jtdb?serverTimezone=GMT%2B8&useUnicode=true&characterEncoding=utf8&autoReconnect=true&allowMultiQueries=true
username: root
password: root

#配置SpringMVC的视图解析器
mvc:
view:
prefix: /WEB-INF/ # /默认代表根目录 src/main/webapp
suffix: .jsp

#SpringBoot整合Mybatis-plus
mybatis-plus:
#定义别名包 作用: 以后封装POJO对象时自动进行拼接
type-aliases-package: com.jt.pojo
#引入mapper配置文件
mapper-locations: classpath:/mybatis/mappers/*.xml
#开启驼峰映射
configuration:
map-underscore-to-camel-case: true

#打印MybatisPlus执行sql日志
logging:
level:
com.jt.mapper: debug

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33

2.5 业务需求说明

用户通过网址: http://localhost:8090/findAll 要求跳转到userList.jsp页面中 之后展现数据库user表所有记录.

2.6 修改工作目录

在这里插入图片描述

2.7 编辑UserController

package com.jt.controller;

import com.jt.pojo.User;
import com.jt.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.bind.annotation.RestController;

import javax.servlet.http.HttpServletRequest;
import java.util.List;

//@RestController //1.返回数据是JSON数据 2.表示Ajax请求的结束 3.返回值的是字符串本身
// 4.不会执行SpringMVC中的组件 视图解析器
@Controller //跳转到指定的页面中 会执行视图解析器 进行路径的拼接 前缀+后缀
public class UserController { 

<span class="token annotation punctuation">@Autowired</span>
<span class="token keyword">private</span> UserService userService<span class="token punctuation">;</span>

<span class="token comment">/**
 * 请求用户请求: http://localhost:8090/findAll
 * 参数:  暂时没有
 * 返回值: 特定页面名称
 * 前缀:  /WEB-INF/
 * 页面名称: userList
 *  后缀: .jsp
 */</span>

<span class="token comment">//方式: 页面同步请求的方法</span>
<span class="token annotation punctuation">@RequestMapping</span><span class="token punctuation">(</span><span class="token string">"/findAll"</span><span class="token punctuation">)</span>
<span class="token keyword">public</span> String <span class="token function">findAll</span><span class="token punctuation">(</span>Model model<span class="token punctuation">)</span><span class="token punctuation">{<!-- --></span>
    List<span class="token generics function"><span class="token punctuation">&lt;</span>User<span class="token punctuation">&gt;</span></span> userList <span class="token operator">=</span> userService<span class="token punctuation">.</span><span class="token function">findAll</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
    <span class="token comment">//目的:需要通过request对象将数据带到页面中进行展现</span>

    model<span class="token punctuation">.</span><span class="token function">addAttribute</span><span class="token punctuation">(</span><span class="token string">"userList"</span><span class="token punctuation">,</span>userList<span class="token punctuation">)</span><span class="token punctuation">;</span>
    <span class="token comment">//springMVC中采用视图解析器的形式 添加 前缀+后缀</span>
    <span class="token keyword">return</span> <span class="token string">"userList"</span><span class="token punctuation">;</span>  <span class="token comment">//返回页面逻辑名称</span>
<span class="token punctuation">}</span>

}

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43

2.8 编辑UserService

package com.jt.service;

import com.jt.mapper.UserMapper;
import com.jt.pojo.User;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class UserServiceImpl implements UserService{ 

<span class="token annotation punctuation">@Autowired</span>
<span class="token keyword">private</span> UserMapper userMapper<span class="token punctuation">;</span>

<span class="token annotation punctuation">@Override</span>
<span class="token keyword">public</span> List<span class="token generics function"><span class="token punctuation">&lt;</span>User<span class="token punctuation">&gt;</span></span> <span class="token function">findAll</span><span class="token punctuation">(</span><span class="token punctuation">)</span> <span class="token punctuation">{<!-- --></span>

    <span class="token keyword">return</span> userMapper<span class="token punctuation">.</span><span class="token function">selectList</span><span class="token punctuation">(</span>null<span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token punctuation">}</span>

}

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22

2.9 页面效果展现

在这里插入图片描述

2.4 知识盲区

1）WEB-INF 是什么? 保护页面资源 所有的请求都必须经过Controller中转, 用户不能直接访问页面

3 Web资源异步调用

3.1 业务说明

1.要求用户通过http://localhost:8090/toAjax请求,实现页面的跳转 ajax.jsp页面中

3.2 编辑UserController

说明:编辑UserController 实现页面跳转

 /**
     * 异步请求: 多次请求 多次响应
     * 实现页面跳转
     * URL网址: http://localhost:8090/toAjax
     * 跳转页面名称: ajax.jsp
     */
    @RequestMapping("/toAjax")
    public String toAjax(){

    <span class="token comment">//返回的应该是页面的逻辑名称</span>
    <span class="token keyword">return</span> <span class="token string">"ajax"</span><span class="token punctuation">;</span>
<span class="token punctuation">}</span>
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12

3.3 关于Ajax说明

问题: 为什么Ajax可以实现异步调用呢???
同步和异步加载机制区别
核心部件: Ajax引擎
在这里插入图片描述

3.3 导入函数类库

1).复制JS到指定的目录中
在这里插入图片描述

3.4 编辑ajax.jsp页面

<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
	<!-- 导入函数类库 -->
	<script src="../js/jquery-3.4.1.min.js"></script>

<span class="token operator">&lt;</span><span class="token operator">!</span><span class="token operator">--</span> 编辑页面<span class="token constant">JS</span> <span class="token operator">--</span><span class="token operator">&gt;</span>
<span class="token operator">&lt;</span>script<span class="token operator">&gt;</span>
	<span class="token comment">//让页面加载完成之后 再执行</span>
	<span class="token function">$</span><span class="token punctuation">(</span><span class="token keyword">function</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">{<!-- --></span>
		
		<span class="token comment">/**
		 * 常见ajax种类:
		 * 		$.get("url地址","传递的参数",回调函数,返回值类型)
		 * 		$.post("url地址","传递的参数",回调函数,返回值类型)
		 * 		$.getJSON("url地址","传递的参数",回调函数)
		 * 		$.ajax({.....})
		 */</span>
		
		<span class="token comment">/* 1.ajax常规用法 get请求
			
			参数说明: 
				1.url地址     写法1: http://host:port/xxxx请求路径 跨域请求方式(别人的服务器)
							  写法2:	/xxxx		同域请求  访问的自己的服务器
							  
				2.参数写法	  
							  写法1:	 {key1:value1,key2:value2}  {"id":1000}
							  写法2:  key1=value1&amp;key2=value2    "id=1000&amp;name=tomcat"
				3.回调函数
		 */</span>
		$<span class="token punctuation">.</span><span class="token keyword">get</span><span class="token punctuation">(</span><span class="token string">"/ajaxUser"</span><span class="token punctuation">,</span><span class="token string">"id=1000&amp;name=tomcat"</span><span class="token punctuation">,</span><span class="token keyword">function</span><span class="token punctuation">(</span>result<span class="token punctuation">)</span><span class="token punctuation">{<!-- --></span>
			<span class="token comment">//console.log(result)</span>
			<span class="token comment">//alert("回调函数执行成功!!!!")</span>
			<span class="token comment">//将返回值结果进行处理</span>
			
			<span class="token comment">/* 基础for循环
			for(let i=0;i&lt;result.length; i++){
				console.log(result[i])
			} */</span>
			
			<span class="token comment">/* 增强for循环 in 表示将小标传递给index  */</span>
			<span class="token comment">/* for(let index in result){
				console.log(result[index])
			} */</span>
			
			<span class="token comment">/* of 将result集合的元素赋值给user */</span>
			<span class="token keyword">for</span><span class="token punctuation">(</span><span class="token keyword">let</span> user <span class="token keyword">of</span> result<span class="token punctuation">)</span><span class="token punctuation">{<!-- --></span>
				<span class="token keyword">let</span> id <span class="token operator">=</span> user<span class="token punctuation">.</span>id
				<span class="token keyword">let</span> name <span class="token operator">=</span> user<span class="token punctuation">.</span>name
				<span class="token keyword">let</span> age <span class="token operator">=</span> user<span class="token punctuation">.</span>age
				<span class="token keyword">let</span> sex <span class="token operator">=</span> user<span class="token punctuation">.</span>sex
				<span class="token keyword">let</span> tr <span class="token operator">=</span> <span class="token string">"&lt;tr align='center'&gt;&lt;td&gt;"</span><span class="token operator">+</span>id<span class="token operator">+</span><span class="token string">"&lt;/td&gt;&lt;td&gt;"</span><span class="token operator">+</span>name<span class="token operator">+</span><span class="token string">"&lt;/td&gt;&lt;td&gt;"</span><span class="token operator">+</span>age<span class="token operator">+</span><span class="token string">"&lt;/td&gt;&lt;td&gt;"</span><span class="token operator">+</span>sex<span class="token operator">+</span><span class="token string">"&lt;/td&gt;&lt;/tr&gt;"</span>
				<span class="token comment">//将tr元素追加到表格中</span>
				<span class="token function">$</span><span class="token punctuation">(</span><span class="token string">"#tab1"</span><span class="token punctuation">)</span><span class="token punctuation">.</span><span class="token function">append</span><span class="token punctuation">(</span>tr<span class="token punctuation">)</span>
			<span class="token punctuation">}</span>
		<span class="token punctuation">}</span><span class="token punctuation">)</span>
		
		
		
	<span class="token punctuation">}</span><span class="token punctuation">)</span>
<span class="token operator">&lt;</span><span class="token operator">/</span>script<span class="token operator">&gt;</span>

<title>您好Springboot</title>
</head>
<body>
<table id=“tab1” border=“1px” width=“65%” align=“center”>
<tr>
<td colspan=“6” align=“center”><h3>学生信息</h3></td>
</tr>
<tr>
<th>编号</th>
<th>姓名</th>
<th>年龄</th>
<th>性别</th>
</tr>
</table>
</body>
</html>

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80

3.5 编辑UserController

说明:实现页面ajax数据请求

 /**
     * 实现ajax业务调用
     * URL地址:  /ajaxUser
     * 参数:     id/name属性
     * 返回值:   List<User>
     */
    @RequestMapping("/ajaxUser")
    @ResponseBody
    public List<User> ajaxUser(Integer id,String name){
        System.out.println("id参数:"+id);
        System.out.println("name参数:"+name);
        return userService.findAll();
    }

 
 

 
 
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
zyxwz~
关注
CGB2011-DAY02.html
03-12
CGB2011-DAY02.html
Field XXX in XXXX required a bean of type XXXX that could not be found
weixin_34288121的博客
05-02 2万+
2019独角兽企业重金招聘Python工程师标准>>> ...
XXXXXXXXXXX
roroyangivan的专栏
10-31 8万+
package thread; public class VolatileTest { public static volatile int race = 0; public static void increase(){ race++; } private static final int THREAD_COUNT = 20; public
Sex boosts brain growth, study suggests
cindylu520的专栏
07-30 1万+
Sex apparently can help the brain grow, according to new findings in rats. Past findings had shown that stressful, unpleasant events could stifle brain cell growth in adults. To see if pleasant albei...
Third season twenty-fifth episode,a lot of interesting things happened on the beach....
xiyangxia666hui的博客
10-28 5852
[Scene: Central Perk, everyone except Phoebe is there. Bonnie is telling them of her sex-capades.] Chandler: (to Bonnie) So ah, your first sexual experience was with a woman?! Bonnie: All right, I was 15, it was my best friend, Ruth, and we got drunk on th
Gson的一些笔记
lys1695227550的博客
03-18 5020
package entity;import java.util.HashMap;import java.util.List;import java.util.Map;public class Student {        private String userName;    private String sex;    private int age;    private List&lt;...
CGB2011-DAY13-14.html
03-30
CGB2011-DAY13-14.html
CGB1904-03:超市会员管理系统
03-11
＃超市会员管理系统＃07-18 ...会员信息表：member※增加盐分会员类别表：member_grade礼品表：礼物礼品兑换记录表：exchange_record商品表：商品商品购买记录表：transaction_record管理员账户表：admin※增加盐分 ...
cgb
02-17
cgb
基于Javascript的cgb网页设计源码
最新发布
05-23
cgb是一个基于Javascript开发的网页项目，包含84个文件，其中包括61个HTML文件、13个JavaScript文件、3个CSS文件、2个JPG图片文件、1个Git忽略文件、1个XML文件、1个JFIF图片文件、1个PNG图片文件和1个Vue文件。...
15 Awesome Sites with Stuning Stock HD Videos
热门推荐
上帝已逝，自求多福
03-05 43万+
From:http://www.createthebridge.com/blog/free-hd-video-and-video-clips/ On our previous blog post, 27 Sites for Awesome Free Stock Photos, we talked about the importance of carefully choosing the i
以開源碼 dansguardian+tinyproxy 實作色情守門員
jasenwan88的专栏
07-14 5308
前言 相信每個父母都曾有這樣的經驗：小孩子躱在房裏通宵達旦的衝浪。您會很好奇，到底是什麼樣的網站可以讓人這麼無怨無悔，廢寢忘食。而在網路犯罪事件層出不窮的今日，更會擔心自己的心肝寶貝因涉世未深，而無法拒絕網路上的誘惑，甚至發生無法彌補的遺憾。因此，坊間有一些 ISP 業者提供如「色情守門員」服務來過濾不當的網頁。對岸前一陣子鬧的沸沸揚揚的「綠霸」事件（規定新出廠的電腦上要預先安裝過濾軟體，以過濾
Sex, crimes, and common sense: framing femininity from sensation to sexology【翻译】
hongfu951的专栏
03-05 1万+
ABSTRACT My dissertation tracks the production of "common sense" about female sexuality and psychology in nineteenth-century sensational British literature. I move from the sensation novel’s heyday, r...
封装及其相关
weixin_44282898的博客
02-20 4004
封装     字面意思 把什么东西装到容器 在封闭起来     与隐藏有相似之处 但不是单纯的隐藏 官方解释：对外部隐藏实现细节，并提供简单的使用接口 封装的好处 1.提高安全性  封装关键数据来实现 2.隔离复杂度  封装一些内部的实现逻辑（方法）来实现 python中的属性访问权限 1.公开的（默认） 在任何地方都能访问到 2.私有的  仅在类内部可以使用 如何封装:     使用特殊语...
Second season twelfth and thirteenth episode,what happened in the search for Marcel?
xiyangxia666hui的博客
09-20 2万+
[Scene: In a TV commercial that the gang is watching at Monica and Rachel's.] [A guy is sitting at his desk and his boss comes in and drops a huge pile of papers on his desk. The guy looks dejected.] COMMERCIAL VOICEOVER: Can't get the monkey off your back
Mybatis：Parameter ‘xxx‘ not found. Available parameters are ***
qq_44309969的博客
01-13 122
Mybatis：Parameter ‘xxx’ not found. Available parameters are *** 错误演示： public interface UserDao { User selectUser(String name, String sex); } <select id="selectUser" resultType="User"> select * from user WHERE name=#{name} AND sex
java标准类的制作
weixin_45090657的博客
08-25 2285
创建对象并为对象赋值有两种方式 1.无参构造方法创建对象后使用sexXxx()赋值 2.使用带参构造方法直接创建带有属性值的对象 测试类 package com.itheima_04; //p114 标准类的制作 public class Student { private String name; private int age; // 构造方法 public Student(){}//无参 public Student(String name,int age){//
json解析出现：java.lang.ClassCastException: net.sf.ezmorph.bean.MorphDynaBean cannot be cast to XXX
one_ink的博客
08-20 4946
一、出错原因 当我们利用json解析中的toBean方法时，如果它的属性里面包含复杂对象，那么在我们调用这个复杂对象时就会出现这个错误：java.lang.ClassCastException: net.sf.ezmorph.bean.MorphDynaBean cannot be cast to XXX 二、出错场景 student类，里面有姓名、性别和年龄三个属性和它们对应的get、set方法...
JavaScript快速入门
liuwushuang233的博客
06-23 1044
2.外部引入 qj.js 引入 测试 2.基本语法入门 3.数据类型 数值，文本，图形，音频，视频。。。变量 numberjs不区分小数和整数,Number 字符串‘abc’ “abc”‘\n’布尔值true , false逻辑运算&& 两个都为真结果为真|| 一个为真结果为真！取反比较运算符=赋值==等于（类型不一样，值一样，，会判断为true）===绝对等于（类型一样值一样，结果为true）注意：NaN===NaN，这个与所有的数值都不相等，包括自己，只能通过isNaN判断浮点数问题 尽量避免使
cgb76635@gmail.com
11-11
很抱歉，根据提供的引用内容，我无法回答关于"cgb76635@gmail.com"的问题。引用提到了@RestController注解和其返回JSON、XML或其他文本的特性，引用则提到了跨域问题。如果您有关于这些内容的问题，我可以为您解答。...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值