第7章编写Struts 2第一个程序【首页】杜老师

MyEclipse注册、源代码语法高亮、Struts 2备忘

(1) MyEclipse注册

myeclipse菜单：Myeclipse --> Subsription Infomation, 输入用户名和注册码
laodu yLR8ZC-855555-62656056556058147

(2) 源代码语法高亮

http://alexgorbatchev.com/SyntaxHighlighter/manual/brushes/php.html
配置http://alexgorbatchev.com/SyntaxHighlighter/manual/configuration/

0. 认识Struts 2

1. 创建Struts2项目

1.1 创建web项目

01JavaWeb07, 01学号 java EE 5.0, 复制apps\struts2-blank-2.3.16.3\WEB-INF\lib下9个包和mysql-connector-java-5.1.6-bin.jar到WEB-INF\lib

1.2 配置WebRoot\WEB-INF\web.xml

从apps\struts2-blank-2.1.6\WEB-INF\web.xml中复制粘贴有关filter部分到WebRoot\WEB-INF\web.xml中

1.3 创建action

在src创建cn.duzhaojiang.action包，创建RegisterAction01.java:
(1) import com.opensymphony.xwork2.ActionSupport;
(2) extends ActionSupport
(3) 执行方法public String execute()

package cn.duzhaojiang.action;

import com.opensymphony.xwork2.ActionSupport;

public class RegisterAction01 extends ActionSupport{
	private String username;	//用户名
	private String upassword;	//密码
	private String repassword;	//确认密码
	private String name;		//姓名
	private String age;			//年龄
	private String birth;		//出生日期
	private String email;		//email地址
	
	public String getUsername() {
		return username;
	}
	public void setUsername(String username) {
		this.username = username;
	}
	
	public String getUpassword() {
		return upassword;
	}
	public void setUpassword(String upassword) {
		this.upassword = upassword;
	}
	
	public String getRepassword() {
		return repassword;
	}
	public void setRepassword(String repassword) {
		this.repassword = repassword;
	}
	
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	
	public String getAge() {
		return age;
	}
	public void setAge(String age) {
		this.age = age;
	}
	
	public String getBirth() {
		return birth;
	}
	public void setBirth(String birth) {
		this.birth = birth;
	}
	
	public String getEmail() {
		return email;
	}
	public void setEmail(String email) {
		this.email = email;
	}
	
	public void validate() {
		if(upassword == null || "".equals(upassword)){
			this.addActionError("密码必须输入");
		}
		if(repassword == null || "".equals(repassword)) {
			this.addActionError("确认密码必须输入");
		}
		if(upassword != null && repassword != null && !repassword.equals(upassword)){
			this.addActionError("密码和确认密码必须相同");
		}
	}

//执行方法
	public String execute() throws Exception {
		return "success";
	}
}

1.4 创建注册页面WebRoot\Register01.jsp

注册页面：Register01.jsp
(1) gb2312 -- gbk
(2) taglib prefix="s" uri="/struts-tags"%
(3) form action="register.action" method="post"
(4) s:actionerror/

1.5 创建ShowUserInfo01.jsp gb2312 -- gbk

1.6 创建struts.xml配置文件

配置文件：src\struts.xml

1.7 创建index.jsp首页

首页：WebRoot\index.jsp

2. 用户登录

2.1 创建action

在cn.duzhaojiang.action包，创建LoginAction01.java

package cn.duzhaojiang.action;

import org.apache.struts2.ServletActionContext;
import com.opensymphony.xwork2.ActionSupport;

public class LoginAction01 extends ActionSupport {
	private String uname;	//用户名
	private String upass;	//密码
		
	public String getUname() {
		return uname;
	}
	public void setUname(String uname) {
		this.uname = uname;
	}
		
	public String getUpass() {
		return upass;
	}
	public void setUpass(String upassword) {
		this.upass = upassword;
	}
		
	//执行输入校验
	public void validate() {
		//如果用户名为null，或者为空的话，那么提示错误信息
		if(getUname() == null || "".equals(getUname().trim())){
			this.addFieldError("err_name", "必须输入用户名");
		}
			
		//如果密码...
		if(getUpass() == null || "".equals(getUpass().trim())){
			this.addFieldError("err_pass", "必须输入密码");
		}
	}

public String execute() throws Exception {
		if("dzjiang".equals(uname) & "123456".equals(upass)){
			//如果为合法用户，在request范围中添加属性login，其属性值为true，
			ServletActionContext.getRequest().setAttribute("login", "true");
			return SUCCESS;
		}else{
			return ERROR;
		}
	}
}

