复件 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 = null;
		try
		{
			pstm = conn.prepareStatement(sql);
			pstm.executeUpdate();
			conn.commit();
		}
		catch(SQLException sqle)
		{
			//System.out.println("执行DataBase::ExecuteSQL(String)调用SQL语句 "+sql+" 时出错;\r\n错误为:"+sqle);
			return sqle.getErrorCode();
		}
		finally{
			try{
			pstm.close();
			}catch(SQLException sqle){System.out.println("执行DataBase::ExecuteSQL(String)调用SQL语句 "+sql+" 时出错;\r\n错误为:"+sqle);}
		}
		return 0;
	}

%>