use properties file to connect to the database in jsp..

use properties file to connect to the database in jsp..

How to use properties file to connect jsp code with database ..........

View Answers

September 3, 2012 at 3:58 PM

Here is a jsp code that connects to database using properties file.

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

<%
        Properties prop = new Properties();

        prop.load(new FileInputStream("data.properties"));
        String user = prop.getProperty("username");
        String pass = prop.getProperty("password");
        String port = prop.getProperty("port");

        Class.forName("com.mysql.jdbc.Driver");
        Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:"
                + port + "/test", user, pass);
        Statement st = conn.createStatement();
        ResultSet rs = st.executeQuery("Select * from data");
        while (rs.next()) {
            out.println(rs.getString(1) + " " + rs.getString(2)+"<br>");
        }

    %>

Here is a data.properties file.

username=root
password=root
port=3306

September 4, 2012 at 1:29 AM

Thank for giving your valuable response ...

We can also use as..

db.properties file

driver=sun.jdbc.odbc.JdbcOdbcDriver

connectionurl=jdbc:odbc:pro

username=PRS_ACC

password=prs

save the file.

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

<%@page import="java.io.FileInputStream"%>

<%@page import="java.io.FileNotFoundException"%>

<%@page import="java.io.IOException"%>

<%@page import="java.util.Properties"%>//for use properties 

<%@page contentType="text/html" pageEncoding="UTF-8"%>

<!DOCTYPE html>

<html>

    <head>

         <title>JSP Page</title>

    </head>

    <body>

        <h1>welcome user</h1>


    <%
final Properties myresources = new Properties();

try {
    FileInputStream in = new FileInputStream(
            "C:\\Program Files\\Apache Software Foundation\\Tomcat 5.5\\webapps\\CustomerInfoSystem\\WEB-INF\\classes\\ApplicationResources.properties");//path of the properties file

        try {

            myresources.load(in);

            }

        catch (Exception e) {

        e.printStackTrace();

        }
    } 

catch (Exception e) {

    e.printStackTrace();

}

try

   {

    RequestDispatcher rd=null;

    Connection con=null;

    ResultSet rs=null;

    String drvr=myresources.getProperty("driver");

    String url=myresources.getProperty("connectionurl");

String user_name=myresources.getProperty("username");

    String passw=myresources.getProperty("password");

Class.forName(drvr);//for driver
con=DriverManager.getConnection(url,user_name,passw);//for url and user name  and password.

    String name1=request.getParameter("user");

    String pass=request.getParameter("pass");

    // Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

            //con=DriverManager.getConnection("jdbc:odbc:pro","PRS_ACC","prs");

    Statement st=con.createStatement();

    String sql="select name from user_profile where name='"+name1+"' and password='"+pass+"'" ;

    out.println("query:::"+sql);

    rs=st.executeQuery(sql);

    while(rs.next())
    {
          String aa=rs.getString(1);
          out.println(">>>>>>>"+aa);
          if(name1.equals(aa))
            {
             response.sendRedirect("Welcome.jsp");
             session.setAttribute("username", name1);
            }
    }
    rd=request.getRequestDispatcher("Login.jsp");
    rd.forward(request, response);
    st.close();
    con.close();    
    }
    catch(Exception e)
    {
           out.println(" error"+e);
     }
%>
    </body>
</html>

It must work...

Ads









