今日学习笔记

1. 在数据库中创建表

 

 

 2.创建表SQL

CREATE TABLE product(

id varchar2(32) default SYS_GUID() PRIMARY KEY,

productNum VARCHAR2(50) NOT NULL,

productName VARCHAR2(50),

cityName VARCHAR2(50),

DepartureTime timestamp,

productPrice Number,

productDesc VARCHAR2(500),

productStatus INT,

CONSTRAINT product UNIQUE (id, productNum)

)

insert into PRODUCT (id, productnum, productname, cityname, departuretime, productprice,

productdesc, productstatus) 

3.maven工程搭建

 

 

 

  

创建子模块

itcast-ssm-web itcast-ssm-domain itcast-ssm-service itcast-ssm-dao itcast-ssm-utils 其中创建itcast-ssm-web

时，选择一个web工程

 

 4.pom.xml

<properties>

<spring.version>5.0.2.RELEASE</spring.version>

<slf4j.version>1.6.6</slf4j.version>

<log4j.version>1.2.12</log4j.version>

<oracle.version>11.2.0.1.0</oracle.version>

<mybatis.version>3.4.5</mybatis.version>

<spring.security.version>5.0.1.RELEASE</spring.security.version>

</properties>

<dependencies> <!-- spring -->

<dependency>

<groupId>org.aspectj</groupId>

<artifactId>aspectjweaver</artifactId>

<version>1.6.8</version>

</dependency>

<dependency>

<groupId>org.springframework</groupId>

<artifactId>spring-aop</artifactId>

<version>${spring.version}</version>

</dependency>

<dependency>

<groupId>org.springframework</groupId>

<artifactId>spring-context</artifactId>

<version>${spring.version}</version>

</dependency>

<dependency>

<groupId>org.springframework</groupId>

<artifactId>spring-context-support</artifactId>

<version>${spring.version}</version>

</dependency>

<dependency>

<groupId>org.springframework</groupId>

<artifactId>spring-web</artifactId>

<version>${spring.version}</version>

</dependency>

<dependency>

<groupId>org.springframework</groupId>

<artifactId>spring-orm</artifactId>

<version>${spring.version}</version>

</dependency>

<dependency>

<groupId>org.springframework</groupId>

<artifactId>spring-beans</artifactId>

<version>${spring.version}</version>

</dependency>

<dependency>

<groupId>org.springframework</groupId>

<artifactId>spring-core</artifactId>

<version>${spring.version}</version>

</dependency>

<dependency>

<groupId>org.springframework</groupId>

<artifactId>spring-test</artifactId>

<version>${spring.version}</version>

</dependency>

<dependency>

<groupId>org.springframework</groupId>

<artifactId>spring-webmvc</artifactId>

<version>${spring.version}</version>

</dependency>

<dependency>

<groupId>org.springframework</groupId>

<artifactId>spring-tx</artifactId>

<version>${spring.version}</version>

</dependency>

<dependency>

<groupId>junit</groupId>

<artifactId>junit</artifactId>

<version>4.12</version>

<scope>test</scope>

</dependency>

<dependency>

<groupId>javax.servlet</groupId>

<artifactId>javax.servlet-api</artifactId>

<version>3.1.0</version>

<scope>provided</scope>

</dependency>

<dependency>

<groupId>javax.servlet.jsp</groupId>

<artifactId>jsp-api</artifactId>

<version>2.0</version>

<scope>provided</scope>

</dependency>

<dependency>

<groupId>jstl</groupId>

<artifactId>jstl</artifactId>

<version>1.2</version>

</dependency> <!-- log start -->

<dependency>

<groupId>log4j</groupId>

<artifactId>log4j</artifactId>

<version>${log4j.version}</version>

</dependency>

<dependency>

<groupId>org.slf4j</groupId>

<artifactId>slf4j-api</artifactId>

<version>${slf4j.version}</version>

</dependency>

<dependency>

<groupId>org.slf4j</groupId>

<artifactId>slf4j-log4j12</artifactId>

<version>${slf4j.version}</version>

</dependency> <!-- log end -->

<dependency>

<groupId>org.mybatis</groupId>

<artifactId>mybatis</artifactId>

<version>${mybatis.version}</version>

</dependency>

<dependency>

<groupId>org.mybatis</groupId>

<artifactId>mybatis-spring</artifactId>

<version>1.3.0</version>

</dependency>

<dependency>

<groupId>c3p0</groupId>

<artifactId>c3p0</artifactId>

<version>0.9.1.2</version>

<type>jar</type>

<scope>compile</scope>

</dependency>

<dependency>

<groupId>com.github.pagehelper</groupId>

<artifactId>pagehelper</artifactId>

<version>5.1.2</version>

</dependency>

<dependency>

<groupId>org.springframework.security</groupId>

<artifactId>spring-security-web</artifactId>

<version>${spring.security.version}</version>

</dependency>

<dependency>

<groupId>org.springframework.security</groupId>

<artifactId>spring-security-config</artifactId>

<version>${spring.security.version}</version>

</dependency>

<dependency>

<groupId>org.springframework.security</groupId>

<artifactId>spring-security-core</artifactId>

<version>${spring.security.version}</version>

</dependency>

<dependency>

<groupId>org.springframework.security</groupId>

<artifactId>spring-security-taglibs</artifactId>

<version>${spring.security.version}</version>

</dependency>

<dependency>

<groupId>com.oracle</groupId>

<artifactId>ojdbc14</artifactId>

<version>${oracle.version}</version>

</dependency>

<dependency>

<groupId>javax.annotation</groupId>

<artifactId>jsr250-api</artifactId>

<version>1.0</version>

</dependency>

</dependencies>

<build>

<pluginManagement>

<plugins>

<plugin>

<groupId>org.apache.maven.plugins</groupId>

<artifactId>maven-compiler-plugin</artifactId>

<version>3.2</version>

<configuration>

<source>1.8</source>

<target>1.8</target>

<encoding>UTF-8</encoding>  

<showWarnings>true</showWarnings>

</configuration>

</plugin>

</plugins>

</pluginManagement>

</build>

5.实体类

public class Product {

private String id; // 主键

private String productNum; // 编号 唯一

private String productName; // 名称

private Date departureTime; // 时间

private String departureTimeStr;

private String productDesc; // 日程描述

private Integer productStatus; // 状态 0 关闭 1 开启

private String productStatusStr;

}

 

业务接口

public interface IProductService {

List<Product> findAll() throws Exception;

}

 

持久层接口 

public interface IProductDao {

@Select("select * from product")

List<Product> findAll() throws Exception;

}

 

6.Spring环境搭建 

编写Spring配置文件applicationContext.xml 

<!-- 配置 spring 创建容器时要扫描的包 -->

<!-- 开启注解扫描，管理service和dao -->

<context:component-scan base-package="com.itheima.ssm.service">

</context:component-scan>

<context:component-scan base-package="com.itheima.ssm.dao">

</context:component-scan> 

 

使用注解配置业务层 

@Service

public class ProductServiceImpl implements IProductService{

@Override

public List<Product> findAll() throws Exception {

return null;

}

}

 

7.Spring MVC 环境搭建

web.xml配置Spring MVC核心控制器

<!-- 配置 spring mvc 的核心控制器 -->

<servlet>

<servlet-name>springmvcDispatcherServlet</servlet-name>

<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>

<!-- 配置初始化参数，用于读取 springmvc 的配置文件 -->

<init-param>

<param-name>contextConfigLocation</param-name>

<param-value>classpath:springmvc.xml</param-value>

</init-param>

<!-- 配置 servlet 的对象的创建时间点：应用加载时创建。取值只能是非 0 正整数，表示启动顺 序 -->

<load-on-startup>1</load-on-startup>

</servlet>

<servlet-mapping>

<servlet-name>springmvcDispatcherServlet</servlet-name>

<url-pattern>/</url-pattern>

</servlet-mapping>

<!-- 配置 springMVC 编码过滤器 -->

<filter>

<filter-name>CharacterEncodingFilter</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>

<!-- 启动过滤器 -->

<init-param>

<param-name>forceEncoding</param-name>

<param-value>true</param-value>

</init-param>

</filter>

<!-- 过滤所有请求 -->

<filter-mapping>

<filter-name>CharacterEncodingFilter</filter-name>

<url-pattern>*.do</url-pattern>

</filter-mapping> 

 

Spring MVC配置文件springmvc.xml 

<!-- 扫描controller的注解，别的不扫描 -->

<context:component-scan base-package="com.itheima.ssm.controller">

</context:component-scan>

<!-- 配置视图解析器 -->

<bean id="viewResolver"

class="org.springframework.web.servlet.view.InternalResourceViewResolver">

<!-- JSP文件所在的目录 -->

<property name="prefix" value="/pages/" />

<!-- 文件的后缀名 -->

<property name="suffix" value=".jsp" />

</bean>

<!-- 设置静态资源不过滤 -->

<mvc:resources location="/css/" mapping="/css/**" />

<mvc:resources location="/img/" mapping="/img/**" />

<mvc:resources location="/js/" mapping="/js/**" />

<mvc:resources location="/plugins/" mapping="/plugins/**" />

<!-- 开启对SpringMVC注解的支持 -->

<mvc:annotation-driven />

<!--

支持AOP的注解支持，AOP底层使用代理技术

JDK动态代理，要求必须有接口

cglib代理，生成子类对象，proxy-target-class="true" 默认使用cglib的方式

-->

<aop:aspectj-autoproxy proxy-target-class="true"/>

</beans> 

 

编写Controller

@Controller

@RequestMapping("/product")

public class ProductController {

@Autowired

private IProductService productService;

@RequestMapping("/findAll.do")

public ModelAndView findAll() {

return null;

}

}