despatch.jsp

来自「This project mainly deals with automatin」· JSP 代码 · 共 97 行

JSP
97 行
字号 
<%@ page  language="java" import="java.sql.*,javax.servlet.*,javax.servlet.http.*,java.io.*,java.util.*" %>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body bgcolor="#20099CC">
<%! int a=1;%>
<form action="./FinDes_Process.jsp " name="form132" method="post" >


<% Class.forName("oracle.jdbc.driver.OracleDriver");
 Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:india","scott","tiger");
Statement stmt=con.createStatement();
 ResultSet rs=stmt.executeQuery("select max(sno) from fin_despatch ");
while(rs.next())
{
 a=rs.getInt(1);  } %><% a=a+1; %>



<% Class.forName("oracle.jdbc.driver.OracleDriver");
 Connection con2=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:india","scott","tiger");
Statement stmt2=con2.createStatement();
 ResultSet rs2=stmt2.executeQuery("select itemnumber from fin_recieved2 group by(itemnumber)");
 %>



<% Class.forName("oracle.jdbc.driver.OracleDriver");
 Connection con3=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:india","scott","tiger");
Statement stmt3=con3.createStatement();
 ResultSet rs3=stmt3.executeQuery("select dealername from dealer ");
 %>


<div align="center">
  <p><strong><font color="#FFFFFF" size="5">INVENTORY CONTROL SYSTEM </font></strong></p>
  <p><font color="#FFFFFF" size="4">FIN DESPATCH</font></p>
  <table width="63%" border="0">
    <tr> 
      <td><div align="right"><font color="#FFFFFF"><strong>S.No :</strong></font></div></td>
      <td><input type="text" name="sno" value=<%=a%> readonly></td>
    </tr>
    <tr> 
      <td><div align="right"><font color="#FFFFFF"><strong>Requisition No :</strong></font></div></td>
      <td><input type="text" name="reqno"></td>
    </tr>
    <tr> 
      <td><div align="right"><font color="#FFFFFF"><strong>Item No :</strong></font></div></td>
      <td><select name="itemnumber" id="itemnumber">

<%while(rs2.next())
{
 %>
<option value=<%=rs2.getInt(1)%>><%=rs2.getInt(1)%></option>
<%
}
%>
</select></font></strong></td>
    </tr>
    <tr> 
      <td><div align="right"><font color="#FFFFFF"><strong>QtyDes :</strong></font></div></td>
      <td><input type="text" name="qtydes"></td>
    </tr>
    <tr> 
      <td><div align="right"><font color="#FFFFFF"><strong>DesDate :</strong></font></div></td>
      <td><input type="text" name="desdate"></td>
    </tr>
    <tr> 
      <td><div align="right"><font color="#FFFFFF"><strong>Dealer Name :</strong></font></div></td>
      <td><select name="dealername"><%while(rs3.next())
{
 %>
<option value=<%=rs3.getString(1)%>><%=rs3.getString(1)%></option>
<%
}
%>
</select></td>
    </tr>
     <tr> 
      <td><div align="right"><font color="#FFFFFF"><strong>Amount :</strong></font></div></td>
      <td><input type="text" name="amount"></td>
    </tr>

  </table>
  <p> 
    <input type="submit" name="Submit" value="Submit">
    <input name="Reset" type="reset" id="Reset" value="Reset">
    <a href="Clerk.jsp">HOME </a></p>
  <p><font size="4"></font> </p>
</div>
</form>
</body>
</html>

despatch.jsp - 源码说明

本页面展示了「This project mainly deals with automating the tasks of Purchasing, maintaining,manfactioring and tra」中的 despatch.jsp 源码文件，采用 JSP 编程语言编写，共 97 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与manfactioring相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?