ssm自学curd入门

最新推荐文章于 2022-03-31 12:43:17 发布

走路带_风

最新推荐文章于 2022-03-31 12:43:17 发布

阅读量314

点赞数

文章标签： java ssm入门学习

本文链接：https://blog.csdn.net/wang_muhuo/article/details/80315150

版权

CustomerController.java

package com.shiep.controller;
import java.util.List;
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 com.shiep.pojo.Customer;
import com.shiep.pojo.Login;
import com.shiep.pojo.QueryVo;
import com.shiep.service.CustomerService;
@Controller
@RequestMapping("customer")
public class CustomerController {
	@Autowired
	private CustomerService customerService;
	@RequestMapping("list.do")
	public String list(QueryVo vo,Model model) {
		List<Customer> listAll = customerService.selectPageByQueryVo(vo);
		model.addAttribute("listAll", listAll);

		model.addAttribute("custName", vo.getCustName());
		model.addAttribute("custSource",vo.getCustSource());
		model.addAttribute("custIndustry", vo.getCustIndustry());
		model.addAttribute("custLevel", vo.getCustLevel());
		return "list";	
	}
	@RequestMapping(value="edit.do")
	public  String edit( Integer id,Model model){ 
		Customer customerById = customerService.selectCustomerById(id);
		model.addAttribute("customerById", customerById);
		return "update";
				
	}
	
	@RequestMapping(value="update.do")
	public String update( Customer customer){
		customerService.updateCustomerById(customer);
		return "list"; 
	
	}
	@RequestMapping(value="delete.do")
	public  String delete( Integer id){
		customerService.deleteCustomerById(id);
		return "list";  
		
	}
	
	
	@RequestMapping(value="tosave.do")
	private String tosave() {
		return "save";


	}
	@RequestMapping(value="save.do")
	public  String save( Customer customer){
		customerService.saveCustomer(customer);
		return "list"; 
		
	}
	
	@RequestMapping("login.do")
	public String login(Login vo){
		vo=this.customerService.customerLogin(vo);
		if(vo!=null){
			return "main";
		}else {
			return "error";
		}
	}
}

CustomerDao.java

package com.shiep.mapper;
import java.util.List;
import com.shiep.pojo.Customer;
import com.shiep.pojo.Login;
import com.shiep.pojo.QueryVo;
public interface CustomerDao {
	public Integer customerCountByQueryVo(QueryVo vo);
	public List<Customer> customerListByQueryVo(QueryVo vo);
	public  Customer selectCustomerById(Integer id);
	public void updateCustomerById(Customer customer);
	public void deleteCustomerById(Integer id);
	public void saveCustomer(Customer customer);
	public Login findLogin(Login vo);	

}

CustomerDao.xml

<mapper namespace="com.shiep.mapper.CustomerDao">
	<select id="customerCountByQueryVo" parameterType="QueryVo" resultType="Integer">
		select count(1) from customer
		<where>
			<if test="custName !=null and custName !=''">
				cust_name like "%"#{custName}"%"
			</if>
			<if test="custSource !=null and custSource !=''" >
				and cust_source = #{custSource}
			</if>
			<if test="custIndustry !=null and custIndustry !=''">
				and cust_industry = #{custIndustry}
			</if>
			<if test="custLevel !=null and custLevel !=''">
				and cust_level = #{custLevel}
			</if>
		</where>
	</select>
	<select id="customerListByQueryVo" parameterType="QueryVo" resultType="Customer">
		select * from customer
		<where>
			<if test="custName !=null and custName !=''">
				cust_name like "%"#{custName}"%"
			</if>
			<if test="custSource !=null and custSource !=''" >
				and cust_source = #{custSource}
			</if>
			<if test="custIndustry !=null and custIndustry !=''">
				and cust_industry = #{custIndustry}
			</if>
			<if test="custLevel !=null and custLevel !=''">
				and cust_level = #{custLevel}
			</if>
		</where>
	</select>
	<select id="selectCustomerById" parameterType="Integer" resultType="Customer">
		select * from customer
		<where>
			cust_id=#{id}
		</where>
	</select>
	<update id="updateCustomerById" parameterType="Customer" >
		update customer 
		<set>
			<if test="cust_name !=null">
				cust_name=#{cust_name},
			</if>
			<if test="cust_source !=null">
				cust_source=#{cust_source},
			</if>
			<if test="cust_industry !=null">
				cust_industry=#{cust_industry},
			</if>
			<if test="cust_level !=null">
				cust_level=#{cust_level},
			</if>
			<if test="cust_linkman !=null">
				cust_linkman=#{cust_linkman},
			</if>
			<if test="cust_phone !=null">
				cust_phone=#{cust_phone},
			</if>
			<if test="cust_mobile !=null">
				cust_mobile=#{cust_mobile},
			</if>
			<if test="cust_zipcode !=null">
				cust_zipcode=#{cust_zipcode},
			</if>
			<if test="cust_address !=null">
				cust_address=#{cust_address}
			</if>
		</set>
		<where>
			cust_id= #{cust_id}
		</where>	
	</update>
	
 <delete id="deleteCustomerById" parameterType="Integer">
	delete from customer where cust_id=#{valve}
 </delete>
