itemdet.jsp

来自「这是一个学习jsp的基本程序」· JSP 代码 · 共 56 行

<%@ page
    language="java"
    contentType="text/html; charset=GBK"
    import="imis.*,javax.naming.*,javax.rmi.PortableRemoteObject,java.util.*,java.sql.*,java.io.*"
%>
<%
    request.setCharacterEncoding("GBK");
    session=request.getSession();
    userStruct user=(userStruct)session.getAttribute("user");
    if(user==null){
    response.sendRedirect("../../login.html");
    }
  else if(user.userAccess.intValue()==0||user.userAccess.intValue()==1)
          response.sendRedirect("../../error/access.html");
  else{


%>
<%

  String itemname = request.getParameter("itemname");
  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/imis";
  Class.forName("com.sybase.jdbc2.jdbc.SybDriver");
  Connection  con=DriverManager.getConnection(url,"wmj","197555");
  Statement stmt=con.createStatement();
  ResultSet rs=null;
  String sql="select distinct ITEMID from ITEMTABLE where ITEMNAME='"+itemname+"'";
  rs=stmt.executeQuery(sql);
 Integer itemid=new Integer(-1);
  while(rs.next())
  {
  itemid=new Integer(rs.getInt("ITEMID"));
  }
  rs.close();
  stmt.close();
  con.close();

  response.sendRedirect("../item/item_detail.jsp?wherecome=1&&itemId="+itemid.toString());
%>
<%}%>