【JSP开源代码栏目提醒】:网学会员在JSP开源代码频道为大家收集整理了复件action.jsp提供大家参考,希望对大家有所帮助!
<%@page language="java" contentType="text/html;charset=GBK"%>
<%@page import="java.util.*,java.text.*,java.sql.*,oa.main.DealString,oa.main.ParentBean"%>
<jsp:useBean id="pb" class="oa.main.ParentBean" scope="page"/>
<%
DealString ds = new DealString();
//增删改动作标志
String action = ds.toString(request.getParameter("action"));
//修改时的编号
String id = ds.toString(request.getParameter("id"));
String zgbh = (String)session.getAttribute("zgbh");
//取得表单数据
String strJB = ds.toString(request.getParameter("sel_jb"));
String strReceiver = ds.toString(request.getParameter("txt_receiverZGBH"));
String strTitle = ds.toString(request.getParameter("txt_title"));
String strKeyWord = ds.toString(request.getParameter("txt_kw"));
String strAddtime = ds.toString(request.getParameter("addtime"));
String strStarttime = ds.toString(request.getParameter("starttime"));
String strEndtime = ds.toString(request.getParameter("endtime"));
String strWordNo = "1";//ds.toString(request.getParameter("txt_
wordno"));
//新增数据.......
if(action!=null && action.equals("add"))
{
out.println("正在新增数据.......");
int strID = getMaxNo("HG2_MEET_NOTICE");
String sql = "";
sql = "insert into HG2_MEET_NOTICE values('"+String.valueOf(strID)+"','"+strTitle+"','"+strKeyWord+"','"+strWordNo+"',"+strJB+",'"+strAddtime+"','"+strStarttime+"','"+strEndtime+"','"+zgbh+"',0)";
int errcode = ExecuteSQL(sql);
/* Vector sqlvt = new Vector();
sqlvt.add("HG2_MEET_NOTICE");
sqlvt.add(pb.addVector("ID", String.valueOf(strID), "CHAR"));
sqlvt.add(pb.addVector("TITLE", strTitle, "CHAR"));
sqlvt.add(pb.addVector("KEYWORD", strKeyWord, "CHAR"));
sqlvt.add(pb.addVector("WORD", strWordNo, "CHAR"));
sqlvt.add(pb.addVector("LEVEL", strJB, "NUM"));
sqlvt.add(pb.addVector("TIME", strAddtime, "CHAR"));
sqlvt.add(pb.addVector("TIMESTART", strStarttime, "CHAR"));
sqlvt.add(pb.addVector("TIMEEND",strEndtime,"CHAR"));
sqlvt.add(pb.addVector("SENDER",zgbh, "CHAR"));
sqlvt.add(pb.addVector("ISDEL","0","NUM"));
pb.insertRecord(sqlvt);
*/
String []strReceivers = strReceiver.split(";");
for(int tmp = 0;tmp<strReceivers.length;tmp++)
{
int maxNo = getMaxNo("HG2_MEET_NOTICEMEN");
sql = "insert into HG2_MEET_NOTICEMEN values('"+String.valueOf(maxNo)+"','"+String.valueOf(strID)+"','"+strReceivers[tmp]+"','','','0','0',')";
errcode = ExecuteSQL(sql);
/* Vector vt = new Vector();
vt.add("HG2_MEET_NOTICEMEN");
vt.add(pb.addVector("ID", String.valueOf(maxNo), "CHAR"));
vt.add(pb.addVector("NOTICEID", String.valueOf(strID), "CHAR"));
vt.add(pb.addVector("RECEIVER", strReceivers[tmp], "CHAR"));
vt.add(pb.addVector("REBACK", "", "CHAR"));
vt.add(pb.addVector("READTIME", "", "CHAR"));
vt.add(pb.addVector("ISREAD", "0", "NUM"));
vt.add(pb.addVector("ISDEL","0","NUM"));
pb.insertRecord(vt);
*/
}
out.println("oooooooooooookkkkkkkkkkkkkkkkkk"+errcode);
//response.sendRedirect("list.jsp");
}
//修改数据.......
if(action!=null && action.equals("mod"))
{
out.println("正在修改数据.......");
response.sendRedirect("list.jsp");
}
//删除数据.......
if(action!=null && action.equals("del"))
{
out.println("正在删除数据.......");
response.sendRedirect("list.jsp");
}
%>
<%!
public int getMaxNo(String tabname)
{
DealString ds = new DealString();
ParentBean pb = new ParentBean();
String maxNo = "0";
String sql = "select max(ID) as id from "+tabname;
ResultSet rs = pb.selectRecord(sql);
Statement stmt = null;
try{
while (rs.next()) { //取得本部门的级别序号的最大编号
maxNo = ds.toString(rs.getString("id"));
}
}catch(Exception e){System.out.println("取得HG2_MEET_NOTICE最大ID时出错:"+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("取得HG2_MEET_NOTICE最大ID关闭记录集rs时出错"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("取得HG2_MEET_NOTICE最大ID关闭声明时statement出错"+e);}
}
return Integer.parseInt(maxNo)+1;
}
public int ExecuteSQL(String sql)
{
Connection conn = null;
PreparedStatement pstm =