📄 bespoke.jsp~4~

📁 JBuilder 2006 +SQL Server2000 +JavaBean+JSP开发的宠物医院管理系统

💻 JSP~4~

字号:

<%@page contentType="text/html; charset=GB2312" import="java.sql.*,com.pet.util.*;"%>
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<html>
<head>
<title>预约兽医</title>
</head>
<jsp:useBean id="userBean" scope="session" class="com.pet.user.model.DTO.UserBean"/>
<body bgcolor="#ffffff">
<h3 align="center">预约兽医</h3>
<form method="post" action="bespoke.jsp">
<table width="100%" border="0">
  <tr>
    <td width="40%">&nbsp;</td>
    <td width="20%">      宠物名字
      &nbsp;&nbsp;
      <label>
        <select name="petName">
        <%
          DBCon db = new DBCon();
          ResultSet rs = null;
          try {
            rs = db.querySQL("select PID,Pname from pets where PUID=" + userBean.getUID());
            while (rs.next()) {
        %>
          <option value="<%=rs.getInt(1)%>"><%=rs.getString(2)%>          </option>
        <%
          }
              db.closeConn();
          } catch (Exception ex) {
            ex.printStackTrace();
          }
        %>
          %>
        </select>
        <br>

      </label>
    </td>
    <td width="40%">&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>      宠物症状
      <label>
        <textarea name="petDetail" rows="6">        </textarea>
      </label>
    </td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>      预约医生
      &nbsp;&nbsp;
      <label>
        <select name="vetName">
        <%
          try {
            rs = db.querySQL("select * from vets");
            while (rs.next()) {
        %>
          <option value="<%=rs.getString("vid")%>"><%=rs.getString("vname") %>          </option>
        <%
          }
          } catch (ClassNotFoundException ex) {
          }
          catch (SQLException ex) {
          }
        %>
        </select>
      </label>
    </td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;    </td>
    <td>      预约时间
      <INPUT size="11" name="beginDate">
      <IMG src="picture/date_selector.gif" align=absMiddle border=0 onClick="fPopUpCalendarDlg(beginDate,'');return false">
    </td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>
      <div align="center">
        <input type="submit" value="生成预约"/>
      </div>
    </td>
    <td>&nbsp;</td>
  </tr>
</table>
</form>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -