Properties file for DB connection

[Mahesh Lohi]

Hi all, I would like to use properties file to create connection to my mysql DB

My properties file

   driver=com.mysql.jdbc.Driver
connectionurl = jdbc:mysql://localhost:3306/itruth?" + "user=root&password=123456 

My Class file

   public class Connect {
    static public void main(String argv[]) throws FileNotFoundException, IOException, ClassNotFoundException, SQLException {
    String url;
    String driv;
    Properties    props = new Properties();
    props.load(new FileInputStream("Hello.properties"));
    Class.forName("com.mysql.jdbc.Driver");
    url = props.getProperty("connectionurl");
    System.out.print(url);
    ResultSet rs = null;
    String connectionur=url;
    Connection con =DriverManager.getConnection(url);
    PreparedStatement stm=con.prepareStatement("select * from filename");
   rs=stm.executeQuery();
   while(rs.next())
   {
   System.out.println(rs.getString(1));
   }
            // System.out.println(message);
    
    }
}  

Please let me know what the mistake is. I am getting an error like java.sql.SQLException: Access denied for user ''@'localhost' (using password: YES)

Thank you in advance

[Karthik Jayachandran]

''@'localhost' (using password: YES)

You can see it is not getting the username and password

Have the url only separately.

And then add two more properties as,

  
username=root
password=123456  

It might work.

[David Newton]

This has nothing to do with Struts; moving.