简单的struts应用开发（4）

第五步:建立action (useraction.java)

这里我们将建产两个action .

useraction.java 将完成以下工作.
1.添加(前期数据准备. 主是提取部门资料.并传递给adduser.jsp)
2.修改(前期数据准备)
3.删除
4.查看所有用户资料.

user1action.java 将完成以下工作
1.添加用户(对myuser表操作)
2.修改用户(对myuser表操作)

package mystruts;

import org.apache.struts.action.*;
import javax.servlet.http.*;
import mystruts.*;
import java.util.*;
import java.sql.*;
import connectionpool.*;

public class useraction extends action {
public actionforward execute(actionmapping actionmapping, actionform actionform, httpservletrequest httpservletrequest, httpservletresponse httpservletresponse) throws exception
{
userdao dao=new userdao();
httpservletrequest request=httpservletrequest;
string action;
if(request.getparameter("action").equals("") || request.getparameter("action")==null)
{
action="add";
}
else
{
action=request.getparameter("action");
}
if(action.equals("add"))
{
request.setattribute("dep",this.getdep());
return (actionmapping.findforward("add"));
}
if(action.equals("edit"))
{
string key=request.getparameter("key");
request.setattribute("dep",this.getdep());
request.setattribute("useractionform",dao.getuser(key));
return (actionmapping.findforward("add"));
}
if(action.equals("del"))
{
string key=request.getparameter("key");
dao.deluser(key);
return (actionmapping.findforward("delview"));
}
if(action.equals("view"))
{
request.setattribute("rs",dao.getalluser());
return (actionmapping.findforward("view"));
}

return null;
}
//---------------------------------------------
public collection getdep()
{
getdbconnection db=new getdbconnection();
connection con=db.getcon();
resultset rs=null;

preparedstatement ps = null;

arraylist rslist = new arraylist();

string sql="select * from mydep";
try {
ps = con.preparestatement(sql);
rs=ps.executequery();
while(rs.next())
{
hashmap rscol = new hashmap();
rscol.put("id",rs.getstring("dep_id"));
rscol.put("name1",rs.getstring("dep_name"));
rslist.add(rscol);
}
}
catch (sqlexception e)
{
system.out.println("sql error");
}
finally
{
try{
con.close();
db.d_close();
}
catch(exception e) {}
}
return rslist;
}
}



package mystruts;

import org.apache.struts.action.*;
import javax.servlet.http.*;

public class user1action extends action {
public actionforward execute(actionmapping actionmapping, actionform actionform, httpservletrequest httpservletrequest, httpservletresponse httpservletresponse) throws exception
{
useractionform uaf = (useractionform) actionform;
if(uaf.getaction().equals("add"))
{
new userdao().userinsert(uaf);
return (actionmapping.findforward("view"));
}
if(uaf.getaction().equals("edit"))
{
new userdao().userupdate(uaf);
return (actionmapping.findforward("view"));
}
return null;
}
}
（未完待续）