| 12
 3
 4
 5
 6
 7
 8
 9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 
 | package monpackage.common;
 
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import org.apache.log4j.Logger;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import monpackage.util.Constants;
import monpackage.util.MyException;
 
/**
 * @struts.action path="/HitCounter" name="success" scope="request" validate="true"
 * 
 */
public class HitCounter extends Action {
	public ActionForward execute(ActionMapping mapping, 
		   ActionForm form, HttpServletRequest request, 
		   HttpServletResponse response) throws MyException 
		   {
 
    String driverClass    = "oracle.jdbc.driver.OracleDriver";
    String connectionURL  = "jdbc:oracle:thin:@maBDD";
    String userID         = "username";
    String userPassword   = "password";
    Connection   con                   = null;
 
 
        try {
            Class.forName(driverClass).newInstance();
           con = DriverManager.getConnection(connectionURL, userID, userPassword);
        } catch (ClassNotFoundException e) {e.printStackTrace();} 
		  catch (InstantiationException e) {e.printStackTrace();} 
		  catch (IllegalAccessException e) {e.printStackTrace();} 
		  catch (SQLException e) {e.printStackTrace();}
 
        ResultSet rset      = null;
        String queryString = "UPDATE hits SET counter = counter + 1";
        try {
        	Statement stmt = con.createStatement ();
            rset = stmt.executeQuery(queryString);         
            System.out.println("compteur maj");
            rset.close();
            stmt.close();
 
        } catch (SQLException e) { e.printStackTrace(); }
 
    /**
     * Close down Oracle connection.
     */
//    public void closeConnection() {
        try {con.close();} catch (SQLException e) {e.printStackTrace();}
 
        return mapping.findForward("success");
 
 
  }
 
} | 
Partager