I set path for postgresql driver already. But dont know why this error occurs
Help me to solve the problem
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","*","*");
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());
}
}
}
Error: could not find or load main class DbCheck