<insert  id="saveCustomer" parameterType="Customer" >
		insert into customer(cust_id,cust_name,cust_user_id,cust_create_id,cust_source,cust_industry,cust_level,cust_linkman,cust_phone,cust_mobile,cust_zipcode,cust_address,cust_createtime) 
		values(#{cust_id},#{cust_name},#{cust_user_id},#{cust_create_id},#{cust_source},#{cust_industry},
		#{cust_level},#{cust_linkman},#{cust_phone},#{cust_mobile},#{cust_zipcode},#{cust_address},#{cust_createtime})
</insert>
<select id="findLogin" parameterType="Login" resultType="Login">
 select * from login
    where username=#{username} and 
    	  password=#{password}
</select>	

</mapper>

Customer.java

package com.shiep.pojo;
import java.util.Date;
import org.springframework.format.annotation.DateTimeFormat;
public class Customer {
	private Long cust_id;
	private String cust_name;
	private Long cust_user_id;
	private Long cust_create_id;
	private String cust_source;
	private String cust_industry;
	private String cust_level;
	private String cust_linkman;
	private String cust_phone;
	private String cust_mobile;
	private String cust_zipcode;
	private String cust_address;
	@DateTimeFormat(pattern = "yyyy-MM-dd")
	private Date cust_createtime;
	public Long getCust_id() {
		return cust_id;
	}
	public void setCust_id(Long cust_id) {
		this.cust_id = cust_id;
	}
	public String getCust_name() {
		return cust_name;
	}
	public void setCust_name(String cust_name) {
		this.cust_name = cust_name;
	}
	public Long getCust_user_id() {
		return cust_user_id;
	}
	public void setCust_user_id(Long cust_user_id) {
		this.cust_user_id = cust_user_id;
	}
	public Long getCust_create_id() {
		return cust_create_id;
	}
	public void setCust_create_id(Long cust_create_id) {
		this.cust_create_id = cust_create_id;
	}
	public String getCust_source() {
		return cust_source;
	}
	public void setCust_source(String cust_source) {
		this.cust_source = cust_source;
	}
	public String getCust_industry() {
		return cust_industry;
	}
	public void setCust_industry(String cust_industry) {
		this.cust_industry = cust_industry;
	}
	public String getCust_level() {
		return cust_level;
	}
	public void setCust_level(String cust_level) {
		this.cust_level = cust_level;
	}
	public String getCust_linkman() {
		return cust_linkman;
	}
	public void setCust_linkman(String cust_linkman) {
		this.cust_linkman = cust_linkman;
	}
	public String getCust_phone() {
		return cust_phone;
	}
	public void setCust_phone(String cust_phone) {
		this.cust_phone = cust_phone;
	}
	public String getCust_mobile() {
		return cust_mobile;
	}
	public void setCust_mobile(String cust_mobile) {
		this.cust_mobile = cust_mobile;
	}
	public String getCust_zipcode() {
		return cust_zipcode;
	}
	public void setCust_zipcode(String cust_zipcode) {
		this.cust_zipcode = cust_zipcode;
	}
	public String getCust_address() {
		return cust_address;
	}
	public void setCust_address(String cust_address) {
		this.cust_address = cust_address;
	}
	public Date getCust_createtime() {
		return cust_createtime;
	}
	public void setCust_createtime(Date cust_createtime) {
		this.cust_createtime = cust_createtime;
	}
}

package com.shiep.pojo;
public class Login {
	Integer Id;
	String username;
	String password;
	String picture;
	public Integer getId() {
		return Id;
	}
	public void setId(Integer id) {
		Id = id;
	}
	public String getUsername() {
		return username;
	}
	public void setUsername(String username) {
		this.username = username;
	}
	public String getPassword() {
		return password;
	}
	public void setPassword(String password) {
		this.password = password;
	}
	public String getPicture() {
		return picture;
	}
	public void setPicture(String picture) {
		this.picture = picture;
	}

}

QueryVo.java

package com.shiep.pojo;
public class QueryVo {
	private String custName;
	private String custSource;
	private String custIndustry;
	private String custLevel;
	public String getCustName() {
		return custName;
	}
	public void setCustName(String custName) {
		this.custName = custName;
	}
	
	public String getCustSource() {
		return custSource;
	}
	public void setCustSource(String custSource) {
		this.custSource = custSource;
	}
	public String getCustIndustry() {
		return custIndustry;
	}
	public void setCustIndustry(String custIndustry) {
		this.custIndustry = custIndustry;
	}
	public String getCustLevel() {
		return custLevel;
	}
	public void setCustLevel(String custLevel) {
		this.custLevel = custLevel;
	}

}

CustomerService.java

package com.shiep.service;
import java.util.List;
import com.shiep.pojo.Customer;
import com.shiep.pojo.Login;
import com.shiep.pojo.QueryVo
public interface CustomerService {
	public List<Customer> selectPageByQueryVo(QueryVo vo);
	public  Customer selectCustomerById(Integer id);
	public void updateCustomerById(Customer customer);
	public void deleteCustomerById(Integer id);
	public void saveCustomer(Customer customer);
	public Login customerLogin(Login vo);		

}

CustomerServiceImpl.java

package com.shiep.service;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.shiep.mapper.CustomerDao;
import com.shiep.pojo.Customer;
import com.shiep.pojo.Login;
import com.shiep.pojo.QueryVo;
@Service
public class CustomerServiceImpl implements CustomerService {
	@Autowired
	private CustomerDao customerDao;
	public List<Customer> selectPageByQueryVo(QueryVo vo) {
		return customerDao.customerListByQueryVo(vo);
	}
		@Override
		public Customer selectCustomerById(Integer id) {
			return customerDao.selectCustomerById(id);
		}
		@Override
		public void updateCustomerById(Customer customer) {
			customerDao.updateCustomerById(customer);
		}
		@Override
		public void deleteCustomerById(Integer id) {
			customerDao.deleteCustomerById(id);
			
		}
		@Override
		public void saveCustomer(Customer customer) {
			customerDao.saveCustomer(customer);
		}

		@Override
		public Login customerLogin(Login vo) {	
			return customerDao.findLogin(vo);
		}
}

SqlMapConfig.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<!-- 别名 -->
	<typeAliases> 
		<package name="com.shiep.pojo"/>
	</typeAliases>

</configuration>

applicationContext.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:context="http://www.springframework.org/schema/context" xmlns:p="http://www.springframework.org/schema/p"
	xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
	http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd
	http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd
	http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-4.0.xsd">
	
	<!-- 配置Service扫描 -->
	<context:component-scan base-package="com.shiep.service" />
	
	<!-- 配置 读取properties文件 jdbc.properties -->
	<context:property-placeholder location="classpath:jdbc.properties" />


	<!-- 配置 数据源 -->
	<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
		<property name="driverClassName" value="${jdbc.driver}" />
		<property name="url" value="${jdbc.url}" />
		<property name="username" value="${jdbc.username}" />
		<property name="password" value="${jdbc.password}" />
	</bean>
	<!-- 配置SqlSessionFactory -->
	<bean class="org.mybatis.spring.SqlSessionFactoryBean">
		<!-- 设置MyBatis核心配置文件 -->
		<property name="configLocation" value="classpath:mybatis/SqlMapConfig.xml" />
		<!-- 设置数据源 -->
		<property name="dataSource" ref="dataSource" />
	</bean>
	<!-- 配置Mapper扫描 -->
	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
		<!-- 设置Mapper扫描包 -->
		<property name="basePackage" value="com.shiep.mapper" />
	</bean>

</beans>

springmvc.xml

<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p"
	xmlns:context="http://www.springframework.org/schema/context"
	xmlns:mvc="http://www.springframework.org/schema/mvc"
	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
        http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd
        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd">
	<!-- 配置Controller扫描 -->
	<context:component-scan base-package="com.shiep.controller" />
	<!-- 配置注解驱动 -->
	<mvc:annotation-driven />
	<!-- 配置视图解析器 -->
	<bean	class="org.springframework.web.servlet.view.InternalResourceViewResolver">
		<property name="prefix" value="/WEB-INF/jsp/" />
		<property name="suffix" value=".jsp" />
	</bean>
</beans>

web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" id="WebApp_ID" version="2.5">
  <display-name>ssm_curd</display-name>
  <welcome-file-list>
    <welcome-file>index.jsp</welcome-file>
  </welcome-file-list>
  	<!-- 配置spring -->
	<context-param>
		<param-name>contextConfigLocation</param-name>
		<param-value>classpath:spring/applicationContext.xml</param-value>
	</context-param>
	<!-- 配置监听器加载spring -->
	<listener>
		<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
	</listener>
	<!-- 配置过滤器，解决post的乱码问题 -->
	<filter>
		<filter-name>encoding</filter-name>
		<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
		<init-param>
			<param-name>encoding</param-name>
			<param-value>UTF-8</param-value>
		</init-param>
	</filter>
	<filter-mapping>
		<filter-name>encoding</filter-name>
		<url-pattern>/*</url-pattern>
	</filter-mapping>
	<!-- 配置SpringMVC -->
	<servlet>
		<servlet-name>ssm_curd</servlet-name>
		<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
		<init-param>
			<param-name>contextConfigLocation</param-name>
			<param-value>classpath:spring/springmvc.xml</param-value>
		</init-param>
		<!-- 配置springmvc什么时候启动，参数必须为整数 -->
		<!-- 如果为0或者大于0，则springMVC随着容器启动而启动 -->
		<!-- 如果小于0，则在第一次请求进来的时候启动 -->
		<load-on-startup>1</load-on-startup>
	</servlet>
	<servlet-mapping>
		<servlet-name>ssm_curd</servlet-name>
		<!-- 所有的请求都进入springMVC -->
		<url-pattern>*.do</url-pattern>
	</servlet-mapping>
</web-app>

jdbc.properties

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/curd?characterEncoding=utf-8
jdbc.username=root
jdbc.password=admin

list.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%
	String path = request.getContextPath();
	String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort()
			+ path + "/";
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>客户列表</title>
</head>
<body>
<h1>客户管理系统 </h1>
<form action="<%=basePath %>customer/list.do" method="post">
客户名称:<input type="text"   name="custName" value="${custName }"><br/>
客户来源：
<select name="custSource" >
<option value="">--请选择--</option>
<option value="6">电话营销</option>
<option value="7">网络营销</option>
</select><br/>
所属行业：
<select  name="custIndustry">
<option value="">--请选择--</option>
<option value="1">教育培训</option>
<option value="2">电子商务</option>
<option value="3">对外贸易</option>
<option value="4">酒店旅游</option>
<option value="5">房地产</option>
</select><br/>
客户级别：
<select  name="custLevel">
<option value="">--请选择--</option>
<option value="22">普通客户</option>
<option value="23">VIP客户</option>
</select><br/>
<button type="submit"  onclick="window.location.href='<%=basePath %>customer/list.do'">查询</button>
</form>
<h3>客户信息列表</h3>
	<table >
		<thead>
			<tr>
				<th>ID</th>
				<th>客户名称</th>
				<th>客户来源</th>
				<th>客户所属行业</th>
				<th>客户级别</th>
				<th>固定电话</th>
				<th>手机</th>
				<th>操作</th>
			</tr>
		</thead>
		<tbody>
			<c:forEach items="${listAll}" var="row">
				<tr>
					<td>${row.cust_id}</td>
					<td>${row.cust_name}</td>
					<td>${row.cust_source}</td>
					<td>${row.cust_industry}</td>
					<td>${row.cust_level}</td>
					<td>${row.cust_phone}</td>
					<td>${row.cust_mobile}</td>
					<td>
    					<a href="<%=basePath %>customer/edit.do?id=${row.cust_id }">修改</a>/
    					<a href="<%=basePath %>customer/delete.do?id=${row.cust_id }">删除</a>
    				</td>
				</tr>
			</c:forEach>
		</tbody>
	</table>
</body>

</html>

main.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%
	String path = request.getContextPath();
	String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort()
			+ path + "/";
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>首页</title>
</head>
<body>
<h1><font color="red">欢迎</font></h1>
    <a href="<%=basePath %>customer/tosave.do">保存客户</a><br/>
    <a href="<%=basePath %>customer/list.do">客户列表</a>
</body>

</html>

save.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%
	String path = request.getContextPath();
	String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort()
			+ path + "/";
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
  <head>
    <title>保存客户</title>
  </head>
  <body>
    <h1><font color="red">保存客户</font></h1>
     <form   action="<%=basePath %>customer/save.do"  method="post">
        cust_name:<input type="text" name="cust_name"> <br/>
        cust_source:<input type="text" name="cust_source"> <br/>
        cust_industry:<input type="text" name="cust_industry"> <br/>
        cust_level:<input type="text" name="cust_level"> <br/>
        cust_phone:<input type="text" name="cust_phone"> <br/>
        cust_mobile:<input type="text" name="cust_mobile"> <br/>
        <input type="submit"  value="保存">
     </form> <br/>
  </body>

</html>

update.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%
	String path = request.getContextPath();
	String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort()
			+ path + "/";
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>修改客户信息</title>
</head>
<body>
<form action="<%=basePath%>customer/update.do" method="post" >
<h4>修改客户信息</h4>
<input type="hidden" name="cust_id" value="${customerById.cust_id }">
客户名称:<input type="text" name="cust_name" value="${customerById.cust_name }"><br/>
客户来源：<input type="text" name="cust_source" value="${customerById.cust_source }"><br/>  
<!-- <select name="custSource" >
<option value="">--请选择--</option>
<option value="6">电话营销</option>
<option value="7">网络营销</option>
</select><br/> -->
所属行业：<input type="text" name="cust_industry" value="${customerById.cust_industry }"><br/>
<!-- <select  name="custIndustry">
<option value="">--请选择--</option>
<option value="1">教育培训</option>
<option value="2">电子商务</option>
<option value="3">对外贸易</option>
<option value="4">酒店旅游</option>
<option value="5">房地产</option>
</select><br/> -->
客户级别：<input type="text" name="cust_level" value="${customerById.cust_level }"><br/>
<!-- <select  name="custLevel" id="custLevel">
<option value="">--请选择--</option>
<option value="22">普通客户</option>
<option value="23">VIP客户</option>
</select><br/> -->
联系人:<input type="text"  name="cust_linkman" value="${customerById.cust_linkman}"><br/>
固定电话:<input type="text" name="cust_phone" value="${customerById.cust_phone}"><br/>
移动电话:<input type="text" name="cust_mobile" value="${customerById.cust_mobile}"><br/>
邮政编码:<input type="text" name="cust_zipcode" value="${customerById.cust_zipcode}"><br/>
联系地址:<input type="text" name="cust_address" value="${customerById.cust_address}"><br/>
<input type="submit" value="修改">
</form>
</body>

</html>

index.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%
	String path = request.getContextPath();
	String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort()
			+ path + "/";
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>登录页面</title>
</head>
<body>
<form action="<%=basePath %>customer/login.do" method="post">
    	<table>
    		<tr>
    			<td>用户名</td>
    			<td><input type="text" name="username"></td>
    		</tr>
    		<tr>
    			<td>密码</td>
    			<td><input type="password" name="password"></td>
    		</tr>
    		<tr>
    			<td><input type="submit" value="登陆"></td>
    		</tr>
    	</table>
    </form>
</body>

</html>

customer表

# Host: 127.0.0.1  (Version: 5.5.15)
# Date: 2018-05-15 18:11:59
# Generator: MySQL-Front 5.3  (Build 4.269)

/*!40101 SET NAMES utf8 */;

#
# Structure for table "customer"
#

DROP TABLE IF EXISTS `customer`;
CREATE TABLE `customer` (
  `cust_id` bigint(32) NOT NULL AUTO_INCREMENT COMMENT '客户编号(主键)',
  `cust_name` varchar(32) DEFAULT NULL COMMENT '客户名称(公司名称)',
  `cust_user_id` bigint(32) DEFAULT NULL COMMENT '负责人id',
  `cust_create_id` bigint(32) DEFAULT NULL COMMENT '创建人id',
  `cust_source` varchar(32) DEFAULT NULL COMMENT '客户信息来源',
  `cust_industry` varchar(32) DEFAULT NULL COMMENT '客户所属行业',
  `cust_level` varchar(32) DEFAULT NULL COMMENT '客户级别',
  `cust_linkman` varchar(64) DEFAULT NULL COMMENT '联系人',
  `cust_phone` varchar(64) DEFAULT NULL COMMENT '固定电话',
  `cust_mobile` varchar(16) DEFAULT NULL COMMENT '移动电话',
  `cust_zipcode` varchar(10) DEFAULT NULL,
  `cust_address` varchar(100) DEFAULT NULL,
  `cust_createtime` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`cust_id`),
  KEY `FK_cst_customer_create_id` (`cust_create_id`),
  KEY `FK_cst_customer_industry` (`cust_industry`),
  KEY `FK_cst_customer_level` (`cust_level`),
  KEY `FK_cst_customer_source` (`cust_source`),
  KEY `FK_cst_customer_user_id` (`cust_user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=184 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

#
# Data for table "customer"
#

INSERT INTO `customer` VALUES (36,'令狐冲',NULL,NULL,'6','5','23',NULL,'0108888887','13888888888',NULL,NULL,NULL)

login表

# Host: 127.0.0.1  (Version: 5.5.15)
# Date: 2018-05-15 18:12:15
# Generator: MySQL-Front 5.3  (Build 4.269)

/*!40101 SET NAMES gb2312 */;

#
# Structure for table "login"
#

DROP TABLE IF EXISTS `login`;
CREATE TABLE `login` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `picture` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `Id` (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

#
# Data for table "login"
#

INSERT INTO `login` VALUES (1,'1','1','1'),(2,'admin','admin',NULL);