Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public class Conexion {
- private static String servidor="jdbc:mysql://localhost:3306/skywater?zeroDateTimeBehavior=convertToNull";
- private static String user="root";
- private static String pass="pass";
- private static String driver="com.mysql.jdbc.Driver";
- private static Connection conexion;
- public Conexion() {
- try {
- Class.forName(driver);
- conexion= DriverManager.getConnection(servidor,user,pass);
- }catch(ClassNotFoundException | SQLException e) {
- JOptionPane.showMessageDialog(null,"Error al establecer conexion con base de datos n Contacte Servicio: "+e.getMessage());
- }
- }
- public Connection getConnection() {
- return conexion;
- }
- public Connection getClosedConnection() throws SQLException {
- conexion.close();
- System.out.println("Conexion cerrada");
- return conexion;
- }
- public class OperacionesDB {
- Conexion conector = new Conexion();
- Connection con=conector.getConnection();
- Statement st;
- public DefaultTableModel consultaGeneral(String tabla,String columna, String valor) {
- System.out.println(tabla);
- DefaultTableModel modelo=new DefaultTableModel();
- String seleccion="SELECT * FROM "+ tabla+" WHERE "+columna+" LIKE '%"+valor+"%';";
- try {
- Statement ejecutor = con.createStatement();
- ResultSet rs=ejecutor.executeQuery(seleccion);
- String nvo[]= new String[rs.getMetaData().getColumnCount()];
- for(int j=1;j<=rs.getMetaData().getColumnCount();j++){
- modelo.addColumn(rs.getMetaData().getColumnName(j));
- }
- while(rs.next())
- {
- for(int i=1;i<=modelo.getColumnCount();i++)
- nvo[i-1]=rs.getString(i);
- modelo.addRow(nvo);
- }
- ejecutor.close();
- //con.close();
- rs.close();
- return modelo;
- }
- catch(SQLException e) {
- System.out.println("Error en consulta general "+e.getMessage());
- return modelo;
- }
- public DefaultTableModel consultaFechas(String tabla,String columna, String valor, String valor2, String columna2, String valor3) {
- DefaultTableModel modelo=new DefaultTableModel();
- String seleccion="SELECT * FROM "+ tabla+" WHERE "+columna2+"='"+valor3+"' AND "+columna+">='"+valor+"' AND "+columna+ "<='"+valor2+"';";
- try {
- Statement ejecutor = con.createStatement();
- ResultSet rs=ejecutor.executeQuery(seleccion);
- String nvo[]= new String[rs.getMetaData().getColumnCount()];
- for(int j=1;j<=rs.getMetaData().getColumnCount();j++){
- modelo.addColumn(rs.getMetaData().getColumnName(j));
- }
- while(rs.next())
- {
- for(int i=1;i<=modelo.getColumnCount();i++)
- nvo[i-1]=rs.getString(i);
- modelo.addRow(nvo);
- }
- ejecutor.close();
- con.close() //<- Cerrar la conexión
- return modelo;
- }
- catch(SQLException e) {
- return modelo;
- }
- }
Add Comment
Please, Sign In to add comment