<%@ include file="ezinegif.html" %>

<%@ include file="finale_rrc_ezine_tab.html" %> 検索 ****** %> <%// 検索語句 検索範囲 全バックナンバー 特定バックナンバー: <% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String url = "jdbc:odbc:rrc_dsn"; Connection myConn = DriverManager.getConnection(url,"administrator",""); Statement stmt = myConn.createStatement(); ResultSet myResultSet = stmt.executeQuery("select * from issue order by issue_no"); if (myResultSet != null){ while(myResultSet.next()){ int issueno=myResultSet.getInt("issue_no"); String issue_name_htm =myResultSet.getString("issue_name_mast"); //String location_htm=myResultSet.getString("issue_loc"); String issue_name = myResultSet.getString("issue_name_text"); //String location = myResultSet.getString("issue_loc_text"); //int i = location.lastIndexOf("/"); //String title = location.substring(i+1); //int x = issue_name.lastIndexOf("."); //String issuename = issue_name-issue_name.substring(x); String con_issue_name= issue_name.substring(0,issue_name.indexOf('.')); %><%=con_issue_name%> <% } } %> <%// %> 範囲選択:   <% ResultSet myResultSet1 = stmt.executeQuery("select * from issue order by issue_no"); if (myResultSet1 != null){ while(myResultSet1.next()){ int issueno1=myResultSet1.getInt("issue_no"); String issue1_name_htm =myResultSet1.getString("issue_name_mast"); //String location_htm1=myResultSet1.getString("issue_loc"); String issue1_name = myResultSet1.getString("issue_name_text"); //String location1 = myResultSet1.getString("issue_loc_text"); //int i1 = location1.lastIndexOf("/"); //String title1 = location1.substring(i1+1); //int x = issue_name.lastIndexOf("."); //String issuename = issue_name-issue_name.substring(x); String con_issue1_name= issue1_name.substring(0,issue1_name.indexOf('.')); %><%=con_issue1_name%> <%} } %> から    <% ResultSet myResultSet2 = stmt.executeQuery("select * from issue order by issue_no"); if (myResultSet2 != null){ while(myResultSet2.next()){ int issueno2=myResultSet2.getInt("issue_no"); String issue2_name_htm =myResultSet2.getString("issue_name_mast"); //String location_htm2=myResultSet2.getString("issue_loc"); String issue2_name = myResultSet2.getString("issue_name_text"); //String location2 = myResultSet2.getString("issue_loc_text"); //int i2 = location2.lastIndexOf("/"); //String title2 = location2.substring(i2+1); //int x = issue_name.lastIndexOf("."); //String issuename = issue_name-issue_name.substring(x); String con_issue2_name= issue2_name.substring(0,issue2_name.indexOf('.')); %><%=con_issue2_name%> <%} } stmt.close(); myConn.close(); %>まで

Back to Main upFront Page