Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package pkgConexion;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.util.Date;
- public class clsNatural {
- private String id;
- private String nombre;
- private String edad;
- private String sexo;
- private pkgConexion.clsConn conn = new pkgConexion.clsConn();
- public String getId() {
- return id;
- }
- public void setId(String id) {
- this.id = id;
- }
- public String getNombre() {
- return nombre;
- }
- public void setNombre(String nombre) {
- this.nombre = nombre;
- }
- public Date getedad() {
- return edad;
- }
- public void setedad(String edad) {
- this.edad = edad;
- }
- public String getsexo() {
- return sexo;
- }
- public void setsexo(String sexo) {
- this.sexo = sexo;
- }
- public pkgConexion.clsConn getConn() {
- return conn;
- }
- public void setConn(pkgConexion.clsConn conn) {
- this.conn = conn;
- }
- public String Insertar(){
- String sql="INSERT INTO pnatural VALUES('"+this.id+"','"+this.nombre+"','"+this.edad+"','"+this.sexo+"')";
- if(Verificar(this.id)==true)
- return "0";
- else{
- if(getConn().insertar(sql)==null)
- return "1";
- }
- return "-1";
- }
- public boolean Verificar(String key){
- String sql="SELECT * From pnatural where cedula='"+key.toString()+"'";
- if(getConn().verificar(sql)==1)
- return true;
- return false;
- }
- public String consultar() throws SQLException{
- String sql="SELECT * from pnatural";
- ResultSet rs=getConn().consultar(sql);
- String sb="";
- int x=1;
- sb+="<center><table border=1><tr><td>Cedula</td><td>Nombre</td><td>Edad</td><td>Sexo</td></tr>";
- while(rs.next()){
- sb+="<tr><td><input type='text' value="+rs.getString(1)+" disabled='true' name='textbox"+x+"'></td><td>"+rs.getString(2)+"</td><td>"+rs.getString(3)+"</td><td>"+rs.getString(4)+"</td></tr>";
- x++;
- }
- sb+="</table></center>";
- return sb;
- }
- public String modificar(String key) {
- if (Verificar(key) == true) {
- String sql = "UPDATE pnatural set nombre='" + nombre + "' ,pedad='"+edad+"' where cedula='" + key.toString() + "'";
- if (conn.actualizar(sql) == 1) {
- return "Modificado con éxito, verifique";
- }
- }
- return "Problemas para modificar";
- }
- public boolean eliminar(String key) {
- if (Verificar(key) == true) {
- String sql = "DELETE from pnatural where cedula='" + key.toString() + "'";
- if (conn.actualizar(sql) == 1) {
- return true;
- }
- }
- return false;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement