departments.jsp
来自「This project mainly deals with automatin」· JSP 代码 · 共 53 行
JSP
53 行
<%@ 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="./Dept_Process.jsp " name="form128" 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 dept_det ");
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">DEPARTMENTS</font></strong></font></p>
<table width="75%" 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">Dept No :</font></strong></div></td>
<td><input type="text" name="deptno"></td>
</tr>
<tr>
<td><div align="right"><strong><font color="#FFFFFF">Dept Name :</font></strong></div></td>
<td><input type="text" name="deptname"></td>
</tr>
<tr>
<td><div align="right"><strong><font color="#FFFFFF">Location :</font></strong></div></td>
<td><input type="text" name="location"></td>
</tr>
<tr>
<td><div align="right"><strong><font color="#FFFFFF">Dept Head :</font></strong></div></td>
<td><input type="text" name="depthead"></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 + -
显示快捷键?