用struts对数据库进行增删改查

用struts框架对数据库增删改查(2008-08-20 07:53:52)
转载标签：it 分类：2008年8月 
增删改查的所有方法
AddDAO.java
package dao;

import java.sql.Connection;
import java.sql.PreparedStatement;

import connector.Connector;

import domain.EmArchive;

public class AddDAO {
    public void addEmArchive(EmArchive em) {
    Connection conn = null;
    PreparedStatement pstmt = null;
    try {
        conn = Connector.getCopnnection();
        String sql = "insert into archive values(?,?,?,?,?)";
        pstmt = conn.prepareStatement(sql);
        pstmt.setString(1, em.getId());
        pstmt.setString(2, em.getName());
        pstmt.setString(3, em.getSex());
        pstmt.setInt(4, em.getAge().intValue());
        pstmt.setString(5, em.getDept());

        pstmt.executeUpdate();

    } catch (Exception e) {

        e.printStackTrace();
    }
}


}

DeleteDAO.java
package dao;

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

import connector.Connector;

public class DeleteDAO {
    public void deleteEmArchive(String id){
    Connection conn=null;
    PreparedStatement pstmt=null;
    ResultSet rs=null;
    try{
        conn=Connector.getCopnnection();
        String sql="delete from archive where id=?";
        pstmt=conn.prepareStatement(sql);
        pstmt.setString(1,id);
        pstmt.executeUpdate();
       
        }catch(Exception e){
            e.printStackTrace();