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; } } ----- empno:
ename:
job:
-----------------
struts1曾查
最新推荐文章于 2024-01-16 20:44:20 发布