Posted by: Chyne on: September 11, 2009
A design pattern is a template, reusable.
M – odel (related to data)
V – iew (control by data access)
C – ontrol (control by servlet)
What is a Javabean (container)
- Specialized java class
- Consist mainly of getter & setter methods
- Constructor method no parameters
- Special eclipse menu to generate default getters and setters.
A [...]
Posted by: Chyne on: September 6, 2009
package com.asip.servlet;
import java.io.IOException;
import java.sql.*;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class ProcVoter extends HttpServlet {
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String nricno = request.getParameter(“nricno”);
String rname = request.getParameter(“rname”);
String race = request.getParameter(“race”);
String gender = request.getParameter(“gender”);
String area = request.getParameter(“area”);
String address = request.getParameter(“address”);
Connection con=null;
/*
* if IC number and voter’s name is empty, display the error message
* remains in [...]
Posted by: Chyne on: September 6, 2009
package com.asip.servlet;
import java.io.IOException;
import java.sql.*;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class ProcLogin extends HttpServlet {
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException
{
/* 1. Initialize database configuration for database connetion
* 2. Prints out the database connection information
*/
System.out.println(“Load JDBC Driver”);
String driverName=”org.postgresql.Driver”;
String serverName=”localhost:5432″;
String database=”voter”;
String username=”postgres”;
String url=”jdbc:postgresql://”+serverName+”/”+database;
System.out.println(“jdbc url: “+url);
String userid = request.getParameter(“userid”);
String password = request.getParameter(“password”);
/* 1. connect to the database
* [...]
Posted by: Chyne on: August 31, 2009
Overview
- Structured collections of records or data.
Database Models
• Flat model – spreadsheet
• Hierarchical model – XML
• Relational model
Views
- Virtual or logical table
- Subset the data contained in a table
- Security purpose (limit expose)
Database Indexing
- Improves the speed of operations in a table
Transaction and Concurrency
- Interaction with a database management system.
- Series of commands (can consist of multiple SELECTs)
ACID
• Atomicity – Either the transaction must be completed [...]
Posted by: Chyne on: August 31, 2009
<?xml version=”1.0″ encoding=”UTF-8″?>
<web-app version=”2.4″
xmlns=”http://java.sun.com/xml/ns/j2ee”
xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance”
xsi:schemaLocation=”http://java.sun.com/xml/ns/j2ee
http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd”>
<!– Mapping of form login to action servlet ProcLogin –>
<servlet>
<display-name>User Login</display-name>
<servlet-name>ProcLogin</servlet-name>
<servlet-class>com.asip.servlet.ProcLogin</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>ProcLogin</servlet-name>
<url-pattern>/servlet/ProcLogin</url-pattern>
</servlet-mapping>
<!– Mapping of form registration to action servlet ProcVoter –>
<servlet>
<display-name>Register Voter</display-name>
<servlet-name>ProcVoter</servlet-name>
<servlet-class>com.asip.servlet.ProcVoter</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>ProcVoter</servlet-name>
<url-pattern>/servlet/ProcVoter</url-pattern>
</servlet-mapping>
</web-app>