dealermaster.jsp

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

JSP
63
字号
<%@ 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="./Dealer_Process.jsp" name="form129" 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 dealer ");
while(rs.next())
{
 a=rs.getInt(1);  } %><% a=a+1; %>

<div align="center">
  <p><strong><font color="#FFFFFF" size="5">INVENTORY CONTROL SYSTEM </font></strong></p>
  <p><font color="#FFFFFF"><strong><font size="4">DEALER MASTER</font></strong></font></p>
  <table width="56%" border="0">
    <tr> 
      <td><div align="right"><strong><font color="#FFFFFF">S.No :</font></strong></div></td>
      <td><input type="text" name="sno" value=<%=a%> readonly></td>
    </tr>
    <tr> 
      <td><div align="right"><strong><font color="#FFFFFF">Dealer No :</font></strong></div></td>
      <td><input type="text" name="dealerno"></td>
    </tr>
    <tr> 
      <td><div align="right"><strong><font color="#FFFFFF">Dealer Name :</font></strong></div></td>
      <td><input type="text" name="dealername"></td>
    </tr>
    <tr> 
      <td><div align="right"><strong><font color="#FFFFFF">Address :</font></strong></div></td>
      <td><textarea name="address" rows=4 cols=15></textarea>
</td>
    </tr>
    <tr> 
      <td height="22"><div align="right"><strong><font color="#FFFFFF">Telephone 
          No :</font></strong></div></td>
      <td><input type="text" name="phone"></td>
    </tr>
    <tr> 
      <td><div align="right"><strong><font color="#FFFFFF">Category :</font></strong></div></td>
      <td><select name="category"><option selected>RETAIL</option><option>WholeSale</option><option>small</option><option>Mediaum</option><option>Bulk</option></select></td>
    </tr>
    <tr> 
      <td><div align="right"><strong><font color="#FFFFFF">Credit Limit:</font></strong></div></td>
      <td><input type="text" name="creditlimit"></td>
    </tr>
  </table>
  <p> 
    <input type="submit" name="Submit" value="Submit">
    <input name="Reset" type="reset" id="Reset" value="Reset">
    <a href="Home.jsp">HOME </a></p>
  <p><strong><font size="4"></font></strong> </p>
</div>
</form>
</body>
</html>

⌨️ 快捷键说明

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