java - set the classpath in order to connect between mysql to jdbc

Question

I use the programs: eclipse and mysql.

I have a database in mysql and I want to connect between the eclipse to the mysql.

I have some folders in my project that I created in the eclipse.

I have the main folder: testest.. and I show you what I have in the relevant folders:

testest
..src
....testest
......testestservlet.java
..app engine sdk
..JRE system library
..referenced library
..war
..lib
....mysql-connector-java-5.1.22

I updated my testestservlet.java:

package testest;

import java.io.IOException;
import javax.servlet.http.*;
import java.sql.*;

@SuppressWarnings("serial")
public class TestestServlet extends HttpServlet {
  public void doGet(HttpServletRequest req, HttpServletResponse resp)
        throws IOException {
      resp.setContentType("text/plain");
      resp.getWriter().println("Hey, world");
      resp.getWriter().println("MySQL Connect Example.");
      Connection conn = null;
      String url = "jdbc:mysql://localhost:3306/";
      String dbName = "database_alon";
      String driver = "com.mysql.jdbc.Driver";
      String userName = "root"; 
      String password = "ADMINALON";
      try {
          Class.forName(driver).newInstance();
          conn = DriverManager.getConnection(url+dbName,userName,password);
          resp.getWriter().println("Connected to the database");
          conn.close();
          resp.getWriter().println("Disconnected from database");
      } catch (Exception e) {
          e.printStackTrace(); 
      }
  }
}

now, I run testest by run as->web application.

enter the url: localhost:8888

and only see the 'hello world'.

I read about that and see that I need to write the command:

set CLASSPATH=%CLASSPATH%;JAVA_HOMElib;

but what are the url-s of my CLASSPATH and JAVA_HOME should be? I have folders of: c:/program_fils/java and: c:/Jconnector (something like that).

the folder of Jconnector contains a file of: mysql-connector-java-5.1.22.jar

I tried to add the JAR into the libraries via the eclipse (right click on testest->properties->Libraries->add external jar->mysql-connector-java-5.1.22-bin.jar:

p.s, my operating system is windows 32bit.

Answer 1

There is no need of doing

set CLASSPATH=%CLASSPATH%;JAVA_HOMElib;

Just add mysql-connector-java-5.1.22-bin.jar: to /WEB-INF/lib directory.

Eclipse is smart enough to recognize .jar files added under /WEB-INF/lib and should include in the CLASSPATH.

Adding a library using "Add External Jar" should also work but its not best practice.

Dropping ".jar" inside /WEB-INF/lib will also work when you externally deploy your web apllication using .war