Guest User

Untitled

a guest
Jan 7th, 2019
167
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.18 KB | None | 0 0
  1. import java.io.IOException;
  2. import java.io.PrintWriter;
  3. import java.sql.Connection;
  4. import java.sql.DriverManager;
  5. import java.sql.ResultSet;
  6. import java.sql.Statement;
  7. import java.util.Scanner;
  8.  
  9. public class DbCheck {
  10. public static void main(String[] args) {
  11. Scanner scan = new Scanner(System.in);
  12. try {
  13. Class.forName("org.postgresql.Driver");
  14. Connection con=DriverManager.getConnection("jdbc:postgresql://localhost:5432/postgres","postgres","selva");
  15. Statement st=con.createStatement();
  16. System.out.println("Name: ");
  17. String name = scan.nextLine();
  18. String sql= "select * from memberdata where name='" + name +"'";
  19. ResultSet rs = st.executeQuery(sql);
  20. if(rs.next()) {
  21. System.out.println("Success");
  22. }
  23. else {
  24. System.out.println("Failure");
  25. }
  26. scan.close();
  27. con.close();
  28. }catch(Exception e){
  29. System.out.println("Error: "+e.getMessage());
  30. }
  31. }
  32. }
Add Comment
Please, Sign In to add comment