2.2 创建登录页面WebRoot\login01.jsp

2.3 创建成功登录页面login_success01.jsp

2.4 创建登录失败页面login_failure01.jsp

2.5 配置struts.xml文件

在配置文件src\struts.xml package中增加

3. 用户登录2

3.1 创建action

在cn.duzhaojiang.action包，创建LoginAction01_.java

package cn.duzhaojiang.action;

import java.util.HashMap;
import java.util.Map;
import org.apache.struts2.ServletActionContext;
import com.opensymphony.xwork2.ActionSupport;

public class LoginAction01_ extends ActionSupport {
	private String uname;	//用户名
	private String upass;	//密码
		
	public String getUname() {
		return uname;
	}
	public void setUname(String uname) {
		this.uname = uname;
	}
	public String getUpass() {
		return upass;
	}
	public void setUpass(String upassword) {
		this.upass = upassword;
	}
		
	//执行输入校验
	public void validate() {
		//如果用户名为null，或者为空的话，那么提示错误信息
		if(getUname() == null || "".equals(getUname().trim())){
			this.addFieldError("err_uname", "必须输入用户名");
		}
			
		//如果密码...
		if(getUpass() == null || "".equals(getUpass().trim())){
			this.addFieldError("err_upass", "必须输入密码");
		}
	}
	
	public String execute() throws Exception {
		Map<String,String> users = new HashMap<String,String>();
		users.put("杜老师", "123456");
		users.put("lmcd", "222222");
		users.put("ll", "555555");
		if(users.get(uname) == null){
			this.addActionError("该用户不存在!");
			return INPUT;
		}else {
			if(!users.get(uname).equals(upass)) {
				this.addActionError("用户密码错误!");
				return INPUT;
			}else {
				//如果为合法用户，在request范围中添加属性login，其属性值为true，
				ServletActionContext.getRequest().setAttribute("login", "true");
				return SUCCESS;
			}
		}
	}
}

3.2 创建登录页面WebRoot\login01_.jsp

3.3 配置struts.xml文件

在配置文件src\struts.xml package中增加, 布置测试

4. 车次管理

4.1 创建bean、创建数据表

(1) 创建cn.duzhaojiang.bean包，创建Train01.java

(2) 在MySql中创建数据表Train,

use javaweb04;

create table `train` (
  `no` varchar(10) not null default '',
  `sname` varchar(20) default null,
  `ename` varchar(20) default null,
  `price` decimal(10,2) default null,
  `time_` time default null,
  primary key  (`no`)
) engine=innodb default charset=gbk;

insert into train(no, sname, ename, price, time_) values('K689', '太原', '重庆北', 100, '8:47');
insert into train(no, sname, ename, price, time_) values('K1578', '太原', '福州', 100, '9:41');
insert into train(no, sname, ename, price, time_) values('K908', '太原', '杭州', 200, '10:00');
insert into train(no, sname, ename, price, time_) values('T69', '北京西', '乌鲁木齐南', 200, '10:00');
insert into train(no, sname, ename, price, time_) values('T270', '呼和浩特东', '上海', 200, '10:42');
insert into train(no, sname, ename, price, time_) values('K903', '太原', '厦门高崎', 200, '11:48');
insert into train(no, sname, ename, price, time_) values('K894', '大同', '杭州', 200, '11:55');
insert into train(no, sname, ename, price, time_) values('T175', '北京西', '西宁西', 200, '11:56');
insert into train(no, sname, ename, price, time_) values('K1624', '银川', '郑州', 200, '12:08');
insert into train(no, sname, ename, price, time_) values('K1082', '太原', '哈尔滨', 200, '12:10');
insert into train(no, sname, ename, price, time_) values('D2533', '太原南', '宝鸡南', 200, '12:20');
insert into train(no, sname, ename, price, time_) values('K1334', '银川', '上海', 200, '12:28');
insert into train(no, sname, ename, price, time_) values('K1115', '北京西', '包头', 200, '13:14');
insert into train(no, sname, ename, price, time_) values('K1623', '郑州', '银川', 200, '14:10');
insert into train(no, sname, ename, price, time_) values('K730', '大同', '广州东', 200, '14:19');
insert into train(no, sname, ename, price, time_) values('K731', '大同', '广州东', 200, '14:19');
insert into train(no, sname, ename, price, time_) values('Z55', '北京西', '兰州', 200, '14:34');
insert into train(no, sname, ename, price, time_) values('K566', '太原', '南通', 200, '15:46');
insert into train(no, sname, ename, price, time_) values('K1337', '济南', '乌鲁木齐南', 200, '16:07');
insert into train(no, sname, ename, price, time_) values('K374', '太原', '上海', 200, '16:59');
insert into train(no, sname, ename, price, time_) values('T7', '北京西', '成都', 200, '17:10');
insert into train(no, sname, ename, price, time_) values('K1292', '太原', '烟台', 200, '17:48');
insert into train(no, sname, ename, price, time_) values('T277', '北京西', '银川', 200, '19:12');
insert into train(no, sname, ename, price, time_) values('K520', '太原', '秦皇岛', 200, '19:33');
insert into train(no, sname, ename, price, time_) values('Z98', '太原', '上海', 200, '19:55');
insert into train(no, sname, ename, price, time_) values('Z192', '太原', '沈阳北', 300, '20:57');
insert into train(no, sname, ename, price, time_) values('K1398', '太原', '温州', 300, '20:57');
insert into train(no, sname, ename, price, time_) values('K884', '太原', '青岛', 300, '21:37');
insert into train(no, sname, ename, price, time_) values('K237', '太原', '深圳西', 300, '23:32');

select * from train;

(3) 创建cn.duzhaojiang.util包，创建DBConnection.java, 需引入jdbc驱动程序如mysql-connector-java-5.1.6-bin.jar

package cn.duzhaojiang.util;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class DBConnection {
	private static final String DBDRIVER = "com.mysql.jdbc.Driver" ;			//驱动类类名
	private static final String DBURL = "jdbc:mysql://localhost:3306/javaweb04";	//连接URL
	private static final String DBUSER = "root" ;								//数据库用户名
	private static final String DBPASSWORD = "6337925";					//数据库密码

public static Connection getConnection(){
		Connection conn = null;													//声明一个连接对象
		try {
			Class.forName(DBDRIVER);											//注册驱动
			conn = DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD);		//获得连接对象
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return conn;
	}

public static void close(Connection conn) {
		if(conn != null) {				//如果conn连接对象不为空
			try {
				conn.close();			//关闭conn连接对象对象
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
	
	public static void close(PreparedStatement pstmt) {
		if(pstmt != null) {				//如果pstmt预处理对象不为空
			try {
				pstmt.close();			//关闭pstmt预处理对象
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
	
	public static void close(ResultSet rs) {
		if(rs != null) {				//如果rs结果集对象不为null
			try {
				rs.close();				//关闭rs结果集对象
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
}

4.2 创建dao，impl

(1) 创建cn.duzhaojiang.dao包，创建TrainDAO01.java

(2) 在cn.duzhaojiang.dao创建TrainDAOImpl01.java

package cn.duzhaojiang.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import cn.duzhaojiang.bean.Train01;
import cn.duzhaojiang.dao.TrainDAO01;
import cn.duzhaojiang.util.DBConnection;

public class TrainDAOImpl01 implements TrainDAO01 {
	//实现添加车次的方法
	public void addTrain(Train01 train) {
		Connection conn = DBConnection.getConnection();	//获得连接对象
		String addSQL = "insert into train(no,sname,ename,price, time_) values(?,?,?,?,?)";
		PreparedStatement pstmt = null;					//声明预处理对象
		try {
			pstmt = conn.prepareStatement(addSQL);		//获得预处理对象并赋值
			pstmt.setString(1, train.getNo());		//设置第一个参数
			pstmt.setString(2, train.getSname());	//设置第二个参数
			pstmt.setString(3, train.getEname());			//设置第三个参数
			pstmt.setDouble(4, train.getPrice());	//设置第四个参数
			pstmt.setString(5, train.getTime());	//设置第5个参数
			pstmt.executeUpdate();								//执行更新
		} catch (SQLException e) {
			e.printStackTrace();
		} finally{
			DBConnection.close(pstmt);							//关闭预处理对象
			DBConnection.close(conn);							//关闭连接对象
		}
	}
	//实现删除车次的方法
	public void deleteTrain(String NO) {
		Connection conn = DBConnection.getConnection();	//获得连接对象
		String updateSQL = "delete from train where no=?";
		PreparedStatement pstmt = null;					//声明预处理对象
		try {
			pstmt = conn.prepareStatement(updateSQL);		//获得预处理对象并赋值
			pstmt.setString(1, NO);			//设置第一个个参数
			pstmt.executeUpdate();								//执行更新
		} catch (SQLException e) {
			e.printStackTrace();
		} finally{
			DBConnection.close(pstmt);							//关闭预处理对象
			DBConnection.close(conn);							//关闭连接对象
		}
	}
	//实现查询车次的方法
	public List<Train01> findAllTrain() {
		Connection conn = DBConnection.getConnection();	//获得连接对象
		String updateSQL = "select * from train";
		PreparedStatement pstmt = null;					//声明预处理对象
		List<Train01> trainList = new  ArrayList<Train01>();
		try {
			pstmt = conn.prepareStatement(updateSQL);		//获得预处理对象并赋值
			ResultSet rs = pstmt.executeQuery();			//执行查询
			while(rs.next()) {
				Train01 train = new Train01();		//实例化
				train.setNo(rs.getString(1));
				train.setSname(rs.getString(2));
				train.setEname(rs.getString(3));
				train.setPrice(rs.getDouble(4));
				train.setTime(rs.getString(5));
				trainList.add(train);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally{
			DBConnection.close(pstmt);							//关闭预处理对象
			DBConnection.close(conn);							//关闭连接对象
		}
		return trainList;									//返回查询到的所有车次
	}
	//实现更新车次的方法
	public void updateTrain(Train01 train) {
		Connection conn = DBConnection.getConnection();	//获得连接对象
		String updateSQL = "update train set sname = ?,ename = ?,price = ?,time_ = ? where no = ?";
		PreparedStatement pstmt = null;					//声明预处理对象
		try {
			pstmt = conn.prepareStatement(updateSQL);		//获得预处理对象并赋值
			pstmt.setString(1, train.getSname());		//设置第一个参数
			pstmt.setString(2, train.getEname());				//设置第二个参数
			pstmt.setDouble(3, train.getPrice());			//设置第三个参数
			pstmt.setString(4, train.getTime());			//设置第四个参数
			pstmt.setString(5, train.getNo());			//设置第四个参数
			pstmt.executeUpdate();								//执行更新
		} catch (SQLException e) {
			e.printStackTrace();
		} finally{
			DBConnection.close(pstmt);							//关闭预处理对象
			DBConnection.close(conn);							//关闭连接对象
		}
	}
	
	public Train01 findTrainByNo(String NO) {
		Connection conn = DBConnection.getConnection();	//获得连接对象
		String sSQL = "select * from train where no = ?";
		PreparedStatement pstmt = null;					//声明预处理对象
		Train01 train = new Train01();				//实例化
		try {
			pstmt = conn.prepareStatement(sSQL);		//获得预处理对象并赋值
			pstmt.setString(1, NO);					//设置参数
			ResultSet rs = pstmt.executeQuery();			//执行查询
			if(rs.next()) {
				train.setNo(rs.getString(1));
				train.setSname(rs.getString(2));
				train.setEname(rs.getString(3));
				train.setPrice(rs.getDouble(4));
				train.setTime(rs.getString(5));
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally{
			DBConnection.close(pstmt);							//关闭预处理对象
			DBConnection.close(conn);							//关闭连接对象
		}
		return train;
	}
}

4.3 创建页面

(1) 添加车次页面WebRoot\trainAdd01.jsp

(2) 查询车次页面WebRoot\queryTrain01.jsp

(3) 显示车次页面WebRoot\ShowTrain01.jsp

(4) 显示所有车次页面WebRoot\ShowTrainList01.jsp

<%@page language="java" pageEncoding="gbk"%>
<%@page import="cn.duzhaojiang.bean.Train01"%>
<%@page import="cn.duzhaojiang.dao.TrainDAO01"%>
<%@page import="cn.duzhaojiang.dao.TrainDAOImpl01"%>
<%@page import="java.util.List"%>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<html>
<head>
	<title>车次列表</title>  
</head>
<body>
	<%
		//获得DAO实现类实例
		TrainDAO01 trainDAO = new TrainDAOImpl01();
		//查找所有车次记录  
		List<Train01> trainList = trainDAO.findAllTrain();
		//将所有记录保存到page范围  
		pageContext.setAttribute("trainList",trainList);
	%>
	<h1>车次列表(杜兆将老师整理)</h1>
	<hr />
	<table width="700" border="1">
		<tr>
			<td>火车车次</td>
			<td>起点站名称</td>
			<td>终点站名称</td>
			<td>全程票价</td>
			<td>发车时间</td>
		</tr>
		<c:forEach var="train" items="${pageScope.trainList}"><%-- 循环输出 --%>
		<tr>
			<td>${train.no }</td>
			<td>${train.sname }</td>
			<td>${train.ename }</td>
			<td>${train.price }</td>
			<td>${train.time }</td>
		</tr>
		</c:forEach>
	</table>
	<hr/>
	<a href="/01JavaWeb07">返回本章目录</a>
</body>
</html>

4.4 创建action、配置struts.xml

(1) 在cn.duzhaojiang.action包，创建TrainAddAction01.java

package cn.duzhaojiang.action;
import com.opensymphony.xwork2.ActionSupport;
import cn.duzhaojiang.bean.Train01;
import cn.duzhaojiang.dao.TrainDAO01;
import cn.duzhaojiang.dao.TrainDAOImpl01;

public class TrainAddAction01 extends ActionSupport {
	private String no;		//车次
	private String sname;	//起点站名称
	private String ename;	//终点站名称
	private double price;	//全程票价
	private String time;	//始发时间
	
	public String getNo() {
		return no;
	}
	public void setNo(String no) {
		this.no = no;
	}
	public String getSname() {
		return sname;
	}
	public void setSname(String sname) {
		this.sname = sname;
	}
	public String getEname() {
		return ename;
	}
	public void setEname(String ename) {
		this.ename = ename;
	}
	public double getPrice() {
		return price;
	}
	public void setPrice(double price) {
		this.price = price;
	}
	public String getTime() {
		return time;
	}
	public void setTime(String time) {
		this.time = time;
	}

public String execute() throws Exception {
		Train01 train = new Train01();
		train.setNo(no);
		train.setSname(sname);
		train.setEname(ename);
		train.setPrice(price);
		train.setTime(time);
		TrainDAO01 trainDAO = new TrainDAOImpl01();
		trainDAO.addTrain(train);
		return SUCCESS;
	}
}

(2) 在cn.duzhaojiang.action包，创建TrainQueryAction01.java

(3) 在配置文件src\struts.xml package中增加

(4) 配置文件src\struts.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE struts PUBLIC
 "-//Apache Software Foundation//DTD Struts Configuration 2.3//EN"
 "http://struts.apache.org/dtds/struts-2.3.dtd">
<struts>
	<constant name="struts.i18n.encoding" value="gbk" />
	<constant name="struts.enable.DynamicMethodInvocation" value="false" />
	<constant name="struts.devMode" value="false" />

<package name="struts2" extends="struts-default">
		
		<action name="register" class="cn.duzhaojiang.action.RegisterAction01">
			
 			<result name="success">/ShowUserInfo01.jsp</result>
			<result name="input">/Register01.jsp</result>
		</action>

<action name="login" class="cn.duzhaojiang.action.LoginAction01">
			<result name="success">/login_success01.jsp</result>
			<result name="input">/login01.jsp</result>
			<result name="error">/login_failure01.jsp</result>
		</action>
		
		<action name="login_" class="cn.duzhaojiang.action.LoginAction01_">
			<result name="success">/login_success01.jsp</result>
			<result name="input">/login01_.jsp</result>
			<result name="error">/login_failure01.jsp</result>
		</action>
		
		<action name="TrainAdd" class="cn.duzhaojiang.action.TrainAddAction01">
			<result name="success">/ShowTrainList01.jsp</result>
		</action>
		
		<action name="QueryTrain" class="cn.duzhaojiang.action.TrainQueryAction01">
			<result name="success">/ShowTrain01.jsp</result>
		</action>
		
	</package>	
</struts>

返回章节目录

第7章 编写Struts 2第一个程序【首页】杜老师

MyEclipse注册、源代码语法高亮、Struts 2备忘

(1) MyEclipse注册

(2) 源代码语法高亮

0. 认识Struts 2

1. 创建Struts2项目

1.1 创建web项目

1.2 配置WebRoot\WEB-INF\web.xml

1.3 创建action

1.4 创建注册页面WebRoot\Register01.jsp

1.5 创建ShowUserInfo01.jsp gb2312 -- gbk

1.6 创建struts.xml配置文件

1.7 创建index.jsp首页

2. 用户登录

2.1 创建action

2.2 创建登录页面WebRoot\login01.jsp

2.3 创建成功登录页面login_success01.jsp

2.4 创建登录失败页面login_failure01.jsp

2.5 配置struts.xml文件

3. 用户登录2

3.1 创建action

3.2 创建登录页面WebRoot\login01_.jsp

3.3 配置struts.xml文件

4. 车次管理

4.1 创建bean、创建数据表

4.2 创建dao，impl

4.3 创建页面

4.4 创建action、配置struts.xml

第7章编写Struts 2第一个程序【首页】杜老师