Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.io.IOException;
- import java.io.PrintWriter;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.Statement;
- import java.util.Scanner;
- public class DbCheck {
- public static void main(String[] args) {
- Scanner scan = new Scanner(System.in);
- try {
- Class.forName("org.postgresql.Driver");
- Connection con=DriverManager.getConnection("jdbc:postgresql://localhost:5432/postgres","postgres","selva");
- Statement st=con.createStatement();
- System.out.println("Name: ");
- String name = scan.nextLine();
- String sql= "select * from memberdata where name='" + name +"'";
- ResultSet rs = st.executeQuery(sql);
- if(rs.next()) {
- System.out.println("Success");
- }
- else {
- System.out.println("Failure");
- }
- scan.close();
- con.close();
- }catch(Exception e){
- System.out.println("Error: "+e.getMessage());
- }
- }
- }
Add Comment
Please, Sign In to add comment