tarea08_visualII

Tarea 08

Clase Acceso
package tarea08;
import java.sql.*;
import javax.swing.*;
public class acceso {
static Connection conn=null;
static Statement st=null;
static ResultSet rs=null;static String bd="transportes";
static String login="root";
static String password="";
static String url="jdbc:mysql://localhost/"+bd;
public static Connection Enlace(Connection x)throws SQLException{
try
{ Class.forName("com.mysql.jdbc.Driver");
x=DriverManager.getConnection(url, login, password);
}

catch(ClassNotFoundException e)
{ JOptionPane.showMessageDialog(null,e.getMessage());} return x; }
public static Statement sta(Statement st)throws SQLException
{ conn=Enlace(conn);
st=conn.createStatement();
return st; }
public static ResultSet rsetCiudad(ResultSet rs)throwsSQLException
{ st=sta(st);
rs=st.executeQuery("select * from ciudad ");
return rs; }
public static ResultSet rsetruta(ResultSet rs)throws SQLException
{ st=sta(st);
rs=st.executeQuery("select * fromruta ");
return rs; }
public static ResultSet rsetservicio(ResultSet rs)throws SQLException
{ st=sta(st);
rs=st.executeQuery("select * from servicio ");
return rs;}
public static ResultSetEnlaceruta(ResultSet rs)throws SQLException
{ st=sta(st);
rs=st.executeQuery("select * from ruta ");
return rs; }
public static ResultSet EnlaceTarifa(ResultSet rs)throws SQLException
{ st=sta(st);rs=st.executeQuery("select * from tarifa ");
return rs; }
public static ResultSet obtenercodciudadO(ResultSet rs, String nombreco)throws SQLException
{ st=sta(st);
String cad;
cad="selectidciudad from ciudad where nombre='"+nombreco+"'";
rs=st.executeQuery(cad);
return rs; }
public static ResultSet obtenercodciudadD(ResultSet rs, String nombrecd)throws SQLException
{ st=sta(st);
Stringcad;
cad="select idciudad from ciudad where nombre='"+nombrecd+"'";
rs=st.executeQuery(cad);
return rs; }
public static ResultSet obtenercodruta(ResultSet rs, String nombreco)throws SQLException...