manuadd.jsp

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

<%@ page
    language="java"
    contentType="text/html; charset=GBK"
    import="imis.*,javax.naming.*,java.text.*,javax.rmi.PortableRemoteObject,java.util.*,java.sql.*"
%>

<%
  request.setCharacterEncoding("GBK");
  session=request.getSession();
  userStruct user=(userStruct)session.getAttribute("user");
  if(user==null){
  response.sendRedirect("../../login.html");
  }else if(user.userAccess.equals(new Integer(9))){
%>
<%
  //String manuid=request.getParameter("manuid");
  String manuname=request.getParameter("manuname");
  String manuaddress=request.getParameter("manuaddress");
  String manucommunicate=request.getParameter("manucommunicate");
  String manuproduct=request.getParameter("manuproduct");
  String manucop=request.getParameter("manucop") ;
  String manuevalue=request.getParameter("manuevalue") ;
  String manuaftersale=request.getParameter("manuaftersale") ;
  String manuintroduce=request.getParameter("manuintroduce") ;
  %>
<%
  ManufactureJBean manuToadd =null;
  manuToadd = new ManufactureJBean();
  //manuToadd.manufacturer_id = manuid;
  manuToadd.name = manuname;
  manuToadd.address = manuaddress;
  manuToadd.communicate = manucommunicate;
  manuToadd.product = manuproduct;
  manuToadd.cop = manucop;
  manuToadd.evaluate = manuevalue;
  manuToadd.aftersale = manuaftersale;
  manuToadd.introduce = manuintroduce;
  manuToadd.unitid = user.unitid ;
%>

<%
  //Class.forName("COM.ibm.db2.jdbc.net.DB2Driver").newInstance();
  //String url="jdbc:db2://127.0.0.1:6789/imis";
  String url="jdbc:sybase:Tds:172.16.0.1:4000/imis";
  Class.forName("com.sybase.jdbc2.jdbc.SybDriver").newInstance();
  Connection conn= DriverManager.getConnection(url,"wmj","197555");

//sequence seq = new sequence();
String sql = "select SEQUENCEID from SEQUENCE where SEQUENCENAME='MANUFACTURER'";
//ResultSet rs = null;
//rs = seq.executeQuery(sql);

PreparedStatement ps=conn.prepareStatement(sql);
ResultSet rs = ps.executeQuery();
int id = 0;
while(rs.next()){
  id = rs.getInt("SEQUENCEID");
  System.out.println("id="+id);
    Integer intmanuid = new Integer(id+1);
    System.out.println("intmanuid="+intmanuid);
    manuToadd.manufacturer_id = intmanuid.toString();
    String sql2 = "update SEQUENCE set SEQUENCEID="+intmanuid.intValue()+" where SEQUENCENAME='MANUFACTURER'";
    PreparedStatement ps1=conn.prepareStatement(sql2);
    int number = ps1.executeUpdate();
    ps1.close();
}
rs.close();
ps.close();
conn.close();;

%>
<%
boolean blnSucc = true;
  try{
    Context ctx = new InitialContext();
    Object ref = ctx.lookup("OtherController");
    OtherControllerHome otherControllerHome = (OtherControllerHome) PortableRemoteObject.narrow(ref, OtherControllerHome.class);
    OtherController othercontroller = otherControllerHome.create();
    blnSucc = othercontroller.addManufacture(manuToadd);
     response.sendRedirect("manulist.jsp") ;
}
   catch (Exception e){
     //e.printStackTrace();
     response.sendRedirect("../../error/adderror.html");
   }
}else{
    response.sendRedirect("../../error/accesserror.html");
}
%>