基于SSM+BootStrap框架的学生信息管理系统
< ? xml version= "1.0" encoding= "UTF-8" ? >
< ! DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
< mapper namespace= "com.itheima.mapper.UserMapper" >
< ! -- resultType 返回类型 sql语句最好在数据库里执行成功保证没有语法错误再拷贝过来 -- >
< select id= "findUserByUserName" resultType= "User"
parameterType= "User" >
select * from t_user where userName= #{ userName} and password= #{ password}
< / select>
< select id= "findUsers" resultType= "User" >
select * from t_user
< / select>
< insert id= "insertUser" parameterType= "User" >
INSERT INTO
t_user ( id, userName, password)
VALUES ( #{ id} , #{ userName} , #{ password} )
< / insert>
< delete id= "delUserByUserName" parameterType= "String" >
delete from t_user where userName= #{ userName}
< / delete>
< update id= "updateUser" parameterType= "User" >
update t_user set password= #{ password} and userName= #{ userName}
< / update>
< / mapper>
package com. itheima. mapper;
import java. util. List;
import com. itheima. po. Customer;
import com. itheima. po. User;
public interface UserMapper {
User findUserByUserName ( User user) ;
List< User> findUsers ( ) ;
void delUserByUserName ( String userName) ;
void updateUser ( User user) ;
Integer insertUser ( User user) ;
}
<head>
<meta charset="UTF-8">
<title>客户管理系统</title>
</head>
<!-- jQuery -->
<script src="js/external/jquery-3.4.1.min.js" type="text/javascript" charset="utf-8"></script>
<!-- DataTables -->
<link rel="stylesheet" type="text/css" href="css/external/dataTables.bootstrap.css" />
<script src="js/external/jquery.dataTables.min.js" type="text/javascript" charset="utf-8"></script>
<script src="js/external/dataTables.bootstrap.js" type="text/javascript" charset="utf-8"></script>
<!--界面库 bootstrap-->
<link rel="stylesheet" type="text/css" href="css/external/bootstrap.min.css" />
<script src="js/external/bootstrap.min.js" type="text/javascript" charset="utf-8"></script>
<link rel="stylesheet" type="text/css" href="css/index.css" />
<!-- 其他js引用 -->
<script type="text/javascript" src="js/user.js"></script>
<script type="text/javascript" src="js/customer.js"></script>
<script type="text/javascript">
window.onload = getSession();
function showContent(msg) {
if(msg == 'product') {
$("#content").attr("src", "html/productManager.html");
} else {
$("#content").attr("src", "html/customerManager.html");
}
}
</script>
<body>
<header>
<nav class="navbar navbar-default">
<div class="container-fluid">
<div class="navbar-header float-right">
<button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1" aria-expanded="false">
<span class="sr-only">Toggle navigation</span> <span
class="icon-bar"></span> <span class="icon-bar"></span> <span
class="icon-bar"></span>
</button>
<a class="navbar-brand" href="#" onclick="logout()">注销</a>
</div>
<!-- Collect the nav links, forms, and other content for toggling -->
<div class="collapse navbar-collapse float-right" id="bs-example-navbar-collapse-1">
<ul class="nav navbar-nav">
<li class="dropdown">
<a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">语言 <span class="caret"></span></a>
<ul class="dropdown-menu">
<li>
<a href="#">中文</a>
</li>
<li>
<a href="#">英文</a>
</li>
</ul>
</li>
</ul>
</div>
</div>
</nav>
</header>
<main>
<!-- 侧边栏 -->
<div class="row">
<div class="col-md-2 col-sm-2 hidden-xs">
<aside>
<ul class="nav nav-pills nav-stacked">
<li role="presentation" class="active" onclick="showContent('customer')">
<a>客戶管理</a>
</li>
<li role="presentation" class="active" onclick="showContent('product')">
<a>商品管理</a>
</li>
</ul>
</aside>
</div>
<div class="col-md-10 col-sm-10">
<iframe id="content" frameborder="no" scrolling="no" src="html/customerManager.html"></iframe>
</div>
</div>
</main>
</body>
<div>
<button type="button" class="btn btn-primary"
onclick="addDataDialog()">新增</button>
<button type="button" class="btn btn-primary" onclick="refreshData()">刷新</button>
</div>
<br>
<table id="customerList" class="table table-striped">
<thead>
<tr>
<th>id</th>
<th>姓名</th>
<th>职务</th>
<th>电话</th>
<th>操作</th>
</tr>
</thead>
</table>
<!-- 新增对话框 -->
<div class="modal" id="addCustomerDialog">
<!-- modal默认是隐藏的 -->
<div class="modal-dialog">
<div class="modal-content">
<!-- 头部关闭按钮 -->
<div class="modal-header">
<button type="button" class="close myclose" data-dismiss="modal">
<span>×</span>
</button>
<div class="h3 modal-title">新增人员信息</div>
<!-- 内容部分 -->
<div class="modal-body">
<div class="form-group">
<label for="exampleInputEmail1">客户名称</label> <input type="text"
class="form-control" name="username" placeholder="姓名"> <span
id="account_warning" class="help-block hide warning-color">用户名必填</span>
</div>
<div class="form-group">
<label for="exampleInputEmail1">客户工作</label> <input type="text"
class="form-control" name="job" placeholder="工作">
</div>
<div class="form-group">
<label for="exampleInputEmail1">客户电话</label> <input type="text"
class="form-control" name="phone" placeholder="电话">
</div>
<div class="form-group addDataPlane">
<button class="btn btn-default navbar-right" onclick="addData()">确定</button>
<button class="btn btn-default " data-dismiss="modal"
aria-hidden="true">取消</button>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="modal" id="editDialog">
<!-- modal默认是隐藏的 -->
<div class="modal-dialog">
<div class="modal-content">
<!-- 头部关闭按钮 -->
<div class="modal-header">
<button type="button" class="close myclose" data-dismiss="modal">
<span>×</span>
</button>
<div class="h3 modal-title">修改人员信息</div>
<!-- 内容部分 -->
<div class="modal-body">
<div class="form-group">
<label for="exampleInputEmail1">客户名称</label> <input type="text"
class="form-control" name="updateUsername" placeholder="姓名"> <span
id="account_warning" class="help-block hide warning-color">用户名必填</span>
</div>
<div class="form-group">
<label for="exampleInputEmail1">客户工作</label> <input type="text"
class="form-control" name="updatejob" placeholder="工作">
</div>
<div class="form-group">
<label for="exampleInputEmail1">客户电话</label> <input type="text"
class="form-control" name="updatephone" placeholder="电话">
</div>
<div class="form-group addDataPlane">
<button class="btn btn-default navbar-right" onclick="updateData()">确定</button>
<button class="btn btn-default " data-dismiss="modal"
aria-hidden="true">取消</button>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- 分类删除模态框 -->
<div class="modal small fade" id="delCustomerDialog" tabindex="-1"
role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal"
aria-hidden="true">×</button>
<h3 id="myModalLabel">删除确认</h3>
</div>
<div class="modal-body">
<h4 style="text-align: center;">
<i class="fa fa-warning modal-fa" style="color: red;"></i>
您确认要删除该客户信息吗?
</h4>
</div>
<div class="modal-footer">
<button class="btn btn-danger" id="delButton" data-account=""
data-complete-text="正在删除...">删除</button>
<button class="btn btn-default" data-dismiss="modal"
aria-hidden="true">取消</button>
</div>
</div>
</div>
</div>