RE:Conexion a base de datos My SQL
import java.util.*;
import java.sql.*;
public class DBmysql {
String dbUrl = "jdbc:mysql://direccionIP/nombreBaseDatos";
String user = "user";
String password = "password";
DBmysql() throws ClassNotFoundException {
Class.forName("com.mysql.jdbc.Driver");
}
public void doQuery() throws SQLException {
Connection c = DriverManager.getConnection(dbUrl, user, password);
java.sql.Statement s = c.createStatement();
// SQL code:
ResultSet r = s.executeQuery("SELECT * FROM tabla
System.out.println(r.getFetchSize());
ResultSetMetaData rMetaData = r.getMetaData();
r.last();
r.first();
System.out.println(r.getRow());
for(int i =1; i<= rMetaData.getColumnCount(); i++) {
System.out.print(rMetaData.getColumnName(i));
}
while(r.next()) {
for(int i =1; i<= rMetaData.getColumnCount(); i++) {
System.out.print(r.getString(i));
}
System.out.println("|");
}
s.close();
c.close();
}
public static void main(String[] args) throws ClassNotFoundException, SQLException {
DBmysql db = new DBmysql();
db.doQuery();
}
}