Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public static final String DB_DRIVER = "com.mysql.jdbc.Driver";
- public static final String DB_CONNECTION = "jdbc:mysql://localhost:3306/myDatabase";
- public static final String DB_USER = "root";
- public static final String DB_PASSWORD = "password";
- try {
- Class.forName(Database.DB_DRIVER);
- } catch (ClassNotFoundException e) {
- System.out.println(e);
- }
- Connection connection = null;
- try {
- connection = DriverManager.getConnection(Database.DB_CONNECTION,
- Database.DB_USER,
- Database.DB_PASSWORD);
- } catch (SQLException e) {
- System.out.println(e);
- }
- try {
- PreparedStatement preparedStatement = connection.prepareStatement("SELECT * FROM USERS WHERE USER_NAME = ?");
- preparedStatement.setString(1, "Alex");
- ResultSet rs = preparedStatement.executeQuery();
- while (rs.next()) {
- String result = rs.getString("USER_NAME")
- System.out.println(result);
- }
- } catch (SQLException ex) {
- System.out.println(ex);
- }
Add Comment
Please, Sign In to add comment