<% response.setHeader("Cache-Control","no-cache"); response.setHeader("Pragma","no-cache"); response.setDateHeader ("Expires", -1); HttpSession mySession = ( (HttpServletRequest)request ).getSession(true); javax.servlet.ServletContext myServletContext = mySession.getServletContext(); String driver_classname = "org.gjt.mm.mysql.Driver"; String server_url = "jdbc:mysql://localhost:3306/upload_csv"; String login_id = "root"; String login_pw = "admin"; java.lang.Class.forName( driver_classname ); java.sql.Connection con = java.sql.DriverManager.getConnection( server_url, login_id, login_pw ); java.sql.PreparedStatement stmt = null; java.sql.ResultSet rs = null; con.setAutoCommit(false); // String backend_sql_string ="call two_city_regis_chart_sql"; String backend_sql_string ="call two_city_regis_chart_not_ordered_sql"; System.out.println(backend_sql_string); java.util.ArrayList year_mth = new java.util.ArrayList(); java.util.ArrayList toronto_cnt = new java.util.ArrayList(); java.util.ArrayList hamilton_cnt = new java.util.ArrayList(); java.util.ArrayList average = new java.util.ArrayList(); stmt = con.prepareStatement( backend_sql_string ); rs = stmt.executeQuery(); while ( rs.next() ) { String year_mth_str = rs.getString( "year_mth" ); String toronto_cnt_str = rs.getString( "ton_cnt" ); String hamilton_cnt_str = rs.getString( "ham_cnt" ); String average_str = rs.getString( "avg_cnt" ); year_mth.add( year_mth_str ); toronto_cnt.add( toronto_cnt_str ); hamilton_cnt.add( hamilton_cnt_str ); average.add( average_str ); } if ( stmt != null ) stmt.close(); if ( rs != null ) rs.close(); if ( con != null ) { con.close(); } %>