Programaion en java

Printing D:\Mis Documentos\NetBeansProjects\Hypermedial_Notas\src\java\edu\ups\nota\controlador\AlumnoDao.java at 07/12/11 02:09 AM

/* * To change this template, choose Tools | Templates * andopen the template in the editor. */ package edu.ups.nota.controlador; import import import import import import import import Conexion.Conexion; edu.ups.nota.entidad.Alumno; javax.faces.bean.ManagedBean;javax.faces.bean.RequestScoped; java.sql.*; java.util.ArrayList; java.util.List; javax.faces.context.FacesContext;

/** * * @author N_Xavier */ @ManagedBean(name="AlumnoDao") @RequestScoped publicclass AlumnoDao { private List lista; private Alumno alumno = new Alumno(); /** Creates a new instance of AlumnoDao */ public AlumnoDao() { } public Alumno getAlumno() { return alumno; } public voidsetAlumno(Alumno alumno) { this.alumno = alumno; } public String ingresaAlumno(){ String msm="ok"; try { Page 1

Printing D:\MisDocumentos\NetBeansProjects\Hypermedial_Notas\src\java\edu\ups\nota\controlador\AlumnoDao.java at 07/12/11 02:09 AM

CallableStatement cs = Conexion. conectMysql().prepareCall("call ingresarAlumno (?,?,?,?,?,?,?,?,?)"); FacesContext context=FacesContext.getCurrentInstance(); Alumno alumno = context.getApplication(). evaluateExpressionGet(context,"#{Alumno}", Alumno.class); cs.setString(1, alumno.getCedula()); cs.setString(2,alumno.getNombres()); cs.setString(3,alumno.getApellidos()); cs.setInt(4, alumno.getCiudad()); cs.setInt(5,alumno.getEstado_civil()); cs.setDate(6, new Date(alumno. getFecha_nacimiento().getTime()));cs.setString(7,alumno.getDireccion()); cs.setString(8,alumno.getTelefono()); cs.setString(9,alumno.getEmail()); cs.executeUpdate(); cs.close(); } catch (Exception e) { System.out.println(e); msm="error"; } return msm; } public ListgetAlumnos(){ lista = new ArrayList(); FacesContext context = FacesContext. getCurrentInstance(); try { CallableStatement cs = Conexion. conectMysql().prepareCall("call consultarAlumnos"); ResultSet rs =...