CONEXION A UNA BASE DE DATOS EN MYSQL
La base de datos se llama elio
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
public class ejemplo1 {
public static void main(String[] args) {
Connection cn;
ResultSet rs;
try{
Class.forName("com.mysql.jdbc.Driver");
cn=DriverManager.getConnection("jdbc:mysql://localhost/elio","root","mysql");
rs=cn.createStatement().executeQuery("select * from alumno");
while(rs.next()){
System.out.println(rs.getString("alu_par"));
}
}
catch(ClassNotFoundException cnfe){
System.out.println("no hay clase");
}
catch(SQLException sqle){
System.out.println("error de coneccion");
}
}
}
