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

Ads
 

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
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
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
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 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 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
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
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
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
Java Properties File Example
  Using Properties files Java   Stets to use a properties files... file into the program. 4. Finally get the text using the key of the properties file. An example of using the properties file and changing the caption French
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 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
Properties file in Java
the properties file to store the configurable values like database connection string... Properties file in Java       In this section, you will know about the properties file
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
passing .properties file as a parameter to another function
passing .properties file as a parameter to another function  passing .properties file as a parameter to another function in an jsp file
passing .properties file as a parameter to another function
passing .properties file as a parameter to another function  passing .properties file as a parameter to another function in an jsp file
passing .properties file as a parameter to another function
passing .properties file as a parameter to another function  passing .properties file as a parameter to another function in an jsp file
passing .properties file as a parameter to another function
passing .properties file as a parameter to another function  passing .properties file as a parameter to another function in an jsp file
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
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
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
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
neo4j-server.properties file location
neo4j-server.properties file location  Hi, Where is the location of neo4j-server.properties file in Linux? Thanks   Hi, Location of neo4j-server.properties file: This file is present in /etc/neo4j directory of linux
Using Network Address To Connect to a Database
.style1 { text-align: center; } How To Use Network Address To Connect... to connect a MySql database with your application over a network then you must load... is "root" An example of using network address to connect to database
struts2 properties file
struts2 properties file  How to set properties file in struts 2 ?   Struts 2 Format Examples Struts 2 Tutorial
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 a web page to a database
connect a web page to a database  how to connect a web page to a database
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

Ads