<%@ page language="java" import="datadisp.*,java.sql.*"%>
<%@ page errorPage="error.jsp"%><%-- <jsp:useBean id="DataDispBean" scope="session" class="datadisp.DataDispBean"/>
<jsp:setProperty name="DataDispBean" property="*"/>
</jsp:useBean> --%>
<html>
<head>
<title>Data Disperse</title>
</head>
<body>
<center><h1>数据分发</h1></center>
<hr><br>
<form action="dataDisp.jsp" method="POST">
<table align="center" width="100%">
<tr><th>PMID</th><th>CODE</th><th>NAME</th></tr>
<% try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:dsBHP");
Statement state=con.createStatement();
ResultSet rs=state.executeQuery("SELECT DataDisp.Code,DataDisp.Name,DataDisp.PMID FROM DataDisp WHERE IsTake=0");
while(rs.next()){
%>
<tr>
<td><%=rs.getString("CODE")%></td>
<td><%=rs.getString("NAME")%></td>
<td><%=rs.getString("PMID")%></td>
<td><input type="radio" name="<%=rs.getString("PMID")%>" <td>
</tr>
<% }rs.close();
state.close();
con.close();
} catch(java.lang.ClassNotFoundException ce)
{System.out.println(ce.getMessage());}
catch(SQLException e)
{System.out.println(e.getMessage());} %>
</table>
<%-- <% DataDispBean.outputInforRes();%> --%>
<hr><br><input type="submit" value="disperse">
<input type="submit" value="refresh">
<input type="submit" value="delete">
</form>
</body>
</html>
<%@ page errorPage="error.jsp"%><%-- <jsp:useBean id="DataDispBean" scope="session" class="datadisp.DataDispBean"/>
<jsp:setProperty name="DataDispBean" property="*"/>
</jsp:useBean> --%>
<html>
<head>
<title>Data Disperse</title>
</head>
<body>
<center><h1>数据分发</h1></center>
<hr><br>
<form action="dataDisp.jsp" method="POST">
<table align="center" width="100%">
<tr><th>PMID</th><th>CODE</th><th>NAME</th></tr>
<% try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:dsBHP");
Statement state=con.createStatement();
ResultSet rs=state.executeQuery("SELECT DataDisp.Code,DataDisp.Name,DataDisp.PMID FROM DataDisp WHERE IsTake=0");
while(rs.next()){
%>
<tr>
<td><%=rs.getString("CODE")%></td>
<td><%=rs.getString("NAME")%></td>
<td><%=rs.getString("PMID")%></td>
<td><input type="radio" name="<%=rs.getString("PMID")%>" <td>
</tr>
<% }rs.close();
state.close();
con.close();
} catch(java.lang.ClassNotFoundException ce)
{System.out.println(ce.getMessage());}
catch(SQLException e)
{System.out.println(e.getMessage());} %>
</table>
<%-- <% DataDispBean.outputInforRes();%> --%>
<hr><br><input type="submit" value="disperse">
<input type="submit" value="refresh">
<input type="submit" value="delete">
</form>
</body>
</html>
out.println(ce.getMessage());
out.println (e.getMessage());