Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.sql.*;
- public class BaseDAT {
- public static void main(String[] args) throws ClassNotFoundException, SQLException {
- Class.forName("com.mysql.jdbc.Driver");
- Connection conn = null;
- conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mdbtest?useSSL=false","root", "root");
- Statement statement = conn.createStatement();
- //statement.executeUpdate("drop table bans");
- ResultSet resultSet = statement.executeQuery("select * from users");
- while (resultSet.next()){
- System.out.println(resultSet.getInt(1));
- System.out.println(resultSet.getString(2));
- System.out.println(resultSet.getInt(3));
- System.out.println(resultSet.getString(4));
- System.out.println("-----------------");
- }
- resultSet.close();
- conn.close();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement