JavaWeb利用HTML部署页面做CRUD部门信息的准备------JavaWeb

不念不忘少年蓝@ 2024-02-29 01:48 33阅读 0赞

![2c0a2e8d3e95475bb8bb899ace239c46.png][]

![506e27b6f26e420b9a1d6ce6dc1708ab.png][]

![94380618c462441986c700822525ccde.png][]

![8e22ddcc3c824d3b91d2df151768712a.png][]

![93d33fea62d446e597011a5a47b8c00d.png][]

>     DROP TABLE IF EXISTS departments;
>     CREATE TABLE departments(deptno INT PRIMARY KEY,dname VARCHAR(255),loc VARCHAR(255));
>     INSERT INTO departments(deptno,dname,loc) VALUES(10,'销售部','北京');
>     INSERT INTO departments(deptno,dname,loc) VALUES(20,'研发部','上海');
>     INSERT INTO departments(deptno,dname,loc) VALUES(30,'技术部','广州');
>     INSERT INTO departments(deptno,dname,loc) VALUES(40,'媒体部','深圳');
>     COMMIT;
>     SELECT * FROM departments;
> 
> DROP TABLE IF EXISTS departments;  
> CREATE TABLE departments(deptno INT PRIMARY KEY,dname VARCHAR(255),loc VARCHAR(255));  
> INSERT INTO departments(deptno,dname,loc) VALUES(10,'销售部','北京');  
> INSERT INTO departments(deptno,dname,loc) VALUES(20,'研发部','上海');  
> INSERT INTO departments(deptno,dname,loc) VALUES(30,'技术部','广州');  
> INSERT INTO departments(deptno,dname,loc) VALUES(40,'媒体部','深圳');  
> COMMIT;  
> SELECT \* FROM departments;

>     <!DOCTYPE html>
>     <html>
>     	<head>
>     		<meta charset="utf-8">
>     		<title>部门列表</title>
>     	</head>
>     	<body>
>     		<h1>部门列表</h1>
>     		<hr>	
>     		<table border="1px" align="center" width="50%">
>     			<tr>
>     				<th>Header</th>
>     				<th>部门编号</th>
>     				<th>部门名称</th>
>     				<th>操作</th>
>     			</tr>
>     			<tr>
>     				<td>1</td>
>     				<td>10</td>
>     				<td>销售部</td>
>     				<td>
>     					<a href="">删除</a>
>     					<a href="">修改</a>
>     					<a href="">详情</a>
>     				</td>
>     			</tr>
>     			<tr>
>     				<td>2</td>
>     				<td>20</td>
>     				<td>研发部</td>
>     				<td>
>     					<a href="">删除</a>
>     					<a href="">修改</a>
>     					<a href="">详情</a>
>     				</td>
>     			</tr>
>     			<tr>
>     				<td>3</td>
>     				<td>30</td>
>     				<td>运营部</td>
>     				<td>
>     					<a href="">删除</a>
>     					<a href="">修改</a>
>     					<a href="">详情</a>
>     				</td>
>     			</tr>
>     		</table>
>     		<hr>
>     		<a href="">新增部门</a>
>     	</body>
>     </html>
> 
> <!DOCTYPE html>  
> <html>  
> <head>  
> <meta charset="utf-8">  
> <title>部门列表</title>  
> </head>  
> <body>  
> <h1>部门列表</h1>  
> <hr>  
> <table border="1px" align="center" width="50%">  
> <tr>  
> <th>Header</th>  
> <th>部门编号</th>  
> <th>部门名称</th>  
> <th>操作</th>  
> </tr>  
> <tr>  
> <td>1</td>  
> <td>10</td>  
> <td>销售部</td>  
> <td>  
> <a href="">删除</a>  
> <a href="">修改</a>  
> <a href="">详情</a>  
> </td>  
> </tr>  
> <tr>  
> <td>2</td>  
> <td>20</td>  
> <td>研发部</td>  
> <td>  
> <a href="">删除</a>  
> <a href="">修改</a>  
> <a href="">详情</a>  
> </td>  
> </tr>  
> <tr>  
> <td>3</td>  
> <td>30</td>  
> <td>运营部</td>  
> <td>  
> <a href="">删除</a>  
> <a href="">修改</a>  
> <a href="">详情</a>  
> </td>  
> </tr>  
> </table>  
> <hr>  
> <a href="">新增部门</a>  
> </body>  
> </html>

