issues.jsp

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

JSP
100 行
字号 
<%@ 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="./issues_process.jsp" name="form27" 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 raw_issues where sno<100");
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 itemno  from raw_recieved group by(itemno) ");
 %>


<% 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 deptname from dept_det ");
 %>

<div align="center"> 
  <p><strong><font color="#FFFFFF" size="5">INVENTORY CONTROL SYSTEM</font></strong></p>
  <p><font color="#FFFFFF"><strong><font size="4"> RAW ISSUES</font></strong> </font></p>
  <table width="63%" border="0">
    <tr> 
      <td width="35%"><strong><font color="#FFFFFF">S.No :</font></strong></td>
      <td width="65%"><strong><font color="#FFFFFF"> 
        <input type="text" name="sno" value=<%=a%> readonly>
        </font></strong></td>
    </tr>
    <tr> 
      <td><strong><font color="#FFFFFF">Item No :</font></strong></td>
      <td><strong><font color="#FFFFFF"> 
 <select name="itemno" id="itemno">

<%while(rs2.next())
{
 %>
<option value=<%=rs2.getInt(1)%>><%=rs2.getInt(1)%></option>
<%
}
%>
</select></font></strong></td>
    </tr>
    <tr> 
      <td><strong><font color="#FFFFFF">Qty Issued :</font></strong></td>
      <td><strong><font color="#FFFFFF"> 
        <input type="text" name="qtyissued">
        </font></strong></td>
    </tr>
    <tr> 
      <td><strong><font color="#FFFFFF">Challan No :</font></strong></td>
      <td><strong><font color="#FFFFFF"> 
        <input type="text" name="challanno">
        </font></strong></td>
    </tr>
    <tr> 
      <td><strong><font color="#FFFFFF">Department Name :</font></strong></td>
      <td><strong><font color="#FFFFFF"> 
        <select name="deptname"  id="deptname" >

<%while(rs3.next())
{
 %>
<option value=<%=rs3.getString(1)%>><%=rs3.getString(1)%></option>
<%
}
%>
</select></font></strong></td>
    </tr>
    <tr> 
      <td><strong><font color="#FFFFFF">Issued Date :</font></strong></td>
      <td><strong><font color="#FFFFFF"> 
        <input type="text" name="issuedate">
        </font></strong></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>&nbsp;</p>
</div>
</form>
</body>
</html>

issues.jsp - 源码说明

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

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

⌨️ 快捷键说明

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