Related Tutorials/Questions & Answers:
use properties file to connect to the database in jsp..
use properties file to connect to the database in jsp..  How to use properties file to connect jsp code with database ..........   Here is a jsp code that connects to database using properties file. <%@page import
reading dropdown values from properties file in jsp
reading dropdown values from properties file in jsp  reading dropdown values from properties file in jsp
Advertisements
common database jsp file for all the jsp files in the application
common database jsp file for all the jsp files in the application  hi, i have written jspcode to connect to mysqldatabase . i need the code to make use of this single jsp file while connecting to database rather than writing
how to connect jsp with sql database by netbeans in a login page?
how to connect jsp with sql database by netbeans in a login page?  how to connect jsp with sql database by netbeans in a login page
how to connect jsp with sql database by netbeans in a login page?
how to connect jsp with sql database by netbeans in a login page?  how to connect jsp with sql database by netbeans in a login page
how to connect jsp with sql database by netbeans in a login page?
how to connect jsp with sql database by netbeans in a login page?  how to connect jsp with sql database by netbeans in a login page
Unable to connect servet, jsp to oracle 10g database.. Unable to retrieve data..
Unable to connect servet, jsp to oracle 10g database.. Unable to retrieve data.... If I use it also, unable to connect to backend oracle database. Let me... properties file JNDI_NAME=java:com/env/Oracle/jndi db.login= db.password
how to connect to MS access database in JSP?
how to connect to MS access database in JSP?  how to connect to MS access database in JSP? Any seetings/drivers need to be set or installed before... DSN will get created. 6) Restart your server and run your jsp code. Here is your
Connect from database using JSP Bean file
Connect from database using JSP Bean file... to the MySQL database and then we have made the properties setter and getter... methods of this bean file we have to make entry for bean class in jsp file
How to connect to MySQL in JSP?
, You can use the Java JDBC code to connect to MySQL database in JSP page. Check the tutorial: Connect JSP with mysql Thanks...How to connect to MySQL in JSP?  How to connect to MySQL in JSP
How to read and display data from a .properties file from a jsp page
How to read and display data from a .properties file from a jsp page  I have a .properties file. I have to create a jsp page such that it reads the data from this .properties file and display it in table format. Ex:by using
How I Upload File and Store that file name in Database using JSP
How I Upload File and Store that file name in Database using JSP  Hi All, I m the beginner in JSP and I want to upload the file and store that file and some other form data in MySQL database. Ex. There is one employee detail
how to display data from jsp file into database
how to display data from jsp file into database  this is a jsp file . look at the line with code-> Statement st=con.createStatement...+",'"+email+"')"); out.println("Data is successfully inserted into database
How to browse excel file and stored the contents into the database using jsp/servlet?
How to browse excel file and stored the contents into the database using jsp/servlet?  Hi.. I want to browse excel file and stored the file data into the My-sql database using jsp/servlet
How to use an object properties in jsp page
How to use an object properties in jsp page  I have a arraylist of objects 'User' populated using struts 2 action class while loading that jsp page. In that JSP I have included another jsp using following tag: Here instead
Read data from excel file and update database using jsp
Read data from excel file and update database using jsp  read data from excel file and update database using jsp Hi, I am using a MySQL database... upload excel file and update database using JSP ? Thanks in Advance
connect a web page to a database
connect a web page to a database  how to connect a web page to a database
downloading file through a file's path stored in database in jsp
downloading file through a file's path stored in database in jsp  hi want to download a file from a directory where the file location is stored in a database,i have done the coding for retrieving the path from database to a html
Data needs to be gathered in XML file from the database (MySql) using JSP
in XML file from the database (MySql) using appropriate JSP/Java Bean functions...Data needs to be gathered in XML file from the database (MySql) using JSP ... files. using following database create database music; use music; CREATE
how to upload multiple files in jsp and saving the path in database and the file in folder
how to upload multiple files in jsp and saving the path in database and the file in folder  how to upload multiple files in jsp and saving the path in database and the file in folder I have created a form for the upload of files
Connect JSP with mysql
how to connect to MySQL database from your JSP code. First, you need to create database and then write jsp code to connect jsp to database. 1. Create... tutorial of "How to connect to MySQL Database from JSP?": 2
TO connect multiple database
TO connect multiple database  How to connect several database from a single application in java depending upon the user input it will connect to that database
How i upload file and save that record in database using JSP?
How i upload file and save that record in database using JSP?  Hi All, I m the beginner in JSP and I want to upload the file and store that file and some other form data in MySQL database. Ex. There is one employee detail form
connect database with javascript
connect database with javascript  can you please tell me how to connect database with javascript code. [email protected] this is my mail id thanks in advance
How to Upload a file directly to Oracle database using JSP or Servlets?
How to Upload a file directly to Oracle database using JSP or Servlets?  Hi I want to upload a file(csv or excel) to Oracle 10g Database using JSP... FileItem file = (FileItem) items.get(2); // Connect to Oracle
How to connect mysql with jsp
How to connect mysql with jsp  how to connect jsp with mysql while using apache tomcat
Connect database in Access to Netbean?
Connect database in Access to Netbean?  how to connect database in micrsoft access to Netbean?i know it can be connected by using JDBC-ODBC bridge, can i know the steps in connecting the database? Is there any source code
open pdf file in same jsp page and the pdf file should retrieved from database
open pdf file in same jsp page and the pdf file should retrieved from database  Hai all, I need code to open a pdf file in same jsp page(browser) while click on hyperlink And the file was located in database table. Can any
Connect JSP with mysql
; This query creates database 'usermaster' in Mysql. Connect JSP with mysql : Now in the following jsp code, you will see how to connect... Connect JSP with mysql   
jsp-file
jsp-file  i want to upload a file by browse button and the file should be save in ms access database.....how i can implement trough jsp plz help me sir
applicationcontext.xml properties file
applicationcontext.xml properties file In this tutorial I will explain how you can use the properties defined in .properties file in your spring application... changing the properties file. Suppose you are developing an email sending

Ads