<%@page contentType="text/html"%> <%@page pageEncoding="UTF-8"%> <%@ page import="javax.sql.*" %> <%@ page import="java.sql.*" %> <%@ page import="javax.naming.*" %> <% HttpSession uSession = request.getSession(true); if(uSession.isNew()) { String username = request.getParameter("username"); String password = request.getParameter("password"); uSession.setAttribute("username", username); uSession.setAttribute("password", password); } Connection dbConn = null; ResultSet sqlresult = null; Statement sqlquery = null; try { Class.forName("com.ibm.db2.jcc.DB2Driver"); dbConn = DriverManager.getConnection("jdbc:db2:db2t",(String) uSession.getAttribute("username"),(String) uSession.getAttribute("password")); } catch (ClassNotFoundException e) { out.println("ClassNotFound"); String tracestack = e.toString(); out.println(tracestack); } catch (SQLException sqle) { out.println("SQLException, DB Open"); String tracestack = sqle.toString(); out.println(tracestack); } %> Vendor Database
Vendor Database Main Menu
<% if(uSession.getAttribute("username") != null) { String user = (String) uSession.getAttribute("user"); out.println("HIYA."); } else { out.println("Username was invalid. Please try again. "); request.getSession().invalidate(); } try { sqlresult.close(); sqlquery.close(); dbConn.close(); } catch(SQLException sqle) { out.println("SQLExecution, DB Close."); sqle.printStackTrace(); } %>