Global MySQL Con String for JSP files

1,584 Expert 1GB

I need to put the connection string in a global file.because again and again i cant edit the lines. if there is Global file how can call for it.in php i can use [PHP]require 'dbconfle.php' ;[/PHP]

Like wise what is for JSP.

Then only thing i have to do just change a single file.Any Ideas? Here is the Current code.

Expand|Select|Wrap|Line Numbers

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

<%

        String driver = "org.gjt.mm.mysql.Driver";

        Class.forName(driver).newInstance();
 
        Connection con=null;

        ResultSet rst=null;
 
        Statement stmt=null;
 
    try

    {

        String url="jdbc:mysql://localhost/books?user=root&password=dba";

        con=DriverManager.getConnection(url);

        stmt=con.createStatement();

    }

    catch(Exception e)

    {

            System.out.println(e.getMessage());

    }
 
    if(request.getParameter("action") != null)

    {  
 
      String bookname=request.getParameter("bookname");

      String author=request.getParameter("author");
 
      stmt.executeUpdate("insert into books_details(book_name,author) values('"+bookname+"','"+author+"')");
 
      rst=stmt.executeQuery("select * from books_details");
 
      %>
 
<html>

   <body>

   <center><h2>Books List</h2>

   <table border="1" cellspacing="0" cellpadding="0">
 
      <tr><td><b>S.No</b></td><td><b>Book Name</b></td><td><b>Author</.b></td></tr>

      <%

          int no=1;
 
            while(rst.next()){
 
      %>
 
            <tr><td><%=no%></td><td><%=rst.getString("book_name")%></td><td><%=rst.getString("author")%></td></tr>
 
      <%    

            no++;

            }
 
             rst.close();

             stmt.close();

             con.close();
 
        %>

        <tr>

   </table>

   </center>

   <body>

<html>

<%}else{%>
 
<html>

        <head>

        <title>Book Entry FormDocument</title>
 
         <script language="javascript">

            function validate(objForm){
 
                if(objForm.bookname.value.length==0){

                    alert("Please enter  Book Name!");

                    objForm.bookname.focus();

                    return false;

                }
 
                if(objForm.author.value.length==0){

                    alert("Please enter Author name!");

                    objForm.author.focus();

                    return false;

                }
 
                return true;

            }

          </script>
 
        </head>

        <body><center>

        <form action="BookEntryForm.jsp" method="post" name="entry" onSubmit="return validate(this)">

        <input type="hidden" value="list" name="action">

        <table border="1" cellpadding="0" cellspacing="0">

            <tr>

                <td>

                    <table>

                        <tr><td colspan="2" align="center"><h2>Book Entry Form</h2></td></tr>

                        <tr><td colspan="2">&nbsp;</td></tr>

                        <tr><td>Book Name:</td><td><input name="bookname" type="text" size="50"></td></tr>

                        <tr><td>Author:</td><td><input name="author" type="text" size="50"></td></tr>

                        <tr><td colspan="2" align="center"><input type="submit" value="Submit"></td></tr>

                    </table>

                </td>

            </tr>

        </table>

        </form>

        </center>
 
        </body>

  </html>
 
<%}%>

Mar 28 '07 #1

Subscribe Post Reply

2203

r035198x

13,262

8TB

I need to put the connection string in a global file.because again and again i cant edit the lines. if there is Global file how can call for it.in php i can use [PHP]require 'dbconfle.php' ;[/PHP]

Like wise what is for JSP.

Then only thing i have to do just change a single file.Any Ideas? Here is the Current code.

Expand|Select|Wrap|Line Numbers

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

