struts开发总结

struts开发小结

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%@taglib uri="/struts-tags" prefix="s" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
? <head>
??? <base href="<%=basePath%>">
???
??? <title>My JSP 'Category_input.jsp' starting page</title>
???
?<meta http-equiv="pragma" content="no-cache">
?<meta http-equiv="cache-control" content="no-cache">
?<meta http-equiv="expires" content="0">???
?<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
?<meta http-equiv="description" content="This is my page">
?

? </head>
?
? <body>
? <form action="admin/Category-update" method="post">
? ?<input type="hidden" name="category.id" value="<s:property value="category.id"/>" />
? ?
? ?name:<input name="category.name" value="<s:property value="category.name"/>"? />
? ?description:<textarea name="category.description"><s:property value="category.description"/></textarea>
? ?<input type="submit" value="update" />
? </form>
? </body>
</html> struts开发总结

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

<!DOCTYPE struts PUBLIC

?? ?"-//Apache Software Foundation//DTD Struts Configuration 2.1//EN"

?? ?"http://struts.apache.org/dtds/struts-2.1.dtd">

<struts> ?

<package name="bbs2009_default" extends="struts-default"> ?

<global-results>

?? ? <result name="error">/error.jsp</result>

?? ? </global-results>

?? ?

?<global-exception-mappings>

?? ? <exception-mapping result="error" exception="java.lang.Exception"></exception-mapping>

?? ? </global-exception-mappings> ? ? ?? ?? ???

</package>

?? ?<package name="admin" namespace="/admin" extends="bbs2009_default" >

?? ?? <action name="index">

??? <result>/admin/index.html</result>

??? </action>

???

?? ? ? <action name="*-*" method="{2}">

?? ? ?? <result>/admin/{1}-{2}.jsp</result>

?? ? ?? <result name="input">/admin/{1}-{2}.jsp</result>

?? ? ?? ?<!-- <exception-mapping result="error" exception="java.sql.SQLException" /> ?

?? ? ?? ?<result name="error">/error.jsp</result> -->

?? ? ? </action>

?? ? ? <!--?

?? ? ? <action name="category" style="font-size: 12px! important; line-height: normal;">?? ? ?? <result>/admin/category_list.jsp</result>

?? ? ?? <result name="add_input">/admin/category_add_input.jsp</result>

?? ? ?? <result name="update_input">/admin/category_update_input.jsp</result> ? ? ?

?? ? ? </action>

?? ? ? ?-->

?? ?</package>

?? ?

?? ?<package name="front" namespace="/" extends="struts-default" >

?? ? <default-action-ref name="Category_list" />

?? ? ? <action name="Category_list" method="list">

?? ? ?? <result>/index.jsp</result>

?? ? ? </action>

?? ?</package>

</struts>

DB.java

package com.bjsxt.bbs2009.util;

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

public class DB {
?public static Connection createConn() {
??Connection conn = null;
??try {
???Class.forName("com.mysql.jdbc.Driver");
???conn = DriverManager.getConnection("jdbc:mysql://localhost/bbs2009", "root", "bjsxt");
??} catch (ClassNotFoundException e) {
???e.printStackTrace();
??} catch (SQLException e) {
???e.printStackTrace();
??}
??return conn;
?}
?
?public static PreparedStatement prepare(Connection conn, String sql) {
??PreparedStatement ps = null;
??try {
???ps = conn.prepareStatement(sql);
??} catch (SQLException e) {
???e.printStackTrace();
??}
??return ps;
?}
?
?public static void close(Connection conn) {
??
??try {
???conn.close();
???conn = null;
??} catch (SQLException e) {
???e.printStackTrace();
??}
?}
?public static void close(Statement stmt) {
??try {
???stmt.close();
???stmt = null;
??} catch (SQLException e) {
???e.printStackTrace();
??}
?}
?public static void close(ResultSet rs) {
??try {
???rs.close();
???rs = null;
??} catch (SQLException e) {
???e.printStackTrace();
??}
?}
}

Catagary.java(model)

package com.bjsxt.bbs2009.model;

public class Category {
?private int id;
?private String name;
?private String description;
?public int getId() {
??return id;
?}
?public void setId(int id) {
??this.id = id;
?}
?public String getName() {
??return name;
?}
?public void setName(String name) {
??this.name = name;
?}
?public String getDescription() {
??return description;
?}
?public void setDescription(String description) {
??this.description = description;
?}
?
}

CatagaryService.java

package com.bjsxt.bbs2009.service;

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 com.bjsxt.bbs2009.model.Category;
import com.bjsxt.bbs2009.util.DB;

public class CategoryService {
?public void add(Category c) {
??Connection conn = DB.createConn();
??String sql = "insert into _category values (null, ?, ?)";
??PreparedStatement ps = DB.prepare(conn, sql);
??try {
???ps.setString(1, c.getName());
???ps.setString(2, c.getDescription());
???ps.executeUpdate();
??} catch (SQLException e) {
???e.printStackTrace();
??}
??DB.close(ps);
??DB.close(conn);
?}
?
?public List<Category> list() throws SQLException {
??Connection conn = DB.createConn();
??String sql = "select * from _category_";
??PreparedStatement ps = DB.prepare(conn, sql);
??List<Category> categories = new ArrayList<Category>();
??try {
???ResultSet rs = ps.executeQuery();
???Category c = null;
???while(rs.next()) {
????c = new Category();
????c.setId(rs.getInt("id"));
????c.setName(rs.getString("name"));
????c.setDescription(rs.getString("description"));
????categories.add(c);
???}
??} catch (SQLException e) {
???e.printStackTrace();
???throw(e);
??}
??DB.close(ps);
??DB.close(conn);
??return categories;
?}
?
?public void delete(Category c) {
??deleteById(c.getId());
?}
?
?public void deleteById(int id) {
??Connection conn = DB.createConn();
??String sql = "delete from _category where id = ?";
??PreparedStatement ps = DB.prepare(conn, sql);
??try {
???ps.setInt(1, id);
???ps.executeUpdate();
??} catch (SQLException e) {
???e.printStackTrace();
??}
??DB.close(ps);
??DB.close(conn);
?}
?
?public void update(Category c) {
??Connection conn = DB.createConn();
??String sql = "update _category set name = ?, description = ? where id = ?";
??PreparedStatement ps = DB.prepare(conn, sql);
??try {
???ps.setString(1, c.getName());
???ps.setString(2, c.getDescription());
???ps.setInt(3, c.getId());
???ps.executeUpdate();
??} catch (SQLException e) {
???e.printStackTrace();
??}
??DB.close(ps);
??DB.close(conn);
?}
?
?public Category loadById(int id) {
??Connection conn = DB.createConn();
??String sql = "select * from _category where id = ?";
??PreparedStatement ps = DB.prepare(conn, sql);
??Category c = null;
??try {
???ps.setInt(1, id);
???ResultSet rs = ps.executeQuery();
??
???if(rs.next()) {
????c = new Category();
????c.setId(rs.getInt("id"));
????c.setName(rs.getString("name"));
????c.setDescription(rs.getString("description"));
???}
??} catch (SQLException e) {
???e.printStackTrace();
??}
??DB.close(ps);
??DB.close(conn);
??return c;
?}
}

CatagaryAction.java

package com.bjsxt.bbs2009.action;

import java.util.List;

import com.bjsxt.bbs2009.model.Category;
import com.bjsxt.bbs2009.service.CategoryService;
import com.opensymphony.xwork2.ActionSupport;

public class CategoryAction extends ActionSupport {
?private List<Category> categories;
?private CategoryService categoryService = new CategoryService();
?private Category category;
?private int id;
?
?public String list() throws Exception {
??categories = categoryService.list();
??return SUCCESS;
?}
?
?
?
?public String add() {
??categoryService.add(category);
??return SUCCESS;
?}
?public String update() {
??categoryService.update(category);
??return SUCCESS;
?}
?public String delete() {
??categoryService.deleteById(id);
??return SUCCESS;
?}
?public String addInput() {
??
??return INPUT;
?}
?public String updateInput() {
??this.category = this.categoryService.loadById(id);
??return INPUT;
?}
?public List<Category> getCategories() {
??return categories;
?}
?public void setCategories(List<Category> categories) {
??this.categories = categories;
?}
?public CategoryService getCategoryService() {
??return categoryService;
?}
?public void setCategoryService(CategoryService categoryService) {
??this.categoryService = categoryService;
?}
?public Category getCategory() {
??return category;
?}
?public void setCategory(Category category) {
??this.category = category;
?}
?public int getId() {
??return id;
?}
?public void setId(int id) {
??this.id = id;
?}
}

Category-list.jsp

? </head>
?
? <body>
Category_list
<a href="admin/Category-addInput">添加Category</a>
<a href="admin/Category-updateInput">更新Category</a>

<hr/>
<s:iterator value="categories" var="c">
?<s:property value="#c.name"/> |
?<s:property value="#c.description"/> |
?<a href="admin/Category-delete?id=<s:property value="#c.id"/>">删除Category</a> |
?<a href="admin/Category-updateInput?id=<s:property value="#c.id"/>">更新Category</a>
?<br/>
</s:iterator>
<s:debug></s:debug>
? </body>
</html>

Category-add.jsp

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
? <head>
??? <base href="<%=basePath%>">
???
??? <title>My JSP 'Category_input.jsp' starting page</title>
???
?<meta http-equiv="pragma" content="no-cache">
?<meta http-equiv="cache-control" content="no-cache">
?<meta http-equiv="expires" content="0">???
?<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
?<meta http-equiv="description" content="This is my page">
?

? </head>
?
? <body>
add ok!
? </body>
</html>

Category-addInput.jsp

? </head>
?
? <body>
? <form action="admin/Category-add" method="post">
? ?name:<input name="category.name" />
? ?description:<textarea name="category.description"></textarea>
? ?<input type="submit" value="add" />
? </form>
? </body>
</html>

Category-delete.jsp

? </head>
?
? <body>
Category_delete
? </body>
</html>

Category-updateInput.jsp

Category-update.jsp

? </head>
?
? <body>
? update ok!
? </body>
</html>

mysql.sql

create database bbs2009;

use bbs2009;

create table _category(id int primary key auto_increment, name varchar(50), descrtiption varchar(200));

struts开发总结

热点推荐