navigationadd.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:10.0.7.12: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=mySmartUpload.getFiles().getCount();

  UploadFile myFile=null;

//System.out.println(count);

%>

<%
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");
//System.out.println("1");
//System.out.println(markunit);
//System.out.println("2");

%>

<%
  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();

%>

<%

ns.markid=markid;
ns.markname=markname;
ns.marktype=new Integer(marktype);
ns.area=area;
ns.longitude=longitude;
ns.latitude=latitude;
ns.markunit=markunit;
ns.unitid=ous.unitid;
ns.lightheight=lightheight;
ns.lightqualith=lightqualith;
ns.lightlamp=lightlamp;
ns.range=range;
ns.haiba=lightheight;
ns.userange=userange;
Mydate md = new Mydate();
if(!installtime.equals(""))
  ns.installtime=md.stringToDate(installtime);
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;
           }
//System.out.println(photosize);
%>



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

  try{

             //System.out.println("1");
             Connection  con=DriverManager.getConnection(url,name,pass);
             //System.out.println("2");
             String  sqlin="insert into navigationmark (mark_id,mark_name,mark_type,area,longitude,latitude,mark_unit,light_height,light_qualith,light_lamp,range,haiba_height,unitid,userange,navigationimage,installtime)  values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
             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,ns.userange);
             ps.setBinaryStream(15,ns.navigationimage,photosize);
             ps.setDate(16,ns.installtime);
             insertnum=ps.executeUpdate();
             ps.close();
             con.close();
}catch(Exception e)
  {
  e.printStackTrace();
  o=false;
}

%>

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

<%}%>