<%

        String driver = "org.gjt.mm.mysql.Driver";

        Class.forName(driver).newInstance();

        Connection con=null;

        ResultSet rst=null;

        Statement stmt=null;

    try

    {

        String url="jdbc:mysql://localhost/books?user=root&password=dba";

        con=DriverManager.getConnection(url);

        stmt=con.createStatement();

    }

    catch(Exception e)

    {

            System.out.println(e.getMessage());

    }

    if(request.getParameter("action") != null)

    {

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

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

      stmt.executeUpdate("insert into books_details(book_name,author) values('"+bookname+"','"+author+"')");

      rst=stmt.executeQuery("select * from books_details");

      %>

<html>

   <body>

   <center><h2>Books List</h2>

   <table border="1" cellspacing="0" cellpadding="0">

      <tr><td><b>S.No</b></td><td><b>Book Name</b></td><td><b>Author</.b></td></tr>

      <%

          int no=1;

            while(rst.next()){

      %>

            <tr><td><%=no%></td><td><%=rst.getString("book_name")%></td><td><%=rst.getString("author")%></td></tr>

      <%

            no++;

            }

             rst.close();

             stmt.close();

             con.close();

        %>

        <tr>

   </table>

   </center>

   <body>

<html>

<%}else{%>

<html>

        <head>

        <title>Book Entry FormDocument</title>

         <script language="javascript">

            function validate(objForm){

                if(objForm.bookname.value.length==0){

                    alert("Please enter  Book Name!");

                    objForm.bookname.focus();

                    return false;

                }

                if(objForm.author.value.length==0){

                    alert("Please enter Author name!");

                    objForm.author.focus();

                    return false;

                }

                return true;

            }

          </script>

        </head>

        <body><center>

        <form action="BookEntryForm.jsp" method="post" name="entry" onSubmit="return validate(this)">

        <input type="hidden" value="list" name="action">

        <table border="1" cellpadding="0" cellspacing="0">

            <tr>

                <td>

                    <table>

                        <tr><td colspan="2" align="center"><h2>Book Entry Form</h2></td></tr>

                        <tr><td colspan="2"> </td></tr>

                        <tr><td>Book Name:</td><td><input name="bookname" type="text" size="50"></td></tr>

                        <tr><td>Author:</td><td><input name="author" type="text" size="50"></td></tr>

                        <tr><td colspan="2" align="center"><input type="submit" value="Submit"></td></tr>

                    </table>

                </td>

            </tr>

        </table>

        </form>

        </center>

        </body>

  </html>

<%}%>

You can store the String as an Attribute or in the session

Mar 28 '07 #2

ak1dnar

1,584

Expert 1GB

If its only way to do it I'll give it a try.Thanks.
Can i make this by using a bean class.

Mar 28 '07 #3

Similar topics

MySQL tips that I have come across

by: Mike Chirico | last post by:

Interesting Things to Know about MySQL Mike Chirico (mchirico@users.sourceforge.net) Copyright (GPU Free Documentation License) 2004 Last Updated: Mon Jun 7 10:37:28 EDT 2004 The latest...

MySQL Database

Problem connecting to remote MySQL DB from VB6

by: Ian Davies | last post by:

Hello all The following code allows me to connect to a local MySQL database on my pc from a VB6 project. **************************************************************************** ** Dim...

MySQL Database

Can't get Global.asax to execute Sub

by: tshad | last post by:

I have an example I copied from "programming asp.net" (o'reilly) and can't seem to get the Sub (writefile) to execute. It displays all the response.write lines that are called directly, but not...

ASP.NET

Need info, books, articles,code, etc: Access VBA to XML to/from MySQL via HTTP

by: Cheryl Langdon | last post by:

Hello everyone, This is my first attempt at getting help in this manner. Please forgive me if this is an inappropriate request. I suddenly find myself in urgent need of instruction on how to...

Microsoft Access / VBA

110

MyISAM engine: worst case scenario in case of crash (mysql, O/S,hardware, whatever)

by: alf | last post by:

Hi, is it possible that due to OS crash or mysql itself crash or some e.g. SCSI failure to lose all the data stored in the table (let's say million of 1KB rows). In other words what is the worst...

MySQL Database

Best way to implement static global variables (in an extension)

by: Jarle Aase | last post by:

Hi, I wrote a multilanguage cms system a few years ago. Different languages are handled by loading php-files where each language-specific string is assigned to a normal php-variable ($LNG...

PHP

Error in global.cs file

by: arun1985 | last post by:

In the project i am using i am having the following code and when i upload it to the server.Its givig me the following error in the global.cs file. Server Error in '/' Application. ...

.NET Framework

I am totally stumped..with this on..LOAD_FILE Mysql+PHP= FSCK!!

by: The Natural Philosopher | last post by:

This is so weird. What I am trying to do is to upload files and stuff them in a mysql database. Everything works except the file content is zero. using the load_file command from mysql...

PHP

Problem in connecting mysql with java-Reply Needed Urgently

by: Ananthu | last post by:

Hi I have done all the codings part for connecting mysql server with java application but when i try to compile,the compilation is successful and during execution i get the following message, ...

Java

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing