Package biblioteca.admin.utilidades

Examples of biblioteca.admin.utilidades.ConDb

45
46
47
48
49
50
51
52
53
54
55
56
57
58
        this.direccion = direccion;
    }
   
    public Vector getListEmails(){
        Vector<Vector<String>> emailVector = new Vector<Vector<String>>();
        ConDb con=new ConDb();
        Connection conn = null;
        try {
            conn = con.getSource().getConnection();//Obetener conexion existente del pool
                     
            Statement sentencia = conn.createStatement();
           
            String query="select * from email;";
            ResultSet rs=sentencia.executeQuery(query);
View Full Code Here
71
72
73
74
75
76
77
78
79
80
81
82
83
84
            }
        }
        return emailVector;
    }
    public void get(Long id){
       ConDb con=new ConDb();
        Connection conn = null;
        try {
            conn = con.getSource().getConnection();//Obetener conexion existente del pool
                     
            Statement sentencia = conn.createStatement();
           
            String query="select direccion from email where id="+id+";";
            ResultSet rs=sentencia.executeQuery(query);
View Full Code Here
94
95
96
97
98
99
100
101
102
103
104
105
106
107
                try { conn.close(); } catch (SQLException e) {}
            }
        }
    }
    public void save(){
        ConDb con=new ConDb();
        Connection conn = null;
        try {
            conn = con.getSource().getConnection();//Obetener conexion existente del pool
           
            String query="insert into email values(nextval('sq_email'),?);";
            PreparedStatement pst=conn.prepareStatement(query);
           
            pst.setString(1, this.direccion);
View Full Code Here
116
117
118
119
120
121
122
123
124
125
126
127
128
129
            }
        }
    }
   
    public void update(){
        ConDb con=new ConDb();
        Connection conn = null;
        try {
            conn = con.getSource().getConnection();//Obetener conexion existente del pool
           
            String query="update email set direccion=? where id=?";
            PreparedStatement pst=conn.prepareStatement(query);
           
            pst.setString(1, this.direccion);
View Full Code Here
139
140
141
142
143
144
145
146
147
148
149
150
151
152
            }
        }
    }
   
    public void delete(){
        ConDb con=new ConDb();
        Connection conn = null;
        try {
            conn = con.getSource().getConnection();//Obetener conexion existente del pool
           
            String query="delete from email where id=?";
            PreparedStatement pst=conn.prepareStatement(query);           
          
            pst.setLong(1, this.id);
View Full Code Here
21
22
23
24
25
26
27
28
29
30
31
32
33
34
    /**
     * @param args the command line arguments
     */
    public static void main(String[] args) {
        // TODO code application logic here
        ConDb con=new ConDb();
        Connection conn = null;
        try {
            conn = con.getSource().getConnection();
           
            /*String ins="insert into alumno values(?,?,?,?,?);";
            PreparedStatement pst=conn.prepareStatement(ins);
            pst.setInt(1, 6);
            pst.setString(2, "MARTHA ALICIA");
View Full Code Here
TOP

Related Classes of biblioteca.admin.utilidades.ConDb

  • biblioteca.admin.catalogos.Email
  • ejemplocdbpostgres.EjemploCDBPostGres
  • org.postgresql.ds.PGPoolingDataSource
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.