%@ page import="java.sql.*, java.io.*, java.util.*" %>
<%@ page session="true" %>
www.perronebus.it - Fagnano Castello (CS)
<%
Connection con=null;
Statement st;
PreparedStatement pst;
String sql1;
String sql;
String codice="";
String partenza="";
String partenza1="";
String arrivo="";
try{
con = (Connection)session.getAttribute("con");
if(con == null)
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url= "jdbc:odbc:perronebus";
con= DriverManager.getConnection(url);
session.setAttribute("con", con);
}
}
catch (Exception e)
{
StringWriter sw=new StringWriter();
PrintWriter out1=new PrintWriter(sw);
e.printStackTrace(out1);
out.print(sw.toString());
}
try
{
sql1="SELECT IdFermata, Fermata, Nomefile FROM partenze ORDER BY Fermata";
st=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet ris=st.executeQuery(sql1);
%>