DB and table names are correct. linked the classpath of MySQL connecter java. but when i run i get Not Found Result. i have tried different queries and different links to sql connector.
final static String jdbc_driver="com.mysql.jdbc.Driver";
final static String db_url="jdbc:mysql://localhost/oyutan/";
Connection con=null;
java.sql.PreparedStatement ps=null;
ResultSet rs=null;
@Override
public void actionPerformed(ActionEvent r) {
if(r.getSource()==ok){
fr.setVisible(false);
GUI guu=new GUI();
String card=cardnum.getText();
String pinn=pin.getText();
String sql="SELECT *FROM `card`";
try{
Class.forName(jdbc_driver);
con=DriverManager.getConnection(db_url, "root", "");
ps=con.prepareStatement(sql);
rs=ps.executeQuery();
while(rs.next());{
System.out.println(rs.getString("")+"");
}}
catch(Exception e){
System.out.println("Not Found!");
}
}
}
There is no space between * And FROM , try using this :
String sql = "SELECT * FROM 'card' ";