BKBIET Phase I - Day 2 and 3

04/06/2013 - 05/06/2013 BKBIET Phase I Day 2 , Day
3

Today.... ✤ Technical ✤ Servlet Platform ✤ tomcat ✤ Database
✤ postgreSQL,mysql,h2 ✤ Atlassian - Jira

Servlets ✤ Servlets - Java CGI? ✤ run inside a
servlet container ✤ encapsulate HTTP in java objects ✤ HTTPServletRequest ✤ HTTPServletResponse ✤ provide methods to process HTTP methods ✤ doGet ✤ doPost public class HelloWorld extends HttpServlet { public void doGet(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException { response.setContentType("text/html"); PrintWriter out = response.getWriter(); out.println("<html>"); out.println("<head>"); out.println("<title>Hello World!</title>"); out.println("</head>"); out.println("<body>"); out.println("<h1>Hello World!</h1>"); out.println("</body>"); out.println("</html>"); } }

Exercise! ✤ Create a Hello World Servlet! ✤ create a
project in eclipse ✤ create src ﬁle ✤ create web.xml ﬁle ✤ add source/details ✤ deploy! ✤ Development Stations!!

Databases ✤ Relational Databases ✤ ACID ✤ Transactions ✤ JDBC
✤ Database Connections ✤ Queries ✤ ResultSets!

Exercise ✤ Create a db bkbiet ✤ Create a table
bkbiet ✤ id ✤ name ✤ age ✤ email ✤ Use java to connect to db ✤ insert your own data in table CREATE TABLE `bkbiet`.`bkbiet` ( ìd` INT NOT NULL AUTO_INCREMENT , `name` VARCHAR(45) NOT NULL , `stream` VARCHAR(45) NOT NULL , èmail` VARCHAR(45) NOT NULL , PRIMARY KEY (ìd`) , UNIQUE INDEX ìd_UNIQUE` (ìd` ASC) ); String insertTableSQL = "INSERT INTO DBUSER" ! ! + "(USER_ID, USERNAME, CREATED_BY, CREATED_DATE) VALUES" ! ! + "(?,?,?,?)"; PreparedStatement preparedStatement = dbConnection.prepareStatement(insertTableSQL); preparedStatement.setInt(1, 11); preparedStatement.setString(2, "mkyong"); preparedStatement.setString(3, "system"); preparedStatement.setTimestamp(4, getCurrentTimeStamp()); // execute insert SQL stetement preparedStatement .executeUpdate();

Templates ✤ Difﬁcult to write long html pages ✤ requires
templates ✤ Enter JSP ✤ Servlets feed data(model) to jsp ✤ converts to html pages ✤ JSP get converted to servlets at runtime

MVC Recall ✤ Model-View-Controller ✤ separate the data from the
view ✤ Servlet: Controller ✤ DAO: Data Access Object ✤ View: JSP

Exercise ✤ Create a web site for users ✤ enter
their details into the db ✤ create a page to view all details ✤ search for a user <HTML> <HEAD> <TITLE>A Sample Form Using GET</TITLE> </HEAD> <BODY> <FORM ACTION="http://localhost:8080/bkbiet/ BKBIETServlet" METHOD=”POST”> <CENTER> Name: <INPUT TYPE="TEXT" NAME="name" VALUE="Joe"><BR> Last name: <INPUT TYPE="TEXT" NAME="age" VALUE="26"><BR> <INPUT TYPE="email" NAME="email" VALUE="[email protected]"><P> <INPUT TYPE="SUBMIT">  </CENTER> </FORM> </BODY> </HTML>

BKBIET Phase I - Day 2 and 3

BKBIET Phase I - Day 2 and 3

Mihir Malaviya

More Decks by Mihir Malaviya

Other Decks in Education

Featured

Transcript

04/06/2013 - 05/06/2013 BKBIET Phase I Day 2 , Day

Today.... ✤ Technical ✤ Servlet Platform ✤ tomcat ✤ Database

Servlets ✤ Servlets - Java CGI? ✤ run inside a

Exercise! ✤ Create a Hello World Servlet! ✤ create a

Databases ✤ Relational Databases ✤ ACID ✤ Transactions ✤ JDBC

Exercise ✤ Create a db bkbiet ✤ Create a table

Templates ✤ Difﬁcult to write long html pages ✤ requires

MVC Recall ✤ Model-View-Controller ✤ separate the data from the

Exercise ✤ Create a web site for users ✤ enter