1 2 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