1. 配置一定要配置jdk的环境

• 下载jdk1.7/jdk1.8
• 两种jdk，安装版本（windows dll注册表），绿色解压版本D:/java-env/jdk1.7+jdk1.8，

• Eclipse中配置jdk。进入eclipse的window菜单，prefenrece菜单

1. 配置maven环境，给eclipse配置自己安装的不要用默认自带的，因为它有很多bug。

• 官网或者镜像网站下载maven
• 绿色解压放入目录即可D:\tts9\apache-maven-3.3.9
• 配置到eclipse，不用它自带有Bug的版本

1. Maven骨架很烂，很多Bug，例如用着用着，骨架创建不了了。

• 联网：把骨架删除，骨架就是本地的仓库中的jar。如果eclipse调用会自动去判断，如果jar包，自动去网上下载，就去中央仓库或者私服去下载。重写下载后就可以使用、
• 没有联网：从一台同学好的仓库中把目录拷贝过来，重新启动eclipse即可。

<mirrors>
<mirror>
<id>nexus</id>
<name>Tedu Maven</name>
<mirrorOf>*</mirrorOf>
<url>http://maven.tedu.cn/nexus/content/groups/public</url>
<!-- <url>http://maven.oschina.net/content/groups/public</url> -->
</mirror>
</mirrors>

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion><groupId>cn.ts</groupId>
<artifactId>ts2-parent</artifactId>
<version>0.0.1-SNAPSHOT</version>
<packaging>pom</packaging><name>ts2-parent</name>
<url>http://maven.apache.org</url><properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
</properties><dependencies>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>3.2.8.RELEASE</version>
</dependency><dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>3.2.8.RELEASE</version>
</dependency><dependency>
<groupId>commons-dbcp</groupId>
<artifactId>commons-dbcp</artifactId>
<version>1.4</version>
</dependency><dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.9</version>
</dependency><dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.2.8</version>
</dependency><dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.3.1</version>
</dependency><dependency>
<groupId>jstl</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency><dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
</dependency><dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-core</artifactId>
<version>2.2.3</version>
</dependency><dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-annotations</artifactId>
<version>2.2.3</version>
</dependency><dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-databind</artifactId>
<version>2.2.3</version>
</dependency><dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-aop</artifactId>
<version>3.2.8.RELEASE</version>
</dependency><dependency>
<groupId>org.aspectj</groupId>
<artifactId>aspectjweaver</artifactId>
<version>1.8.0</version>
</dependency><dependency>
<groupId>org.aspectj</groupId>
<artifactId>aspectjtools</artifactId>
<version>1.8.0</version>
</dependency><dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>3.16</version>
</dependency><dependency>
<groupId>commons-fileupload</groupId>
<artifactId>commons-fileupload</artifactId>
<version>1.3.3</version>
</dependency><!-- JSP相关 -->
<dependency>
<groupId>jstl</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>servlet-api</artifactId>
<version>2.5</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>jsp-api</artifactId>
<version>2.0</version>
<scope>provided</scope>
</dependency></dependencies>
</project>

1. 垂直拆分（纵向），按业务来拆分，把原来系统中的业务模块升级成子系统
2. 水平拆分（横向），一个子系统内还很多内容，继续分拆。也分层体系架构来分拆。pojo/mapper/service/controller(web)

1. pom.xml 中要依赖tomcat插件

<build>
<plugins>
<plugin>
<groupId>org.apache.tomcat.maven</groupId>
<artifactId>tomcat7-maven-plugin</artifactId>
<version>2.2</version>
<configuration>
<port>8090</port>
<path>/</path>
</configuration>
</plugin>
</plugins>
</build>

