Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- MysqlDataSource dataSource = new MysqlDataSource();
- // usuario y pass
- dataSource.setUser("usuario");
- dataSource.setPassword("password");
- // servidor y puerto (he puesto el 3306 que es el std, pero cambialo sino!)
- dataSource.setServerName("localhost");
- dataSource.setPort(3306);
- // base de datos creada
- dataSource.setDatabaseName("nombreBBDD");
- Connection conn = dataSource.getConnection();
- String URL = "jdbc:mysql:3306//localhost/nombreBBDD";
- String USER = "username";
- String PASS = "password"
- Connection conn = DriverManager.getConnection(URL, USER, PASS);
- Statement stmt = conn.createStatement();
- ResultSet rs = stmt.executeQuery("SELECT * FROM TU_TABLA");
- // haz cosas con el resultado!
- rs.close();
- stmt.close();
- conn.close();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement