Display data

after successful login how i can fetch my account information from sql database

View Answers

June 3, 2011 at 12:08 PM

1)login.jsp:

<html>
<script>
function validate(){
var username=document.form.user.value;
var password=document.form.pass.value;
if(username==""){
 alert("Enter Username!");
  return false;
}
if(password==""){
 alert("Enter Password!");
  return false;
}
return true;
}
</script>
<form name="form" method="post" action="check.jsp" onsubmit="javascript:return validate();">
<table>
<tr><td>Username:</td><td><input type="text" name="user"></td></tr>
<tr><td>Password:</td><td><input type="password" name="pass"></td></tr>
<tr><td></td><td><input type="submit" value="Submit"></td></tr>
</table>
</form>
</html>

2)check.jsp:

<%@page import="java.sql.*"%>

<%
try{
String user=request.getParameter("user");
String pass=request.getParameter("pass");
 Class.forName("com.mysql.jdbc.Driver").newInstance();
    Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root");  
           Statement st=con.createStatement();
           ResultSet rs=st.executeQuery("select * from login where username='"+user+"' and password='"+pass+"'");
           int count=0;
          while(rs.next())
          {
                              count++;
          }

                    if(count>0){
            out.println("welcome "+user);
            Statement s=con.createStatement();
           ResultSet rst=s.executeQuery("select * from login where username='"+user+"' and password='"+pass+"'");
          while(rst.next()){
              System.out.println(rst.getString("firstname"));
            %>
            <h3>Your Account Information</h3>
            <table>
            <tr><td>FirstName:</td><td><input type="text" name="name" value="<%=rst.getString("firstname")%>"></td></tr>
            <tr><td>LastName:</td><td><input type="text" name="name" value="<%=rst.getString("lastname")%>"></td></tr>
            <tr><td>Address:</td><td><input type="text" name="name" value="<%=rst.getString("address")%>"></td></tr>
            <tr><td>Contact No:</td><td><input type="text" name="name" value="<%=rst.getString("contactNo")%>"></td></tr>
            <tr><td>Email:</td><td><input type="text" name="name" value="<%=rst.getString("email")%>"></td></tr>
           </table>
            <%
          }
          }
          else
          {
                       response.sendRedirect("login.jsp?msg=Username or Password is incorrect!");
          }
}

catch(Exception e){
    System.out.println(e);
}
%>

Ads

Advertisements

display data in php
display data in php i want data validation in javascript for my form data and it will display in php. my fields are name,emailid,address,country combobox,state combo box, i want only php page,can u wxplain process how it come

Display the data to MS word
Display the data to MS word i want help with displaying data on to ms word.When i click the button my web page my servlet should get the data from the database(say im searching using an id) and should display it on the ms word

how to display data in excel sheet?
how to display data in excel sheet? According to the user Id,some links will be generated from the database,and if we click a link,data would... the button and to display the data in excel sheet

How to Display Data in a tree structure on the GUI
How to Display Data in a tree structure on the GUI how to display data in a tree structure on the GUI? I need this sort of UI to display data showing a set of rules showing various conditions and the actions related

Display both image and data into Swing JTable
Display both image and data into Swing JTable How To Display both image and data into Swing JTable which is retrieved from MySQL database

Display error message if data is already inserted in database
Display error message if data is already inserted in database Display error message if data is already inserted in database Pls help me Thanks

How to display the data column on jsp
How to display the data column on jsp My requirements: Display total...; </form> It display the data of last database server... with this situtaion. should i set the data in a pojo and display the data in row wise

Fetch the data from mysql and display it on php form
Fetch the data from mysql and display it on php form when i press on login button, after succesful login the related data of that person should be display in other textbox

On Click on Submit Button Display Data on Orderlist
On Click on Submit Button Display Data on Orderlist How can retreive data from database on orderlist on Click on submit Button of same page

display data from database on selecting option of dropdownlist
display data from database on selecting option of dropdownlist Sir I want to display data from database by just selecting option of dropdown list... is that to display image from database in a grid format or in a fixed column and row

jfreechart display from access database data.
jfreechart display from access database data. I have made a database... to retrieve the data from the access database using prepared statement and then display the bar graph using jfreechart API .This whole retrieval and display of chart

display data from a table in Access Database in a HTML page
display data from a table in Access Database in a HTML page how to display data from a table in Access Database in a HTML page in a Java Program

how to display data in List Or grid or in table in Jsp
how to display data in List Or grid or in table in Jsp <%@page...(); } %> </body> </html> this is my jsp code i want to display String P Value in List GIrd or Table please help am able to Print display data

how to display the data from excel to webpage
how to display the data from excel to webpage Hi, I need help... search for the value 4024 in a excel file and to display the remaining values... that reads the excel file and store data into table. <%@page import="java.io.*"%>

Display Data from Database in JSP
; <html> <head> <title>display data from...;To display all the data from the table click here...</h2></TD>...;title>display data from the table using jsp</title> </head> <

how to display data from jsp file into database
how to display data from jsp file into database this is a jsp file...+","+ph2+")"); out.println("Data is successfully inserted...+",'"+email+"')"); out.println("Data is successfully inserted into database

display data from database in textbox when id entered in textbox
display data from database in textbox when id entered in textbox i wanted to enter data in textbox .depending on entered data in textbox data from database should be displayed dynamically in textbox

How to display data from database in a TableView
How to display data from database in a TableView I need to populate... at this. The classes: This is the Class that creates the database data object: import...; data; private List<NewBeautifulKiwi> initializeTable() { data

how to display data into textboxes which is retrieved from the database
how to display data into textboxes which is retrieved from the database I would like to know how to display data into textboxes which is retrieved from database in jsf. could you please provide a small example of how to do

How to display data in jsp from dao using java beans?
How to display data in jsp from dao using java beans? Hi I need to display data in jsp pulling from dao using java beans, Please can anyone give me the sample application with above topics. Any help would be highly appreciated

Display Data from Database in JSP
Display Data from Database in JSP ... and execute query to display data from the specified table. Before...;title>display data from the table using jsp</title> </head> <

SEARCHING THE DATA FROM DATABASE AND DISPLAY THE SEARCHED DATA IN HTML PAGE
SEARCHING THE DATA FROM DATABASE AND DISPLAY THE SEARCHED DATA IN HTML... the user specified $data = mysql_query("SELECT * FROM book WHERE upper($field) LIKE'%$find%'"); //And we display the results while($result = mysql_fetch

Ads