<%
while (columns.next()) {
String word = columns.getString("bs_word"); %>
<%= word %>
<% } %>
<%
con.close();
%>
<%
String tableStr2 = "SELECT * FROM total_bs WHERE bs_type='a' ORDER BY RAND() LIMIT 1";
Class.forName(driver).newInstance();
Connection con2 = java.sql.DriverManager.getConnection( url, name, pass );
Statement statement2 = con2.createStatement();
ResultSet columns2 = statement2.executeQuery(tableStr2);
%>
<%
while (columns2.next()) {
String word2 = columns2.getString("bs_word"); %>
<%= word2 %>
<% } %>
<%
con2.close();
%>
<%
String tableStr3 = "SELECT * FROM total_bs WHERE bs_type='n' ORDER BY RAND() LIMIT 1";
Class.forName(driver).newInstance();
Connection con3 = java.sql.DriverManager.getConnection( url, name, pass );
Statement statement3 = con3.createStatement();
ResultSet columns3 = statement3.executeQuery(tableStr3);
%>
<%
while (columns3.next()) {
String word3 = columns3.getString("bs_word"); %>
<%= word3 %>
<% } %>
|