JDBC BEAN AND SOURCE

[Ivo Delver]

I'm trying to use a Javabean to connect to a mysql database.
im using the folowing bean':

package jdbc;
import java.awt.*;
import javax.swing.*;
public class mysql {
public java.sql.Connection sqlConn;
public java.sql.Statement sqlStmt;
//public java.sql.ResultSet sqlRs;
public mysql() {
}
   public void connected(){
     try {
           Class.forName ("org.gjt.mm.mysql.Driver").newInstance ();
           sqlConn=java.sql.DriverManager.getConnection ("jdbc:mysql://localhost:3306/test?user=test;password=test");
           sqlStmt=sqlConn.createStatement();
         }
     catch (Exception E) {
           System.err.println("Kan de MYSQL driver niet laden!");
           E.printStackTrace();
         }
}
public void closed(){
  try {
 //   sqlRs.close();
      sqlStmt.close();
      sqlConn.close();
      }
  catch (Exception E) {
        System.err.println("Kan de mysql Driver niet sluiten.");
        E.printStackTrace();
        }
      }
}

now i want to implement this code into a jsp
but what am i doing wrong?

<%@ page language="java" import="java.sql.*"%> 
<jsp:useBean id="db" scope="application" class="jdbc.mysql"/>
<% 
ResultSet rs = null;
%>
<%
    String naamParam = request.getParameter("naam");
    String titelParam = request.getParameter("titel");
    String berichtParam = request.getParameter("bericht");
db.connect();
rs = db.sqlStmt.executeUpdate ("INSERT INTO nieuws (naam,titel,bericht) VALUES ('"+naamParam+"','"+titelParam+"','"+berichtParam+"')");
db.closed()
%>

[Blake Minghelli]

Hmmm... since you didn't post any error messages, I'll just point out a few things I see wrong.
1. Your mysql code appears to be missing the class declaration statement, e.g. "public class mysql {". Maybe that's just a typo in your post?
2.

db.connect();

Your "mysql" class does not define a method called connect(). It does have one called connected().
3.

rs = db.sqlStmt.executeUpdate...

Statement.executeUpdate() returns an int, not a ResultSet.
Other than that, I suggest you post the exceptions you're getting so we can narrow it down more. Good luck.

[Ivo Delver]

It is working know
Tnx alot