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 + -
显示快捷键?