Slapping Together A JSP Development Environment - Making The Grade (
Page 7 of 7 )
If you plan to use JSP to communicate with a database
using a JDBC connection, there are a couple of additional things you need to
do.
First, get yourself a copy of the mm.mySQL module from
http://www.worldserver.com/mm.mysql/
or
http://mmmysql.sourceforge.net/ - this is required to communicate with
the database. Extract the file "mysql.jar" from the archive, and place it in
your JDK's LIB/ folder.
Next, add the location of this file to the
CLASSPATH variable. On Windows, use
C:\>SET CLASSPATH=%CLASSPATH%;C:\JDK\LIB\MYSQL.JAR
and on Linux, use
$ CLASSPATH=$CLASSPATH:/usr/local/jdk/lib/mysql.jar; export CLASSPATH
Pop open your favourite text editor and create the
following JSP file:
<html>
<head>
</head>
<%@ page language="java" import="java.sql.*" %>
<body>
<%
Class.forName("org.gjt.mm.mysql.Driver");
//assume database "test", user "root", password ""
// change this as per your requirements
Connection myConn =
DriverManager.getConnection("jdbc:mysql://localhost/test?user=root&password=
");
Statement stmt = myConn.createStatement();
// assume you have a "grades" table with
// grades is various subjects and student names
// change this as per your requirements
String query = "select * from grades where literature > 90";
ResultSet myResultSet = stmt.executeQuery(query);
if (myResultSet != null) {
while (myResultSet.next()) {
// specify the field name
String name = myResultSet.getString("name");
%>
<%= name %>
<br>
<%
}
}
stmt.close();
myConn.close();
%>
</body>
</html>
This is a simple JSP file to connect to a database, run a
query and return the results. Remember to modify the database name, user details
and query in the example above before proceeding.
Finally, start up
Tomcat, Apache and mySQL. Point your browser to the file you just created - say,
http://localhost/examples/jsp/query.jsp and JSP should display the results of
your query.
And that's it. You now know how to set up a JSP development
environment with minimum fuss and effort. Now get out there and show those kids
how the pros do it!
