struts1曾查

最新推荐文章于 2024-07-16 15:41:31 发布

slnandhml

最新推荐文章于 2024-07-16 15:41:31 发布

阅读量281

点赞数

文章标签： struts exception stylesheet import string html

本文链接：https://blog.csdn.net/slnandhml/article/details/4941473

版权

package s101;

import org.apache.struts.action.ActionForm;

public class ViewEmpForm extends ActionForm{

Emp emp=new Emp();

public Emp getEmp() {

return emp;

}

public void setEmp(Emp emp) {

this.emp = emp;

}

package s101;

import java.util.ArrayList;

import java.util.List;

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;

public class ViewEmpAction extends Action{

@Override

public ActionForward execute(ActionMapping mapping, ActionForm form,

HttpServletRequest request, HttpServletResponse response)throws Exception {

// TODO Auto-generated method stub

ViewEmpForm vef=(ViewEmpForm)form;

EmpDao edao=new EmpDao();

List emplist=new ArrayList();

emplist=edao.findEmp(vef.getEmp());

// System.out.println(vef.getEmp().getEmpno());

request.setAttribute("c", emplist);

return mapping.findForward("view");

}

package s101;

import java.sql.*;

import java.util.*;

public class EmpDao {

public void addEmp(Emp e)throws Exception{

Connection con=null;

PreparedStatement ps=null;

try{

Class.forName("oracle.jdbc.driver.OracleDriver");

String url="jdbc:oracle:thin:@192.168.0.199:1521:udare";

String user="udare09003";

String pass="udare09003";

con=DriverManager.getConnection(url,user,pass);

String sql="insert into emp(empno,ename,job,sal)"+" values(?,?,?,?)";

ps=con.prepareStatement(sql);

ps.setInt(1, e.getEmpno());

// ps.setString(1, e.getEmpno());

ps.setString(2, e.getEname());

ps.setString(3,e.getJob());

ps.setDouble(4,e.getSal());

ps.executeUpdate();

}catch(Exception ee){

ee.printStackTrace();

}finally{

try{

ps.close();

}catch(Exception e1){

e1.printStackTrace();

}

try{

con.close();

}catch(Exception e2){

e2.printStackTrace();

}

public List findEmp(Emp e)throws Exception{

Connection con=null;

Statement st=null;

ResultSet rs=null;

List list=new ArrayList();

try{

Class.forName("oracle.jdbc.driver.OracleDriver");

String url="jdbc:oracle:thin:@192.168.0.199:1521:udare";

String user="udare09003";

String pass="udare09003";

con=DriverManager.getConnection(url,user,pass);

st=con.createStatement();

String sql="select empno,ename,sal,job from emp";

rs=st.executeQuery(sql);

Emp emp=null;

while(rs.next()){

emp=new Emp();

emp.setEmpno(rs.getInt("empno"));

// emp.setEmpno(rs.getString("empno"));

emp.setEname(rs.getString("ename"));

emp.setSal(rs.getDouble("sal"));

emp.setJob(rs.getString("job"));

list.add(emp);

}

}catch(Exception ex){

ex.printStackTrace();

}finally{

try{

rs.close();

}catch(Exception ex){}

try{

st.close();

}catch(Exception ex){}

try{

con.close();

}catch(Exception ex){}

}

return list;

}

-----

<%@ page language="java" import="java.util.*" pageEncoding="gbk"%>

<%@ taglib uri="http://struts.apache.org/tags-bean" prefix="bean" %>

<%@ taglib uri="/WEB-INF/struts-html.tld" prefix="html" %>

<%@ taglib uri="http://struts.apache.org/tags-logic" prefix="logic" %>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

<head>

<title>My JSP 'viewemp.jsp' starting page</title>

<!--

-->

</head>

<body>

<html:form action="viewemp" method="post">

empno:<html:text property="emp.empno"></html:text>

ename:<html:text property="emp.ename"></html:text>

job:<html:text property="emp.job"></html:text>

<html:submit value="查看"></html:submit>

</html:form>

</body>

</html>

-----------------

<%@ page language="java" import="java.util.*" pageEncoding="gbk"%>

<%@page import="s101.Emp"%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

<head>

<title>My JSP 'view.jsp' starting page</title>

<!--

-->

</head>

<body>

List<Emp>list=(List)request.getAttribute("c");

int size=list.size();

for(int i=0;i<size;i++){

Emp emp=(Emp)list.get(i);

out.println(emp.getEmpno()+" ");

out.println(emp.getEname());

}

<!--

empno: ${requestScope.b.emp.empno}

ename: ${requestScope.b.emp.ename}

job: ${requestScope.b.emp.job}

-->

</body>

</html>

查询时要通过遍历输出，而不是获得FormBean的值，在配置中的attribute b在Action中list的名字就不能是b，他或覆盖前一个b取FormBean的值的时候就找不到原来的attribute里面的b

slnandhml

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
struts1曾查

package s101; import org.apache.struts.action.ActionForm; public class ViewEmpForm extends ActionForm{ Emp emp=new Emp(); public Emp getEmp() { return emp; } public void
复制链接

扫一扫