/18-spring-web-2
这里我们实现输入学生姓名和年龄登录,转入一个欢迎页面,并将输入的学生信息导入数据库。
使用的是Tomcat7.0和Servlet2.5版本,因此会有一个web.xml文件。
实体类
package com.bjpowernode.beans;
public class Student {
private Integer id;
private String name;
private int age;
public Student() {
super();
// TODO Auto-generated constructor stub
}
public Student(String name, int age) {
super();
this.name = name;
this.age = age;
}
public Integer getId() {
return id;
}
public String getName() {
return name;
}
public int getAge() {
return age;
}
public void setId(Integer id) {
this.id = id;
}
public void setName(String name) {
this.name = name;
}
public void setAge(int age) {
this.age = age;
}
@Override
public String toString() {
return "Student [id=" + id + ", name=" + name + ", age=" + age + "]";
}
}
Dao层接口
SQL执行方法
import java.util.List;
import com.bjpowernode.beans.Student;
public interface IStudentDao {
void insertStudent(Student student);
void deleteById(int id);
void updateStudent(Student student);
List<Student> selectAllStudents();
Student selectStudentById(int id);
}
Dao层映射文件
写入SQL语句
<?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.bjpowernode.dao.IStudentDao">
<insert id="insertStudent">
insert into student(name,age) values(#{name}, #{age})
</insert>
<delete id="deleteById">
delete from student where id = #{xxx}
</delete>
<update id="updateStudent">
update student set name=#{name},age=#{age} where id=#{id}
</update>
<select id="selectAllStudents" resultType="Student">
select id,name,age from student
</select>
<select id="selectStudentById" resultType="Student">
select id,name,age from student where id=#{xxx}
</select>
</mapper>
service服务层
接口
package com.bjpwernode.service;
import java.util.List;
import com.bjpowernode.beans.Student;
public interface IStudentService {
void addStudent(Student student);
void removeById(int id);
void modifyStudent(Student student);
List<String> findAllStudentsNames();
String findStudentNameById(int id);
List<Student> findAllStudents();
Student findStudentById(int id);
}
实现类 创建Dao层接口对象private IStudentDao dao,并调用Dao层接口中的方法
package com.bjpwernode.service;
import java.util.ArrayList;
import java.util.List;
import com.bjpowernode.beans.Student;
import com.bjpowernode.dao.IStudentDao;
public class StudentServiceImpl implements IStudentService {
private IStudentDao dao;
public void setDao(IStudentDao dao) {
this.dao = dao;
}
@Override
public void addStudent(Student student) {
dao.insertStudent(student);
}
@Override
public void removeById(int id) {
dao.deleteById(id);
}
@Override
public void modifyStudent(Student student) {
dao.updateStudent(student);
}
@Override
public List<String> findAllStudentsNames() {
List<String> names = new ArrayList<String>();
List<Student> students = this.findAllStudents();
for(Student student : students) {
names.add(student.getName());
}
return names;
}
@Override
public String findStudentNameById(int id) {
Student student = this.findStudentById(id);
return student.getName();
}
@Override
public List<Student> findAllStudents() {
return dao.selectAllStudents();
}
@Override
public Student findStudentById(int id) {
return dao.selectStudentById(id);
}
}
继承Servlet
注意Servlet是由Tomcat服务器为我们创建的,不能交给Spring来赋值
实现doGet、doPost方法
1、通过request请求获取到输入信息
由于学生年龄是int类型,传输使用的是字节流,所以要转换类型
2、获取到Spring容器对象
这里有个问题 如果将获取写到doPost方法里,那么每次我们提交学生信息时,就会获取一个Spring容器,这显然不是我们想要的。我们想到了Servlet中的init()方法,但是如果有多个继承实现Servlet类的其他GenericServlet、LoginServlet等,如果每个里面都写了init(),还是会导致一样的问题。
这时监听器出场了,解决了我们的困惑。
注册ServletContext监听器,完成两件工作:
1)在ServletContext被创建时,创建Spring容器对象
2)将创建好的Spring容器对象放入到ServletContext的域属性空间
获取的方式有两种
一个是通过key,另一种比较推荐使用工具类
3、输出获取到的Spring容器,多次登录看是否只创建了一个对象
4、从Spring容器获取到Service对象,注入
5、调用Service的addStudent完成插入
6、导入欢迎页面
package com.bjpowernode.servlets;
import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.springframework.web.context.WebApplicationContext;
import org.springframework.web.context.support.WebApplicationContextUtils;
import com.bjpowernode.beans.Student;
import com.bjpwernode.service.IStudentService;
public class RegisterServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doPost(request, response);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
String name = request.getParameter("name");
String ageStr = request.getParameter("age");
Integer age = Integer.valueOf(ageStr);
//int age2 = Integer.parseInt(ageStr);区别就是返回类型不同,用哪个都可以
Student student = new Student(name, age);
//Servlet是由Tomcat服务器为我们创建的,不能交给Spring来赋值
//获取到Spring容器对象
/*这种方式过于麻烦,我们可以使用工具类获取Spring容器
* String ackey = WebApplicationContext.ROOT_WEB_APPLICATION_CONTEXT_ATTRIBUTE;
* ApplicationContext ac = (ApplicationContext)
* this.getServletContext().getAttribute(ackey);
*/
WebApplicationContext ac = WebApplicationContextUtils.getRequiredWebApplicationContext(getServletContext());
System.out.println("ac = " + ac);
//从Spring容器获取到Service对象,注入
IStudentService service = (IStudentService) ac.getBean("studentService");
//调用Service的addStudent完成插入
service.addStudent(student);
request.getRequestDispatcher("/welcome.jsp").forward(request, response);
}
}
jdbc、mybatis、spring.xml都放在src类路径下
jdbc 四大要素
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://127.0.0.1:3306/test
jdbc.user=root
jdbc.password=333
mybatis 注册mapper、指定类非限定性别名(学生类所在位置)
<?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.bjpowernode.beans"/>
</typeAliases>
<mappers>
<!-- <mapper resource="com/bjpowernode/dao/mapper.xml"/> -->
<!-- 报名指定为dao,就不用配mapper.xml了,但需要xml与接口同名 -->
<package name="com.bjpowernode.dao"/>
</mappers>
</configuration>
spring
1、数据源
2、jdbc属性文件
3、配置mybatis映射文件和数据源
4、生成Dao的代理对象
5、注册Service
<?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:context="http://www.springframework.org/schema/context" xsi:schemaLocation="
http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd">
<!-- 注册数据源:C3P0 -->
<bean id="myDataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="driverClass" value="${jdbc.driver}"/>
<property name="jdbcUrl" value="${jdbc.url}"/>
<property name="user" value="${jdbc.user}"/>
<property name="password" value="${jdbc.password}"/>
</bean>
<!-- 注册属性文件 -->
<context:property-placeholder location="classpath:jdbc.properties"/>
<!-- 配置映射文件和数据源 -->
<bean id="mySqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="configLocation" value="classpath:mybatis.xml"/>
<property name="dataSource" ref="myDataSource"/>
</bean>
<!-- 生成Dao的代理对象
当前配置会为指定的基本包中所有的接口生成代理对象
-->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="sqlSessionFactoryBeanName" value="mySqlSessionFactory"/>
<property name="basePackage" value="com.bjpowernode.dao"/>
</bean>
<!-- 注册Service -->
<bean id="studentService" class="com.bjpwernode.service.StudentServiceImpl">
<!-- 这里的Dao的注入需要使用ref属性,
若Dao的接口名的前两个字母是大写, 则这里的值为接口的简单类名
若只有首字母大写,第二个字母为小写,则这里应该为studentDao(接口的简单类名 首字母小写)-->
<property name="dao" ref="IStudentDao"/>
</bean>
</beans>
Web.xml
这里index和welcome.jsp就省略了,不是很重要的
在web.xml中声明了几次,即使同一个Servlet,如果声明多次,也会生成多个实例。
1、指定了Spring配置文件的路径和名称
2、注册ServletContext监听器
完成两件工作:
1)在ServletContext被创建时,创建Spring容器对象
2)将创建好的Spring容器对象放入到ServletContext的域属性空间
3、注册RegisterServlet
<?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">
<!-- 指定了Spring配置文件的路径和名称 -->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:spring.xml</param-value>
</context-param>
<!-- 注册ServletContext监听器,完成两件工作:
1)在ServletContext被创建时,创建Spring容器对象
2)将创建好的Spring容器对象放入到ServletContext的域属性空间
-->
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<servlet>
<servlet-name>Register-Servlet</servlet-name>
<servlet-class>com.bjpowernode.servlets.RegisterServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>Register-Servlet</servlet-name>
<url-pattern>/registerServlet</url-pattern>
</servlet-mapping>
<welcome-file-list>
<welcome-file>index.jsp</welcome-file>
</welcome-file-list>
</web-app>