Hello i am developing a web app in JSP as front end and ms-access as back end..i hv login.jsp which contains username & password which will be validated in access database upon success user.jsp will be shown..i hv been done with jsp page design..but don't know abt database connectivity..can any1 help
.
.
one more thing..
I am on Windows 7 (64 bit)
JDK,JRE (64 bit)
Netbeans 7 (32 bit)
Office 2010 (32 bit)....now is there any driver issue involved in JDBC-ODBC driver for 64 bit ???...Coz i cudnt see any access driver in ODBC Data Source (Control Panel)
Your Help will be appreciated..!!
sagar2dumbre 0 Newbie Poster
peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster
there maybe someone willing to help if you post your code.
PS: would be good idea to use different database like MySQL as you are unlikely to find person on Unix with Access DB
sagar2dumbre 0 Newbie Poster
Login.jsp
<%--
Document : login
Created on : Jan 22, 2012, 4:17:51 PM
Author : Dumbre
--%>
<%@page language="java" import="java.net.*" contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>::Flat Booking System :: Indian Oil Corporation Limited</title>
<link rel="stylesheet" type="text/css" href="css/style.css"/>
<link rel="icon" type="image/png" href="images/favicon.png"/>
</head>
<body>
<form method="POST" action="login">
<div class="top">
<jsp:include page="resources/header.jsp" ></jsp:include>
</div>
<h1 id="caption">:: <u>Flat Booking System</u> ::</h1>
<table id="login-box" >
<tr>
<td colspan="2">
<div id="headline"> <u><i>Central Login </i></u></div>
</td>
</tr>
<tr>
<td id="logo1">
<img id="logo" src="images/logo.png"/>
</td>
<td id="login-form">
<table id="form">
<tr><td id="username-label">
<label for="username" id="username-label"><small><b>USERNAME</b></small></label>
</td>
<td id="username-text">
<input type="text" accesskey="u" size="32" tabindex="1" name="username" id="username"/>
</td>
</tr>
<tr><td id="password-label">
<label for="password" id="password-label"><small><b>PASSWORD</b></small></label>
</td>
<td id="password-text">
<input type="password" accesskey="p" autocomplete="off" size="32" tabindex="2" name="password"
id="password"/>
</td>
</tr>
<tr><td colspan="2" align="center" id="submit">
<input type="submit" value="LOGIN" accesskey="l" tabindex="4" id="login-submit"/>
</td>
</tr>
</table>
</td>
</tr>
</table>
</div>
</form>
</body>
</html>LoginServlet.java
package Validate;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
public class LoginServlet extends HttpServlet {
String uname="";
String pass="";
String url = "jdbc:odbc:FBS";
Connection conn=null;
Statement st=null;
ResultSet rs=null;
String classPath = "sun.jdbc.odbc.JdbcOdbcDriver";
@Override public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
try{
response.setContentType("text/html");
HttpSession session = request.getSession(true);
Class.forName(classPath);
conn=DriverManager.getConnection(url);
uname=request.getParameter("username");
pass=request.getParameter("password");
st=conn.createStatement();
rs=st.executeQuery("select * from user_login where UserName='"+uname+"' and Password='"+pass+"'");
while(rs.next())
{
session.setAttribute("uname", uname);
session.setMaxInactiveInterval(120);
RequestDispatcher dispatcher=request.getRequestDispatcher("/flat_status.jsp");
dispatcher.forward(request, response);
}
rs.close();
st.close();
conn.close();
}
catch(Exception e)
{
System.out.println(e.getMessage());
}
}
}web.xml
<?xml version="1.0" encoding="UTF-8"?>
<web-app version="3.0" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:c="http://java.sun.com/jsp/jstl/core" xmlns:fmt="http://java.sun.com/jsp/jstl/fmt" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd">
<servlet>
<servlet-name>action</servlet-name>
<servlet-class>org.apache.struts.action.ActionServlet</servlet-class>
<init-param>
<param-name>config</param-name>
<param-value>/WEB-INF/struts-config.xml</param-value>
</init-param>
<init-param>
<param-name>debug</param-name>
<param-value>2</param-value>
</init-param>
<init-param>
<param-name>detail</param-name>
<param-value>2</param-value>
</init-param>
<load-on-startup>2</load-on-startup>
</servlet>
<servlet>
<servlet-name>LoginServlet</servlet-name>
<servlet-class>Validate.LoginServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>action</servlet-name>
<url-pattern>*.do</url-pattern>
</servlet-mapping>
<servlet-mapping>
<servlet-name>LoginServlet</servlet-name>
<url-pattern>/login</url-pattern>
</servlet-mapping>
<session-config>
<session-timeout>
30
</session-timeout>
</session-config>
<welcome-file-list>
<welcome-file>login.jsp</welcome-file>
</welcome-file-list>
</web-app> sagar2dumbre 0 Newbie Poster
there maybe someone willing to help if you post your code.
PS: would be good idea to use different database like MySQL as you are unlikely to find person on Unix with Access DB
if Username & Password are correct (matched with db) then new jsp page flat_status.jsp should open
and I hv been told 2 use db as access...:sad:
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.