Problem with JDBC

[Yurong Chen]

Hello, I met two problems in my project:
1. I wrote the following application. It can be complied. However, when I run it, i get the error message:

  java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at Application.run(Application.java:55)
at java.lang.Thread.run(Unknown Source)

My Application.java is as followed:

 import java.io.*;
import java.util.*;
import java.sql.*;
import java.util.Properties;
import javax.mail.*;
import javax.mail.internet.*;
class Application extends Thread {   
   boolean isOkay = true;   
   public static void main(String args[]) {     
        new Thread(new Application()).start();   
   }   
   public void run() {    
   while(isOkay) {      
   try {        
   sleep(120000);     
   System.out.println("Sleep Finished!"); 
   } catch (InterruptedException e) {        
   isOkay = false;             
   }      
           // main application of connect to database here 
   
 String fileName = "";  
 String email ="";
 String firstName="";
  String applied ="no";
          Connection con = null;
          
          //set relevant variables about JMatLink
     JMatLink engine = new JMatLink();
     String command ="perceptron " + fileName;
     String directory="cd C://Tomcat4//webapps//project//matlab";
       int EpI;
      
      
       //set relevant variable about sending email
       Send resultEmail = new Send();
       String fromName="Chen Yurong";
        String fromAddress ="[e-mail]";
         String resultFile="C://Tomcat4//webapps//project//matlab//results.mat";
         String smtpHost = "broadstone.sheffield.ac.uk";
         String subject1="Successful Result!";
         String subject2="Failed Result!";
         String body = "Welcome to Bioinformatics webserver!We are sorry that the request you submitted cannot get a satisfied result now  " ;

                 resultEmail.setFromName(fromName);
    resultEmail.setSmtpHost(smtpHost);
    resultEmail.setFromAddress(fromAddress);
    resultEmail.setToAddress(email);
    resultEmail.setToName(firstName);
    
         // Load the Database Driver and catch the Exception
try {
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
}catch (Exception e) {   
e.printStackTrace();
// Sending failed information to client by email
 
 resultEmail.setBody(body);
        resultEmail.setSubject(subject2);
        resultEmail.send();
        System.out.println("failed!");
        System.exit(1);
  }
                 System.out.println("Load database!");
// Declare the Query Elements
    Statement stmt = null;
    ResultSet result = null;
    ResultSet result2 = null;
// Make the connection with the database and report any errors
try{  
         
          con=DriverManager.getConnection("jdbc:mysql://localhost/project?user=m1yc3&password=124124");
  stmt=con.createStatement();
  
  result= stmt.executeQuery("SELECT name, email, status FROM File WHERE status = \""+applied+"\" LIMIT 1 ");
  System.out.println("choose out!");
  fileName = result.getString(1);
  email = result.getString(2);
  applied="yes";
  stmt.executeUpdate("UPDATE File SET status =\"" + applied + "\" WHERE name =\"" + fileName + "\"");
                  System.out.println("updated succesfully!");
                  result2 = stmt.executeQuery("SELECT f_name FROM Client WHERE email = \""+email+"\"");
                  firstName = result2.getString(1);
                  System.out.println("First name out!");
//Empty the Query statements
   if (result!=null)
    result.close();
          if (result2!=null)
    result2.close();
  if (stmt != null)
       stmt.close();       
   } catch (SQLException e) {}
            catch (Exception e) {   
      e.printStackTrace();
          }
  
  // Using JMatLink to open Matlab envirnment to process request and send result
  
                
        
        
    
       try {
   EpI= engine.engOpen();
   engine.engEvalString(directory);
    engine.engEvalString(command);
       System.out.println("succesfully!");
 engine.engClose();
 
 //Sending Result to client by email 
 
                resultEmail.setSubject(subject1);
resultEmail.attachfile(resultFile);
                resultEmail.sendFile(); 
                System.out.println("send Email!");
 
 }catch (Exception e) {
 
 // Sending failed information to client by email
 
 resultEmail.setBody(body);
        resultEmail.setSubject(subject2);
        resultEmail.send();
        System.out.println("failed!");
 }
 
 
 
        }  
   }
} 

2. I want to count rows when I select something from tables. I use the following jsp programming. However, I cannot get the variable "count"'s value after I execute the SQL. The SQL is

stmt.executeQuery("SELECT COUNT(*) FROM File WHERE status = \""+applied+"\" GROUP BY status");  

The method I want to get the value of "Count" is

 count = resultOfSort.getInt(1); 

My whole program is as followed:

 <jsp:useBean id="currentDate" class = "project.NewDate" scope="request">
  
</jsp:useBean>
   
<%@ page import= "java.sql.*" %>
<%
 String fileSize = request.getParameter("fileSize").trim();
         String fileName = (String)session.getAttribute("fileName");  
 String email = (String)session.getAttribute("email");
         String filePathName = request.getParameter("filePathName").trim();
         String queue = (String)session.getAttribute("queue");  
 String directory = "C://Tomcat4//webapps//project//matlab//";
 String applied="no";
 int count=0;


Connection con = null;
// Load the Database Driver and catch the Exception
try {
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
}catch (Exception e) {   
e.printStackTrace();
  }
          
    boolean duplicateError = false;
            int times =0;
    response.setContentType("text/html"); // Set the content type 
    response.setHeader("Expires","Mon, 01 Jan 1990 00:00:00 GMT"); // Force the browser to reload each time.
// Declare the Query Elements
    Statement stmt = null;
    ResultSet result = null;
    //ResultSet resultOfSort = null;
   
            
 // Make the connection with the database and report any errors
try{  
         
          con=DriverManager.getConnection("jdbc:mysql://localhost/project?user=m1yc3&password=124124");
  stmt=con.createStatement();
  //stmt2=con.createStatement();
  resultOfSort = stmt.executeQuery("SELECT COUNT(*) FROM File WHERE status = \""+applied+"\" GROUP BY status");
  //result= stmt.executeQuery("SELECT * FROM File WHERE status = \""+applied+"\"");
  count = resultOfSort.getInt(1);
  
  if (count >=10) {
%>
                  <jsp:forward page="bioinformatics.jsp">
<jsp :-P	 aram name="fail" value="1" />
  </jsp:forward>
<%
  }
                          else {
  
  
         result = stmt.executeQuery("SELECT name,size,ID, email FROM File ORDER BY ID ");

          while(result.next())
                          {
     times = result.getInt(3);
     if((fileName.equals(result.getString(1)))&&(email.equals(result.getString(4)))&&(fileSize.equals(result.getString(2))))
   duplicateError = true;
          }
// Update the database;
          
if(duplicateError){
  session.invalidate();
%>
                          <jsp:forward page="sequenceTry.jsp">
        <jsp :-P	 aram name="fail" value="2" />
          </jsp:forward>
<% 
 }
 else{

  stmt.executeUpdate("INSERT INTO File VALUES(\""+(times+1)+"\",\""+fileName+"\",\""+fileSize+"\",\""+directory+"\",\""+email+"\",\""+applied+"\")");
          stmt.executeUpdate("INSERT INTO Statistics VALUES(\""+(times+1)+"\",\""+fileName+"\",\""+currentDate.getYear()+"\",\""+currentDate.getMonth()+"\",\""+currentDate.getDay()+"\",\""+currentDate.getDayOfMonth()+"\",\""+currentDate.getZoneOffset()+"\")");
// session.setAttribute("queue",count);
%>      
 <jsp:forward page="successfulRequest.jsp">
<jsp :-P	 aram name="fileSize" value="<%=fileSize%>"/>
<jsp :-P	 aram name="filePathName" value="<%=filePathName%>"/>
                <jsp :-P	 aram name="queue" value="<%=count%>"/>
</jsp:forward>
<%
 }

                          }
//Empty the Query statements
   if (result!=null)
    result.close();
  if (stmt != null)
       stmt.close();       
   } catch (SQLException e) {}
            catch (Exception e) {   
      e.printStackTrace();
          }
 %>

 

Can anybody help me ?? Thank you in advance!
Yurong

[Graham Thorpe]

U set the classpath ur mysql driver..then u can get the result..