Hi
I created a JSP file with the following code:
| <html>
| <head>
| <title>Enregistrer un travail</title>
| </head>
|
|
|
| <%@ page language="java" import="java.sql.*"%>
| <body>
| <%
| String nom = request.getParameter("login");
| String mdp = request.getParameter("mdp");
|
| Class.forName("com.mysql.jdbc.Driver");
| Connection myConn =
DriverManager.getConnection("jdbc:mysql:prieur?user=&password=");
| Statement stmt = myConn.createStatement();
| ResultSet myResultSet = stmt.executeQuery("select * from ouvriers");
|
| String nomouv = "";
| String mdepass = "";
|
| if (myResultSet != null)
| {
| while (myResultSet.next()) {
| nomouv = myResultSet.getString("nomouv");
| mdepass = myResultSet.getString("mdepass");
| }
| }
| if (nomouv == nom && mdepass == mdp)
| {
| %>
| <H1>Introduction d'un nouveau travail </H1><p>
| <br>
| Veuillez complÃter les champs ci dessous<p>
| <br>
| <form name="formulaire" action="" method="post"
onsubmit="return valid(this.elements)">
| <table border="0" width="100%">
| <tr>
| <td width="45%">
| <table border="0" width="100%">
| <tr>
| <td width="40%">NumÃro
de compte:</td>
| <td><input type="text"
name="numcompte" size="15" title="inserer le numÃro de compte ou le nom du
titulaire"></td>
| </tr>
| <tr>
| <td>NumÃro de
travail:</td>
| <td><input type="text"
name="numtrav" size ="15" title="ce numÃro est gÃnÃrà automatiquement"></td>
| </tr>
| <tr>
| <td>Temps de
travail:</td>
| <td><input type="text"
name="temps" size="5" title="temps en minutes de travail">min
| </tr>
| </table>
| <td width="55%"><textarea name="description"
cols="40" rows="5" title="inscrivez ici une description du travail effectuÃ"
></textarea> </td>
| </tr>
| </table><p>
| <br>
|
| <table border="0" width="100%">
| <tr>
| <td width="50%">
| <select name="selectmat" size="6"
id="selectmat">
| <option selected>Clous </option>
| <option>ampoule</option>
| </select>
| </td>
| <td width="15%">
| QuantitÃ:<input type="text"
name="quantite" size="3" title="indiquez la quantità utilisÃe du matÃriel">
| </td>
| <td width="35%">
| <input type="button" value="Suivant"
onclick="plus();">
| <input type="text" name="choix">
| <input type="text" name="choix2">
| <input type="submit" value="Valider">
| </td>
| </tr>
| </table>
| </form>
|
| <script language="JavaScript">
| var s=document.getElementById('selectmat');
| var user_input = s.options[s.selectedIndex].firstChild.value
|
| var n=document.getElementById('quantite');
| var tab=new Array();
| var tab2=new Array();
|
| for(i=0;i<s.options.length;i++){
|
| tab=0};
|
| // Ã chaque clic sur "ajouter"
| // le nombre associà à l'article sÃlectionnà est rÃÃvaluÃ;
| function plus(){
| tab[s.selectedIndex]=(/^\d{1,2}$/.test(n.value)) ? n.value : 0;
|
| tab2[s.selectedIndex]=s.options[s.selectedIndex].text;
|
| }
|
|
| // quand on valide le formulaire,
| // la chaÃne correspondant au nombre de chaque article est
| // envoyÃe dans un champ cachà (ici,visible!);
| // cÃtà serveur, il n'y a plusqu'à faire un split;
| function valid(f){
| f["choix"].value=tab.join();
| f["choix2"].value=tab2.join();
| return false// Ã supprimer
| }
| </script>
|
|
|
|
|
|
| <p>
| <br>
| Ci dessous se trouve la liste des travaux que vous avez dÃjÃ
encodÃ. SÃlectionnez en un pour afficher les donnÃes correspondantes.<p>
| <form action="indexc.jsp" method="post">
| <table border="0" width="100%">
| <tr>
| <td width="50%">
| <%
| ResultSet myResultSet2 = stmt.executeQuery("SELECT *
FROM travaux WHERE 'nomouv'=nom");
| if (myResultSet2 != null) {
| while (myResultSet.next()) {
| String date =
myResultSet2.getString("date");
| String numtrav =
myResultSet2.getString("numtrav");
|
| %>
|
| <select name="travail" size="6">
| <option selected><%= date %>
</option>
| <option> mickael</option>
|
| </select>
| <% } } %>
| </td>
| <td>
| <input type="button" value="Afficher">
| </td>
| </tr>
| </table>
| </form>
| <% } else {
| %>
| Identifiant ou mot de passe incorrect veuillez
recommencer.
| <% } %>
|
|
When I try to run it I got the following message
[Quote]
HTTP Status 500 -
--------------------------------------------------------------------------------
type Exception report
message
description The server encountered an internal error () that prevented it from
fulfilling this request.
exception
javax.servlet.ServletException: No suitable driver
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:846)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:779)
org.apache.jsp.indexc_jsp._jspService(org.apache.jsp.indexc_jsp:216)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)
root cause
java.sql.SQLException: No suitable driver
java.sql.DriverManager.getConnection(DriverManager.java:545)
java.sql.DriverManager.getConnection(DriverManager.java:193)
org.apache.jsp.indexc_jsp._jspService(org.apache.jsp.indexc_jsp:57)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)
note The full stack trace of the root cause is available in the Apache
Tomcat/5.5.8 logs.
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3875457#3875457
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3875457
-------------------------------------------------------
SF.Net email is sponsored by: Tell us your software development plans!
Take this survey and enter to win a one-year sub to SourceForge.net
Plus IDC's 2005 look-ahead and a copy of this survey
Click here to start! http://www.idcswdc.com/cgi-bin/survey?id5hix
_______________________________________________
JBoss-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jboss-user