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!
| DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware. |