JSP - example code - The Java Programming language

Training, Open Source computer languages

Perl • PHP • Python • MySQL • Apache / Tomcat • Tcl • Ruby • Java • C and C++ • Linux • CSS

Home

Accessibility

For 2023 (and 2024 ...) - we are now fully retired from IT training.
We have made many, many friends over 25 years of teaching about Python, Tcl, Perl, PHP, Lua, Java, C and C++ - and MySQL, Linux and Solaris/SunOS too. Our training notes are now very much out of date, but due to upward compatability most of our examples remain operational and even relevant ad you are welcome to make us if them "as seen" and at your own risk.

Lisa and I (Graham) now live in what was our training centre in Melksham - happy to meet with former delegates here - but do check ahead before coming round. We are far from inactive - rather, enjoying the times that we are retired but still healthy enough in mind and body to be active!

I am also active in many other area and still look after a lot of web sites - you can find an index ((here))

JSP - example code

Posted by enquirer (enquirer), 6 March 2004

Can you give me an example of all the pieces of code I'll need to write a JSP that looks something up in a database?

Posted by admin (Graham Ellis), 6 March 2004

You'll need:
a) A form in which to enter any information needed to define your query
b) Your JSP page to perform the query and report
c) A Java bean to do the "real work" behind the JSP page

The form
Code:

<head>
<title>ISBN lookup!</title>
</head>
<body>
<h1>Find an author from an ISBN number</h1>
Please enter the ISBN number of a book in the Well House Consultants
library and we'll tell you the name of (one of) the Authors
<br>
<form action=getauthor.jsp>Enter ISBN <input name="isbn" /><br />
<input type="submit" /></form>
</body>

The JSP page (getauthor.jsp in the same directory as the form)
Code:

<html>
<head>
<title>Author of book from ISBN number</title>
</head>
<body>
<h1> Result page</h1>
<jsp:useBean id="fred" class="boox.Book" />
<jsp:setProperty name="fred" property="*" />
<% if (fred.getAuthor().equals("numerous")) { %>
That is not an ISBN number on our database<br>
<% } else { %>
Author is <jsp:getProperty name="fred" property="author" /><br>
<% } %>
Done!
</body>

The Java bean (in WEB-INF/classes/boox, compiled to .class)
Code:

package boox;
import java.sql.*;
public class Book {
String Isbn;
public Book () {
Isbn = null;
}
public void setIsbn(String val) {
Isbn = val;
}
public String getAuthor() {
String Wanted = "numerous";
if (Isbn == null) return "Not set";
try {
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
Connection books = DriverManager.getConnection
("jdbc:mysql://192.168.200.188/wellho?user=trainee&password=abc123");
Statement s = books.createStatement();
ResultSet r = s.executeQuery
("Select authorfull from books where isbn = \""+Isbn+"\"");
while (r.next()) {
Wanted = r.getString("authorfull");
}
} catch (Exception e) {
return e.toString();
}
return Wanted;
}
public static void main (String [] args) {
Book Desk = new Book();
Desk.setIsbn("0-596-00283-1");
String By = Desk.getAuthor();
System.out.println(By);
}

}

This is cut and pasted from a training server, and has been tested. In a live application you would add better feedback, error testing and exception handling as a minimum. You would also use a better password on your database!

This page is a thread posted to the opentalk forum at www.opentalk.org.uk and archived here for reference. To jump to the archive index please follow this link.

You can Add a comment or ranking to this page

Public Training Courses

Running regularly at our UK training Centre.
[Schedule] - [About] - [Book]

Other Forum Posts

JavaScript: find in page [iframe]

In Mysql, longblob is not storing more than 200kb

Please Help (Thanks very much!!!)

Embedd .js files in Perl n execute in Tomcat

Javascript problem

Please HELP me URGENT

connecting Tomcat and Apache using jk2

Menu options

Urgent Problem

how to get index of key from hash table

delete occurences of object having simlar property

implemeting using hashes or array

Tomcat - Load Balancing v Clustering

reading in a file and changig the column values

Inputting two dimensional array from command promp

apache and java

Random back grounds.

Urgent problem with Inheritance and java arrays.

java programming - to display the excel bar charts

Java Regular Expressions

japplet reads input from file, but not displaying

JAVA_Problem

Web Crawler

Training notes available for download

java.net.BindException errors

Java date and calendar classes

Connecting Apache httpd to Apache Tomcat

Version numbering in Java

Bristol Java User Group

Tomcat 4.1 - java CPU% at 99.9%

searching using arrays

Parsing date & times from strings to long

What does "Java" stand for?

JSP - example code

Formatting numbers - right aligning

Stream Tokeniser or String TOkenizer

array in java

JNDI Lookups in Sun ONE

Threads - what are they for?

Moved: subset a list

JSP overkill ?

Reading data from Excel in Java

Accessing SQL from applet - security exception

Apache, Jakarta, Tomcat, Catalina, Coyote, Jasper

Do anybody used SMS Library?

C# / JAVA developers wanted (UK Contract)

java progrmming,please help!!!!

String Tokenizer

saving output as textfile

Re: Code needs generating a method with more than

array in deascending order

XML Hell (Just give me the value!)

JSP, Servlets and MySQL / David Harms

Help on writing a simple program

Help - Heap file implementation

Reading a text area in a servlet

Having problems getting started

Relational Database

Need help on Arrays Urgently ???

Where can I learn about Servlets?

jbuilder8 and mysql need help badly

Self authenticating servlet

Java GUI Interface

A hash of hashes

Dynamic arrays in Java?

How big shall I make my array?

Installation, admin, programming of Jakarta Tomcat

Using Stringtokenizer to add to DoubleLinkedList

On learning Java if you already know Perl!

Compiling Java into object files?

Java2 1.4 - Regular Expression Example

J2SE 1.4.1 RC

Unicode Characters - a list

Updates to Java Quiz

© WELL HOUSE CONSULTANTS LTD., 2024: Well House Manor • 48 Spa Road • Melksham, Wiltshire • United Kingdom • SN12 7NY
PH: 01144 1225 708225 • FAX: 01144 1225 793803 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho