import java.sql.*; public class DBQuery { private String connectionURL = "jdbc:postgresql://localhost:5432/"; private Connection connection = null; private PreparedStatement statement = null; private ResultSet rs = null; private String query = "select * from users where login=?"; private String insert = "insert into users(login, firstname, lastname, password) values (?,?,?,?)"; public DBQuery() { // TODO Auto-generated constructor stub // get a DB connection try{ Class.forName("com.mysql.jdbc.Driver").newInstance(); connection = DriverManager.getConnection(connectionURL, "postgres", "12345"); } catch(Exception e){ e.printStackTrace(); } } @Override protected void finalize() { try{ connection.close(); } catch(SQLException e){ e.printStackTrace(); } } public boolean validate(String login, String password){ boolean result = false;

Eclipse project

1 answer below »

Eclipse project

20210801161329-ifxulzh4.jpg 20210801161312-tygq3jhi.jpg 20210801161230-w1snzrhw.jpg

Answered 9 days After Aug 01, 2021

Solution

Breeze Prakash answered on Aug 03 2021

153 Votes

import java.sql.*;
public class DBQuery {
private String connectionURL = "jdbc:postgresql:
localhost:5432/";
private Connection connection = null;
private PreparedStatement statement = null;
private ResultSet rs = null;
private String query = "select * from users where login=?";
private String insert = "insert into users(login, firstname, lastname, password) values (?,?,?,?)";
public DBQuery() {

TODO Auto-generated constructor stu

get a DB connection
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
connection = DriverManager.getConnection(connectionURL, "postgres", "12345");
}
catch(Exception e){
e.printStackTrace();
}
}
@Ove
ide
protected void finalize() {
try{
connection.close();
}
catch(SQLException e){
e.printStackTrace();
}
}
public boolean validate(String login, String password){
boolean result = false;
try{
...

SOLUTION.PDF

Eclipse project

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment