package com.shopping.action;import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;import com.shopping.actionForm.orderForm;
import com.shopping.dao.orderDao;import java.sql.*;
public class orderAction extends Action {
private orderDao orderdao ;
public orderAction() {
orderDao dao=new orderDao();
this.orderdao = new orderDao();
}
/************************执行方法****************************/
public ActionForward execute(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response)
throws Exception {
String action = request.getParameter("action");
if(action == null) {
request.setAttribute("error", "action为空");
System.out.println("action参数为空");
return mapping.findForward("error");
//以订单编号查询
} else if("selectonebynumber".equals(action)) {
return orderselect(mapping,form,request,response);
//删除订单
} else if("delete".equals(action)) {
return orderDelete(mapping,form,request,response) ;
} else {
return mapping.findForward("error");
}
}
package com.shopping.dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;import com.shopping.actionForm.orderForm;
import com.shopping.actionForm.orderForm;
import com.shopping.core.DB;public class orderDao {
/**************************************查询******************************/
public orderForm selectone(String number) {
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
orderForm orderform=null;
String sql = "select * from tb_order where number = '"+number+"'";
int flag=0;
try {
conn = DB.getConn();
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
while(rs.next()) {
orderform=new orderForm();
orderform.setId(Integer.valueOf(rs.getString("id")));
orderform.setAdress(rs.getString("address"));
orderform.setMemberid(Integer.valueOf(rs.getString("memberid")));
orderform.setNumber(Integer.valueOf((rs.getString("number"))));
orderform.setSetmoney((rs.getString("money")));
orderform.setState(Integer.valueOf(rs.getString("state")));
}
} catch(SQLException e) {
e.printStackTrace();
} finally {
DB.close(rs);
DB.close(stmt);
DB.close(conn);
}
return orderform;
}
<struts-config.xml>
<action path="/admin/orderAction"
type="com.shopping.action.orderAction"
scope="request"
name="orderForm">
<forward name="orderselectone" path="/admin/order_oneresult.jsp"></forward>
<forward name="" path=""> </forward>
<forward name="" path=""> </forward>
</action>
import javax.servlet.http.HttpServletResponse;import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;import com.shopping.actionForm.orderForm;
import com.shopping.dao.orderDao;import java.sql.*;
public class orderAction extends Action {
private orderDao orderdao ;
public orderAction() {
orderDao dao=new orderDao();
this.orderdao = new orderDao();
}
/************************执行方法****************************/
public ActionForward execute(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response)
throws Exception {
String action = request.getParameter("action");
if(action == null) {
request.setAttribute("error", "action为空");
System.out.println("action参数为空");
return mapping.findForward("error");
//以订单编号查询
} else if("selectonebynumber".equals(action)) {
return orderselect(mapping,form,request,response);
//删除订单
} else if("delete".equals(action)) {
return orderDelete(mapping,form,request,response) ;
} else {
return mapping.findForward("error");
}
}
package com.shopping.dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;import com.shopping.actionForm.orderForm;
import com.shopping.actionForm.orderForm;
import com.shopping.core.DB;public class orderDao {
/**************************************查询******************************/
public orderForm selectone(String number) {
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
orderForm orderform=null;
String sql = "select * from tb_order where number = '"+number+"'";
int flag=0;
try {
conn = DB.getConn();
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
while(rs.next()) {
orderform=new orderForm();
orderform.setId(Integer.valueOf(rs.getString("id")));
orderform.setAdress(rs.getString("address"));
orderform.setMemberid(Integer.valueOf(rs.getString("memberid")));
orderform.setNumber(Integer.valueOf((rs.getString("number"))));
orderform.setSetmoney((rs.getString("money")));
orderform.setState(Integer.valueOf(rs.getString("state")));
}
} catch(SQLException e) {
e.printStackTrace();
} finally {
DB.close(rs);
DB.close(stmt);
DB.close(conn);
}
return orderform;
}
<struts-config.xml>
<action path="/admin/orderAction"
type="com.shopping.action.orderAction"
scope="request"
name="orderForm">
<forward name="orderselectone" path="/admin/order_oneresult.jsp"></forward>
<forward name="" path=""> </forward>
<forward name="" path=""> </forward>
</action>
解决方案 »
- Could not parse configuration: /com/ccit/entca/conf/hibernate.cfg.xml 在线急等!!!
- 重金悬赏EqualsBuilder 这个东西到哪里去了
- ibatis+spring+struts2 的问题
- 做过邮件开发的请进,谢谢。。。。。。。。。。。。。。。。。。。。。分不是问题!【标题要长】
- 新闻的置顶怎么实现?
- hibernate问题
- 大家好,我想自定义一个Struts的验证规则,请问该怎么做啊
- oracle 9i JDeveloper 用着怎么样?
- Struts+Hibernate+Spring的一个小疑问?
- 运行两个ServerSocket进行网络监听,端口会不会冲突?
- java webservice问题
- java迷茫中,请高手指教
form就直接 <form action="/admin/orderAction.do">