add.jsp

来自「MySql(JSP版)数据库管理系统」· JSP 代码 · 共 68 行

JSP
68
字号
<%@ page contentType="text/html; charset=gb2312"%>
<%@ page language="java" import="java.sql.*"%>
<jsp:useBean id="DBconn" scope="page" class="Show.DBconn"/>

<html>
  <head>
  <title>Show MySQL!</title>
 </head>
 <body>



<%
	//定义新变量id,并初始化为0
	int id;
	id=0;
	ResultSet RS = DBconn.executeQuery("select id from data order by id");
	try
	{
		while(RS.next())
		{	
			//id被赋值为现有菜单的最大id
			id=RS.getInt("id");
			out.println(RS.getString("id"));
		}
	}
	catch(Exception e)
	{
		out.println(e);
	}


%>
<form name="form1" method="post" action="add_ok.jsp">
  <table width="75%" border="1">
    <tr> 
      
    </tr>
    <tr> 
      <td width="41%">名字:</td>
      <td width="59%"> 
        
        <input type="text" name="name">
      </td>
    </tr>
<tr> 
      <td width="41%">em:</td>
      <td width="59%"> 
        
        <input type="text" name="pid">
      </td>
    </tr>
    <tr> 
      
      
       </td>
    </tr>
    <tr> 
      <td colspan="2">
       <div align="center">
          <input type="submit" name="Submit" value="Submit">
          <input type="reset" name="Submit2" value="Reset">
        </div>
    </tr> 
  </table>
</form>
</BODY>
</HTML>

⌨️ 快捷键说明

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