modify.jsp

《jsp案例开发》这本书的源代码。包括源代码和相关的具体配置操作步骤。非常不错

<%@ page
    language="java"
    contentType="text/html; charset=GBK"
    import="imis.*,javax.naming.*,java.text.*,javax.rmi.PortableRemoteObject,java.util.*,java.io.*,java.sql.*"
%>
<%
String name="wmj";
String pass="197555";
String   url=new  String();
//url="jdbc:db2://127.0.0.1:6789/imis";
//Class.forName("COM.ibm.db2.jdbc.net.DB2Driver");
url="jdbc:sybase:Tds:172.16.0.1:4000/wei";
  Class.forName("com.sybase.jdbc2.jdbc.SybDriver");
  request.setCharacterEncoding("GBK");
  session=request.getSession();
  userStruct user=(userStruct)session.getAttribute("user");
  if(user==null){
  response.sendRedirect("../../login.html");
  }
else{

%>

<%
  NavigationmarkStruct ns=null;
  ns=new NavigationmarkStruct();

  SmartUpload mySmartUpload=new SmartUpload();

  mySmartUpload.initialize(pageContext);

  mySmartUpload.upload();

  int count=0;

  count=mySmartUpload.getFiles().getCount();

  UploadFile myFile=null;



%>
<%
String  markid=mySmartUpload.getRequest().getParameter("markid");
String markname=mySmartUpload.getRequest().getParameter("markname");
String marktype=mySmartUpload.getRequest().getParameter("marktype");
String area=mySmartUpload.getRequest().getParameter("area");
String longitude=mySmartUpload.getRequest().getParameter("longitude");
String latitude=mySmartUpload.getRequest().getParameter("latitude");
String markunit=mySmartUpload.getRequest().getParameter("markunit");
String lightheight=mySmartUpload.getRequest().getParameter("lightheight");
String lightqualith=mySmartUpload.getRequest().getParameter("lightquality");
String lightlamp=mySmartUpload.getRequest().getParameter("lightlamp");
String range=mySmartUpload.getRequest().getParameter("range");
//String haiba=mySmartUpload.getRequest().getParameter("haiba");
String userange = mySmartUpload.getRequest().getParameter("userange");
String installtime=mySmartUpload.getRequest().getParameter("installtime");
%>

<%
Context ctx = new InitialContext();
  //look up jndi name
Object ref = ctx.lookup("NavigationmarkControllerEJB");
//cast to Home interface
NavigationmarkControllerEJBHome nscHome = (NavigationmarkControllerEJBHome) PortableRemoteObject.narrow(ref, NavigationmarkControllerEJBHome.class);
NavigationmarkControllerEJB nsc = nscHome.create();
ns=nsc.getNavigationmarkValue(markname);

%>

<%
  officeUnitStruct ous = new officeUnitStruct();

  OfficeUnitControllerHome officeUnitControllerHome = null;
  OfficeUnitController officeUnitController = null;
  Context ctx1 = new InitialContext();

         //look up jndi name
         Object ref1 = ctx1.lookup("OfficeUnitController");

         //cast to Home interface
      officeUnitControllerHome = (OfficeUnitControllerHome) PortableRemoteObject.narrow(ref1, OfficeUnitControllerHome.class);
          officeUnitController=officeUnitControllerHome.create();
          Collection c=officeUnitController.getProcessName(markunit);
          Iterator i=c.iterator();
          while(i.hasNext())
    ous=(officeUnitStruct)i.next();

%>


<%
Mydate md = new Mydate();
if(!installtime.equals(""))
  ns.installtime=md.stringToDate(installtime);

if(!markid.equals(""))
  ns.markid=markid;
  ns.markname=markname;
  ns.marktype=new Integer(marktype);
if(!area.equals(""))
  ns.area=area;
if(!longitude.equals(""))
  ns.longitude=longitude;
if(!latitude.equals(""))
  ns.latitude=latitude;
  ns.markunit=markunit;
  ns.unitid=ous.unitid;
if(!lightheight.equals(""))
  ns.lightheight=lightheight;
if(!lightqualith.equals(""))
  ns.lightqualith=lightqualith;
if(!lightlamp.equals(""))
  ns.lightlamp=lightlamp;
if(!range.equals(""))
  ns.range=range;
//if(!haiba.equals(""))
  //ns.haiba=haiba;
if(!userange.equals(""))
  ns.userange = userange;

ns.haiba=lightheight;
int photosize=0;
if(count>0){
              myFile = mySmartUpload.getFiles().getFile(0);
              photosize=myFile.getSize();
              ByteArrayInputStream photo=new ByteArrayInputStream(myFile.getPhoto(),0,photosize);
              ns.navigationimage=photo;
           }

%>



<%
  boolean o=true;
  int insertnum=0;

  try{
    String  sqlin="";


             Connection  con=DriverManager.getConnection(url,name,pass);

             if(photosize>0){
               //System.out.println("1");
             sqlin="update navigationmark set mark_id=?,mark_name=?,mark_type=?,area=?,longitude=?,latitude=?,mark_unit=?,light_height=?,light_qualith=?,light_lamp=?,range=?,haiba_height=?,unitid=?,userange=?,installtime=?,navigationimage=? where mark_name='"+markname+"'";
             }
             else
             {
               //System.out.println("2");
             sqlin="update navigationmark set mark_id=?,mark_name=?,mark_type=?,area=?,longitude=?,latitude=?,mark_unit=?,light_height=?,light_qualith=?,light_lamp=?,range=?,haiba_height=?,unitid=?,userange=?,installtime=? where mark_name='"+markname+"'";
             }
             PreparedStatement ps=con.prepareStatement(sqlin);
             //System.out.println("3");
             ps.setString(1,ns.markid);
             ps.setString(2,ns.markname);
             ps.setInt(3,ns.marktype.intValue());
             ps.setString(4,ns.area);
             ps.setString(5,ns.longitude);
             ps.setString(6,ns.latitude);
             ps.setString(7,ns.markunit);
             ps.setString(8,ns.lightheight);
             ps.setString(9,ns.lightqualith);
             ps.setString(10,ns.lightlamp);
             ps.setString(11,ns.range);
             ps.setString(12,ns.haiba);
             ps.setInt(13,ns.unitid.intValue());
             ps.setString(14,userange);
             ps.setDate(15,ns.installtime);
             if(photosize>0)
             {
             ps.setBinaryStream(16,ns.navigationimage,photosize);
             }
             insertnum=ps.executeUpdate();
            // System.out.println("4");

             ps.close();
             con.close();
}catch(Exception e)
  {
  e.printStackTrace();
  o=false;
}

%>

<%
if(o&&(insertnum>0))
  response.sendRedirect("navigationmarkq.jsp");
else
  response.sendRedirect("../../error/modifyerror.html");
%>


<%}%>