action.jsp

jsp+oracle书记的源代码

<%@page language="java" contentType="text/html;charset=GBK"%>
<%@page import="java.util.*,java.text.*,java.sql.*,oa.main.DealString,oa.main.DealTime"%>
<jsp:useBean id="pb" class="oa.main.ParentBean" scope="page"/>
<jsp:useBean id="smsbean" class="oa.bean.SmsBean" scope="page"/>

<%
try{
	if (pb.getConn() == null){
	%>		
	数据库无法响应,请<a href="javascript:window.history.back(-1);">返回</a>重试
	<%out.close();
    }

	DealString ds = new DealString();
	String time = ds.getDateTime();
	//修改时的编号
	String id = ds.toString(request.getParameter("id"));//id
	//登陆用户的编号
	String zgbh = (String)session.getAttribute("zgbh");
	String ip = "http://"+request.getRemoteAddr();


	//新增数据.......
	int errcode = -1;
	String sql = "";
	if(action1!=null && action1.equals("add"))
	{
		//out.println("正在新增数据.......");
		strID = getMaxNo("HG2_MEET_NOTICE");
		sql = "insert into HG2_MEET_NOTICE values('"+String.valueOf(strID)+"','"+strTitle+"','"+strKeyWord+"','"+strWordNo+"',"+strJB+",'"+strAddtime+"','"+strStarttime+"','"+strEndtime+"','"+zgbh+"',0)";

		errcode = pb.executeUpdate(sql);

		String []strReceivers = strReceiver.split(";");
		for(int tmp = 0;tmp<strReceivers.length;tmp++)
		{
			maxNo = getMaxNo("HG2_MEET_NOTICEMEN");
			sql = "insert into HG2_MEET_NOTICEMEN values('"+String.valueOf(maxNo)+"','"+String.valueOf(strID)+"','"+strReceivers[tmp]+"','','','0','0')";
			errcode = pb.executeUpdate(sql);
		}

		
		response.sendRedirect("list.jsp");
	}

%>
<%}finally{
	if(pb!=null)
		pb.closeConn();
	if(smsbean!=null)
		smsbean.closeConn();
}%>