README.md

Description

Simple example of a java servlet. This is a "tone-downed" version of a servlet I created for a school in the South. I figured maybe someone out there may get some use out of it, or maybe not. If you do, have fun with it. If you want use this, remember to create your DBMS (ie, MSACCESS).

More Info

Submitted On
By	Steven Jacobs
Level	Intermediate
User Rating	5.0 (15 globes from 3 users)
Compatibility	Java (JDK 1.1)
Category	Miscellaneous
World	Java
Archive File

API Declarations

U of M Online Registration Servlet

launches servlet OnlineRegsServlet

*(Required Fields)
*Name:
*Class Standing:
*Term:
*Year:

Select the class/classes you wish to take this term.
COMP 1900
COMP 2150
COMP 3160
COMP 4030
COMP 4990
COMP 6320

Source Code

/////////////////////////////////////////////////////////////////////////// //Title: Online Registration Servlet //Author: Steven Jacobs //Dev. Tools: JBuilder3..JDK 1.2 //Description: This is a mock-up version of an online registration servlet // for any university. It is similar to an online family reservation // servlet I created about 7 months ago. I thought I would take about // an hour to do this and share it with you. Maybe you can get // something out of it. Please improve. //////////////////////////////////////////////////////////////////////////// package untitled28; import javax.servlet.; import javax.servlet.http.; import java.io.; import java.util.; import java.sql.; public class OnlineRegsServlet extends HttpServlet { private Statement conStatement = null; private Connection conDatabase = null; private String odbcURL = "jdbc:odbc:RegsBook"; String name; String classStanding; String term; String year; String class1; String class2; String class3; String class4; String class5; String class6; PrintWriter outWrite; //Initialize global variables public void init(ServletConfig config) throws ServletException { super.init(config); try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); conDatabase = DriverManager.getConnection(odbcURL, " ", " "); } catch (Exception e) { e.printStackTrace(); conDatabase = null; } } public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { //String name,classStanding,term,year,class1,class2,class3,class4,class5,class6; name = request.getParameter("Name"); classStanding = request.getParameter("Class_Standing"); term = request.getParameter("Term"); year = request.getParameter("Year"); class1 = request.getParameter("Class1"); class2 = request.getParameter("Class2"); class3 = request.getParameter("Class3"); class4 = request.getParameter("Class4"); class5 = request.getParameter("Class5"); class6 = request.getParameter("Class6"); outWrite = response.getWriter(); response.setContentType("text/html"); if (name.equals("") || classStanding.equals("") || term.equals("") || year.equals("")) { outWrite.println("

All the fields '' fields must be filled out

"); outWrite.close(); return; } boolean insertSuccess = inputInformation( "'" + name + "','" + classStanding + "','" + term + "','" + year + "','" + (class1 != null ? "yes" : "no") + "','" + (class2 != null ? "yes" : "no") + "','" + (class3 != null ? "yes" : "no") + "','" + (class4 != null ? "yes" : "no") + "','" + (class5 != null ? "yes" : "no") + "','" + (class6 != null ? "yes" : "no") + "'"); if (insertSuccess) { outWrite.print("

"+ name + " is registered for the " + term + " term " + ", " + year + "

"); } else outWrite.print("

Server error...try again later.

"); } private boolean inputInformation(String insertInfo) { try { conStatement = conDatabase.createStatement(); conStatement.execute("INSERT INTO RegTable values(" + insertInfo + ");"); conStatement.close(); } catch(Exception e) { System.err.println("Something is wrong..I cannot add any new entry " + "HELP ME"); e.printStackTrace(); return false; } return true; } public void destroy() { try { conDatabase.close(); } catch (Exception e) { System.err.println("Cannot close the database"); } } //Get Servlet information public String getServletInfo() { return "untitled28.OnlineRegsServlet Information"; } }