How to connect to an SQL database.

[4345487]

Hi,

I'm trying to learn JSP and I would like if someone has an example of how to connect and get data from a SQl database.


Thanks in advance

 

[palbano]

Please refrain from cross posting

-pete

 

[MPJH]

Basically I use this:

{
Class.forName("com.mysql.jdbc.Driver"
Connection myConn=DriverManager.getConnection("jdbc:mysql://localhost/test?user=root&password=root"
Statement stmt = myConn.createStatement();

String query = "SELECT count(messageNr) FROM messages";

ResultSet resultaat = stmt.executeQuery( query );

while(resultaat.next())
{
String GetIT = resultaat.getString("count(messageNr)"
out.println(" "+GetIT+""
}
}

Note that you need the MySQL connector JAR installed...

greetz,
Menno.