• 默认创建工程时，<build>标签会自动创建，pom.xml中只允许有一个bulid标签。要把旧的一定要删除
• <port>8090</port> 不用去修改tomcat的server.xml文件来修改端口，而直接利用配置文件来修改，修改配置都方便很多
• <path>/</path> 设置虚拟路径，/代表根目录，/TeduStore在访问时，在浏览器上地址栏输入虚拟路径。如果只是/就tomcat下就只能运行一个项目，如果各自有各自的虚拟路径，可以运行多个项目。
• 配置maven的tomcat插件是一个微缩版，它没有考虑性能优化、安全等内容。所以小快。如果企业最终部署系统到生产环境，还必须用tomcat，war的发布方式。只是测试环境方便快速测试。

<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
</dependency><!-- JSP相关 -->
<dependency>
<groupId>jstl</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>servlet-api</artifactId>
<version>2.5</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>jsp-api</artifactId>
<version>2.0</version>
<scope>provided</scope>
</dependency>

Maven垂直切分

<build>
<plugins>
<plugin>
<groupId>org.apache.tomcat.maven</groupId>
<artifactId>tomcat7-maven-plugin</artifactId>
<version>2.2</version>
<configuration>
<port>8090</port>
<path>/</path>
</configuration>
</plugin>
</plugins>
</build>http://localhost:8090/main/index.do

<dependency>
<groupId>redis.clients</groupId>
<artifactId>jedis</artifactId>
<version>2.6.0</version>
</dependency>package jedis;import java.util.ArrayList;
import java.util.List;import org.junit.Test;import redis.clients.jedis.Jedis;
import redis.clients.jedis.JedisPoolConfig;
import redis.clients.jedis.JedisShardInfo;
import redis.clients.jedis.ShardedJedis;
import redis.clients.jedis.ShardedJedisPool;public class TestJedis {
@Test    //完成单实例链接
public void jedis(){
//Jedis jedis = new Jedis("192.168.27.113", 6379);
Jedis jedis = new Jedis("192.168.163.7", 6379);
//jedis.auth("123456");
jedis.set("name", "tony3");    //调用redis命令set
System.out.println(jedis.get("name"));
jedis.close();
}@Test
public void pool(){
JedisPoolConfig config = new JedisPoolConfig();
config.setMaxTotal(200);List<JedisShardInfo> shards = new ArrayList<JedisShardInfo>();
JedisShardInfo info = new JedisShardInfo("192.168.163.7", 6379);
shards.add(info);ShardedJedisPool pool = new ShardedJedisPool(config, shards);
ShardedJedis jedis = pool.getResource();System.out.println(jedis.get("name"));
}
}

spring-redis.xml =========================

<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"><!-- 构建连接池配置信息 -->
<bean id="jedisPoolConfig" class="redis.clients.jedis.JedisPoolConfig">
<!-- 最大连接数 -->
<property name="maxTotal" value="200"/>
</bean><!-- 定义集群连接池 -->
<bean id="shardedJedisPool" class="redis.clients.jedis.ShardedJedisPool" destroy-method="close">
<!-- 第一个参数 -->
<constructor-arg index="0" ref="jedisPoolConfig"/>
<constructor-arg index="1">
<list>
<bean class="redis.clients.jedis.JedisShardInfo">
<constructor-arg index="0" value="192.168.163.7"/>
<constructor-arg type="int" index="1" value="6379"/>
</bean>
</list>
</constructor-arg>
</bean></beans>

DictServiceImpl ======================

