Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*
- * To change this license header, choose License Headers in Project Properties.
- * To change this template file, choose Tools | Templates
- * and open the template in the editor.
- */
- package paquets;
- import java.sql.*;
- import java.util.logging.Level;
- import java.util.logging.Logger;
- /**
- *
- * @author daw
- */
- public class Conector {
- private String urlBaseDades = "jdbc:mysql://localhost:3306/";
- private String usuari = "root";
- private String contrasenya = null;
- private String s = new String(); //Variable per a guardar els resultats
- private Connection c = null; //Per a crear la connexió amb la base de dades
- private Statement cerca=null; //Per a poder executar sentencies SQL
- private ResultSet r = null; //Per a poder guardar el resultat de les consultes SQL
- private PreparedStatement pstatement= null; //Per a poder realitzar UPDATES reiteraius
- public Conector(String bbdd) {
- try{
- Class.forName("com.mysql.jdbc.Driver");
- //Enviar una sentència SQL per recuperar els clients
- }catch(ClassNotFoundException e){
- e.printStackTrace();
- }
- try {
- c = DriverManager.getConnection(urlBaseDades+bbdd, usuari, contrasenya);
- } catch (SQLException ex) {
- Logger.getLogger(Conector.class.getName()).log(Level.SEVERE, null, ex);
- }
- }
- public String[][] sentecia(String query){
- int j;
- try {
- cerca = c.createStatement();
- r = cerca.executeQuery(query);
- r.last();
- String[][] tabla = new String[r.getRow()+1][r.getMetaData().getColumnCount()];
- r.first();
- for(int i=1 ; i<=r.getMetaData().getColumnCount() ; i++){
- tabla[0][i-1]=r.getMetaData().getColumnName(i);
- }
- do {
- for(int i=1 ; i<r.getMetaData().getColumnCount() ; i++){
- tabla[r.getRow()][i-1]=r.getString(i);
- }
- }while(r.next());
- return tabla;
- } catch (SQLException ex) {
- Logger.getLogger(Conector.class.getName()).log(Level.SEVERE, null, ex);
- return null;
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement