思途实训-day02

最新推荐文章于 2020-01-16 22:22:08 发布

爱敲代码的小黄

最新推荐文章于 2020-01-16 22:22:08 发布

阅读量335

点赞数

分类专栏：随笔

本文链接：https://blog.csdn.net/qq_40915439/article/details/103980780

版权

随笔专栏收录该内容

10 篇文章 4 订阅

订阅专栏

欢迎访问我的个人博客：苦酒

思途实训-day02

上午

杜老师带我们写出了剩下的两个模块，分别是controller和serivce

Departmentcontroller.java

package com.situ.company.department.controller;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import com.situ.company.department.model.DepartmentModel;
import com.situ.company.department.service.DepartmentService;


@RestController
@RequestMapping("department")
public class DepartmentController 
{
   @Autowired
   private DepartmentService service;
   
   @RequestMapping("insert")
   public int insert(DepartmentModel model)
   {
   	
   	return service.insert(model);
   }
   
   @RequestMapping("delect")
   public int delect(DepartmentModel model)
   {
   	return service.delect(model);
   }
   
   @RequestMapping("updata")
   public int updata(DepartmentModel model)
   {
   	return service.updata(model);
   }
   
   @RequestMapping("selectmodel")
   public DepartmentModel selectmodel(DepartmentModel model)
   {
   	return service.selectModel(model);
   }
   
   @RequestMapping("selectList")
   public List<DepartmentModel> select(DepartmentModel model)
   {
   	return service.selectList(model);
   }
}

DepartmentSerivce.java

package com.situ.company.department.service;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.situ.company.department.mapper.DepartmentMapper;
import com.situ.company.department.model.DepartmentModel;


@Service
public class DepartmentService 
{
	@Autowired
	private DepartmentMapper mapper;
	
	public int insert(DepartmentModel model) 
	{
		DepartmentModel mdb = selectModel(model);
		if(mdb == null)
		{
			return mapper.insert(model);
		}
		else
		{
			return -1;
		}
	}
	
    
    public int delect(DepartmentModel model) 
	{
		return mapper.Delete(model);
	}
	
	public int updata(DepartmentModel model) 
	{
		return mapper.updata(model);
	}
	
	public DepartmentModel selectModel(DepartmentModel model) 
	{
		return mapper.selectModel(model);
	}
	
	public List<DepartmentModel> selectList(DepartmentModel model) 
	{
		String name = model.getName();
		if(name == null)//此处的null必须变成“”，否则下面的setName拼接成的为%null%   查询的是name中含有name的字符
		{
			name = "";
		}
		model.setName('%' + name + '%');
		return mapper.selectList(model);
	}
}

Model模块是建立私有化的数据类型，相当于建立数据库中的对应数据。
Mapper模块在Model基础上进行数据库（sql）语句的编辑（增删改查）
Service模块在Mapper基础上进行一些逻辑化的操作。例如：id（主键）和code（非主键），但我想让code的值是唯一的，这时候需要用到Service模块的的操作，代码如下：

public int insert(DepartmentModel model) 
   {
   	DepartmentModel mdb = selectModel(model);
   	if(mdb == null)
   	{
   		return mapper.insert(model);
   	}
   	else
   	{
   		return -1;
   	}
   }

最后是Controller模块，这个模块对应的是网页端，给网页服务的。

@RequestMapping("insert")

这个地方的insert和网页的请求一样，不能写错。
3.

下午

老师讲解使用网页端来进行数据库的增删改查

刚开始，老师直接使用在网址中输入的命令

http://127.0.0.1:8080/company/department/insert?code=1&name=hls&tel=17852031547

然后直接转到网页端，新建一个html文件，文件代码如下：

<!DOCTYPE html>
<html>
	<head>
		<meta charset="UTF-8">
		<title>Insert title here</title>
		<script type="text/javascript" src="/company/base/js/jquery-3.3.1.min.js"></script>
	<style>
			body {
				background-image:url('9.jpg');
				height: 100%;
  				width: 100%;
  				background-size: cover;
 				position: absolute;
  				overflow: hidden;
				 }
			#login{
				width:400px;
				height:280px;
				position:absolute;
				left: 50%;
				top: 40%;
				margin-left:-200px;
				margin-top:-140px;
				border:1px;
				align:center;
				}
			#form{
				width:300px;
				height:160px;
				position:relative;
				left:50%;
				top:40%;
				margin-left:-150px;
				margin-top:-80px;
				}
			#img{
				width:300px;
				height:160px;
				position:relative;
				left:55%;
				top:29.4%;
				margin-left:-150px;
				margin-top:-80px;
			}
			#bu1{
				background-color: black;
				width:50px;
				height:40px;
			}
			#bu2{
				background-color: black;
				width:50px;
				height:40px;
			}
			#bu3{
				background-color: black;
				width:100px;
				height:40px;
			}
		</style>
	</head> 
	<body>
	<div id = "img">
	<img src="8.jpg" width="165" height="60" />
	</div>
	<div id = "login">
	<div id = "form">
		<form>
		<h3 align="center" style="color:green" >部门注册系统</h3>
		*&nbsp;&nbsp;账&nbsp;&nbsp;号： <input type='text' name = 'code'><br><br>
		*&nbsp;&nbsp;名&nbsp;&nbsp;称： <input type='text' name = 'name'><br><br>
		*&nbsp;&nbsp;电&nbsp;&nbsp;话： <input type='text' name = 'tel'><br>
		<br>
		&nbsp;&nbsp;<input id = "bu1" style = "color: white" type="button" value="注册" onclick="test()">
		&nbsp;&nbsp;&nbsp;&nbsp;<input id = "bu2" style = "color: white" type="button" value="重置" onclick="test1()">
		&nbsp;&nbsp;&nbsp;&nbsp;<input id = "bu3" style = "color: white" type="button" value="成员注册页面"   onclick="test2()">
		</form>
	</div>
	</div>
	</body>
	<script type="text/javascript">
	function test1()
	{
		window.location.href="http://127.0.0.1:8080/company/web/department.html";
	}
	function test() 
	{
		var code = $("input[name='code']").val();
		var name = $("input[name='name']").val();
		var tel = $("input[name='tel']").val();
//htpp://127.0.0.1:8080/company/department/insert?code=a1&name=a2&pass=a3
		$.ajax({
			url:'/company/department/insert', 
			//data:'code='+code+'&name='+name+'&pass='+pass,  //从网页端到java发送的请求参数
			data:{code:code,name:name,tel:tel},
			dataType:'json', //返回的数据类型 java返回至网页端
			type:'post', //请求的方式
			success:function(d)
			{
				console.log(d)
			}
		})
	}
	function test2(){
	 window.open('http://127.0.0.1:8080/company/web/Employee.html');
	}
	</script>
</html>