package cn.tedu.store.service;
import java.util.List;
import javax.annotation.Resource;
import org.springframework.stereotype.Service;
import com.fasterxml.jackson.core.JsonProcessingException;
import com.fasterxml.jackson.databind.JsonNode;
import com.fasterxml.jackson.databind.ObjectMapper;
import cn.tedu.store.bean.dict.Area;
import cn.tedu.store.bean.dict.City;
import cn.tedu.store.bean.dict.Province;
import cn.tedu.store.mapper.DictMapper;
import redis.clients.jedis.ShardedJedis;
import redis.clients.jedis.ShardedJedisPool;
@Service("dictService")
public class DictServiceImpl implements DictService {
@Resource
private DictMapper dictMapper;
@Resource
private ShardedJedisPool shardedJedisPool;
private static final ObjectMapper MAPPER = new ObjectMapper();
public List<Province> getProvinceList() {
return dictMapper.getProvinceList();
}
public List<City> getCityList(String provinceCode) {
ShardedJedis jedis = shardedJedisPool.getResource();
String RedisKey = "TS_CITY_"+provinceCode;
if(jedis.exists(RedisKey)){
Object obj = null;
try {
String json = jedis.get(RedisKey);
JsonNode jsonNode = MAPPER.readTree(json);
obj = MAPPER.readValue(jsonNode.traverse(),
MAPPER.getTypeFactory().constructCollectionType(List.class, City.class));
} catch (Exception e) {
e.printStackTrace();
}
return (List<City>) obj;
}else{
List<City> listCity = dictMapper.getCityList(provinceCode);
try {
String json = MAPPER.writeValueAsString(listCity);
jedis.set(RedisKey, json);
} catch (JsonProcessingException e) {
e.printStackTrace();
}
return listCity;
}
}
}

2   变量

2.1    用户会话变量

set @v1 = 123;
select @v1;

2.2    局部变量

3  视图

3.1    简单视图

SELECT * FROM t_goodsWHERE category_id=238CREATE VIEW v_goods ASSELECT * FROM t_goodsWHERE category_id=238SELECT * FROM v_goods
DELIMITER $$  设定一个标识符，标识结束$$USE `tedu_store`$$    打开指定数据库tedu_storeDROP VIEW IF EXISTS `v_goods238`$$  如果此视图已经存在，就删除CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v_goods238` AS
SELECT`t_goods`.`id`            AS `id`,`t_goods`.`category_id`   AS `category_id`,`t_goods`.`item_type`     AS `item_type`,`t_goods`.`title`         AS `title`,`t_goods`.`sell_point`    AS `sell_point`,`t_goods`.`price`         AS `price`,`t_goods`.`num`           AS `num`,`t_goods`.`barcode`       AS `barcode`,`t_goods`.`image`         AS `image`,`t_goods`.`status`        AS `status`,`t_goods`.`priority`      AS `priority`,`t_goods`.`created_time`  AS `created_time`,`t_goods`.`modified_time` AS `modified_time`,`t_goods`.`created_user`  AS `created_user`,`t_goods`.`modified_user` AS `modified_user`
FROM `t_goods`
WHERE (`t_goods`.`category_id` = 238)$$DELIMITER ;

 CREATE VIEW v_cat_goods ASSELECT c.name,g.item_type,g.title FROM t_goods gLEFT JOIN t_goods_category cON g.category_id=c.idSELECT * FROM v_cat_goods视图在大型项目中被废除！！！！
视图过程是把查询所有的记录都查询回来，然后再过滤数据，过滤掉非238.
如果这张表中有一千万数据。数据量大时无法优化。
Java程序可以吗？mybatis它直接处理，返回结果数据。结果就比视图快。

4   存储过程

1. 写数据库代码（存储过程-单独学习语法，无法断点，system.out没有输出，几乎无法调试。DBA），写java代码（人员众多，好调试）。后期维护。不好维护。Java好维护。
2. 存储过程不好写，质量不好控制。

4.1    定义存储过程

--  修改结束符
delimiter //--  创建存储过程p1
create procedure p1()
begin  --  大括号开始-- 定义局部变量v2declare v2 int default 123;select v2; --  显示v2变量的值
end//  --  大括号结束

4.2    调用存储过程

call p1()//

4.3    查看存储过程

4.4    删除存储过程

4.5    存储过程的参数

1. 页面填写两张表的数据，学生名称，学生的电话，存在两个表中
2. 学生表自增主键
3. 联系表中和学生表的关联（一对一）

1. 冷备份（按月）
2. 热备份

• 定时任务Job （按周，日（凌晨2点），小时）、
• 实时备份（主从复制，实时同步）