public static void main(String[] args) {
Connection con = null;
DAOFactory daoFactory = new DAOFactory();
con = daoFactory.getConexion();
if (con != null) System.out.println("Conexion exitosa");
else System.out.println("Conexion fallida");
con = daoFactory.closeConexion(con);
if (con == null) {
System.out.println("Conexion cerrada");
} else System.out.println("Conexion sin cerrar");
}
@Override
public ArrayList select() {
int a = 1;
Scanner scantool = new Scanner(System.in);
System.out.println("Matrícula de alumno: ");
try {
a = Integer.parseInt(scantool.nextLine());
} catch (NumberFormatException error) {
System.out.println("\n Error: " + error.getMessage());
a = 0;
}
ArrayList mi_lista = new ArrayList();
Alumno alumnoCall = new Alumno();
Connection conexion = DAOFactory.getConexion();
try {
Statement llamada = (Statement) conexion.createStatement();
ResultSet query = llamada.executeQuery(SQL.findAlumno);
int b;
while (query.next()) {
b = query.getInt("Matricula");
if (a == b) {
System.err.println(
"Nombre: "
+ query.getString("Nombre")
+ " "
+ query.getString("Ape_pat")
+ " "
+ query.getString("Ape_mat"));
}
mi_lista.add(
new Alumno(
query.getInt("Matricula"),
query.getString("Nombre"),
query.getString("Ape_pat"),
query.getString("Ape_mat"),
query.getString("Telefono"),
query.getString("Fecha_nac"),
query.getString("Direccion"),
query.getString("Clave")));
}
} catch (SQLException ex) {
System.out.println(ex);
}
return mi_lista;
}
@Override
public int insert(Bean bean) {
Alumno alumno = (Alumno) bean;
Connection conexion = DAOFactory.getConexion();
PreparedStatement ps2 = null;
try {
ps2 = (PreparedStatement) conexion.prepareCall(SQL.insertarAlumno);
ps2.setInt(1, alumno.getMatricula());
ps2.setString(2, alumno.getNombre());
ps2.setString(3, alumno.getApe_pat());
ps2.setString(4, alumno.getApe_mat());
ps2.setString(5, alumno.getTelefono());
ps2.setString(6, alumno.getFecha_nac());
ps2.setString(7, alumno.getDir());
ps2.setString(8, alumno.getClave());
ps2.executeUpdate();
} catch (SQLException ex) {
Logger.getLogger(AlumnoDAO.class.getName()).log(Level.SEVERE, null, ex);
}
return 1;
}