>     <!DOCTYPE html>
>     <html>
>     	<head>
>     		<meta charset="utf-8">
>     		<title>新增部门</title>
>     	</head>
>     	<body>
>     		<h1>新增部门</h1>
>     		<hr>
>     		<form action="" method="post">
>     			部门编号:<input type="text" name="deptno"/><br/>
>     			部门名称:<input type="text" name="dname"/><br/>
>     			部门位置:<input type="text" name="loc"/><br/>
>     			<input type="submit" name="保存"/><br/>
>     		</form>
>     	</body>
>     </html>
> 
> <!DOCTYPE html>  
> <html>  
> <head>  
> <meta charset="utf-8">  
> <title>新增部门</title>  
> </head>  
> <body>  
> <h1>新增部门</h1>  
> <hr>  
> <form action="" method="post">  
> 部门编号:<input type="text" name="deptno"/><br/>  
> 部门名称:<input type="text" name="dname"/><br/>  
> 部门位置:<input type="text" name="loc"/><br/>  
> <input type="submit" name="保存"/><br/>  
> </form>  
> </body>  
> </html>

>     <!DOCTYPE html>
>     <html>
>     	<head>
>     		<meta charset="utf-8">
>     		<title>修改部门</title>
>     	</head>
>     	<body>
>     		<h1>修改部门</h1>
>     		<hr>
>     		<form action="" method="post">
>     			部门编号:<input type="text" name="deptno" value="20" readonly/><br/>
>     			部门名称:<input type="text" name="dname" value="销售部"/><br/>
>     			部门位置:<input type="text" name="loc" value="北京"/><br/>
>     			<input type="submit" name="修改"/><br/>
>     		</form>
>     	</body>
>     </html>
> 
> <!DOCTYPE html>  
> <html>  
> <head>  
> <meta charset="utf-8">  
> <title>修改部门</title>  
> </head>  
> <body>  
> <h1>修改部门</h1>  
> <hr>  
> <form action="" method="post">  
> 部门编号:<input type="text" name="deptno" value="20" readonly/><br/>  
> 部门名称:<input type="text" name="dname" value="销售部"/><br/>  
> 部门位置:<input type="text" name="loc" value="北京"/><br/>  
> <input type="submit" name="修改"/><br/>  
> </form>  
> </body>  
> </html>

>     <!DOCTYPE html>
>     <html>
>     	<head>
>     		<meta charset="utf-8">
>     		<title>部门详情</title>
>     	</head>
>     	<body>
>     		<h1>部门详情</h1>
>     		<hr>
>     		部门编号:20<br>
>     		部门名称:销售部<br>
>     		部门位置:北京<br>
>     	</body>
>     </html>
> 
> <!DOCTYPE html>  
> <html>  
> <head>  
> <meta charset="utf-8">  
> <title>部门详情</title>  
> </head>  
> <body>  
> <h1>部门详情</h1>  
> <hr>  
> 部门编号:20<br>  
> 部门名称:销售部<br>  
> 部门位置:北京<br>  
> </body>  
> </html>

>     <!DOCTYPE html>
>     <html>
>     	<head>
>     		<meta charset="utf-8">
>     		<title>欢迎使用OA系统</title>
>     	</head>
>     	<body>
>     		<a href="list.html">查看部门列表</a>
>     	</body>
>     </html>
> 
> <!DOCTYPE html>  
> <html>  
> <head>  
> <meta charset="utf-8">  
> <title>欢迎使用OA系统</title>  
> </head>  
> <body>  
> <a href="list.html">查看部门列表</a>  
> </body>  
> </html>

[2c0a2e8d3e95475bb8bb899ace239c46.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/29/ff44215823d44be8976197541628e798.png
[506e27b6f26e420b9a1d6ce6dc1708ab.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/29/e0aeb75a587747f8960279d13290ba71.png
[94380618c462441986c700822525ccde.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/29/35126c4a782347ac8b08f20ce712d7da.png
[8e22ddcc3c824d3b91d2df151768712a.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/29/6c3135c0065840c487fd8b249376ae2d.png
[93d33fea62d446e597011a5a47b8c00d.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/29/f6a90d9cf93649ddac738054411c9e68.png