Ad:

JSP Discussion Thread
Unsolved
Views: 598

Aug 19th, 2009

JSP - Database problem

Expand Post »

Before you killing me, I know about the:
http://www.daniweb.com/forums/thread141776.html , but for the moment, I DON"T have the time.

Secondly, I'm new to Java platform and JSP.

I'm trying to make a simple application, but I don't get it.

I'm using Intellij 8, Tomcat 6, MySQL

I have a java class which makes the connection with the database and a jsp file, but is not working.

The java file:

JSP Syntax (Toggle Plain Text)
package com.packages;
 
import java.sql.*;
 
public class conexiune
{
    String URL = "jdbc:mysql://localhost:3306/agenda";
    String user = "root";
    String pass = "root";
    Connection con;
    Statement stat;
    PreparedStatement pre;
    ResultSet res;
 
 
	public void creeaza()
	{
		try
		{
			Class.forName("com.mysql.jdbc.Driver");
			con = DriverManager.getConnection(URL, user, pass);
		}
		catch(Exception ex)
        {
 
        }
	}
 
	public void inchide()
	{
		try
		{
			con.close();
		}
		catch(Exception ex)
        {
 
        }
	}
 
 
	public ResultSet interogheaza(String sql)
	{
		try
		{
			stat = con.createStatement();
			res = stat.executeQuery(sql);
			return res;
		}
		catch(Exception ex)
		{
			return null;
		}
	}
 
	public ResultSet interogheazaPrepared(String Sql, String Sql2)
	{
		try
		{
			pre = con.prepareStatement(Sql);
            pre.setString(1, Sql2);
            res = pre.executeQuery ();
            return res;
		}
		catch(Exception ex)
		{
			return null;
		}
	}
}
package com.packages;

import java.sql.*;

public class conexiune
{
    String URL = "jdbc:mysql://localhost:3306/agenda";
    String user = "root";
    String pass = "root";
    Connection con;
    Statement stat;
    PreparedStatement pre;
    ResultSet res;


	public void creeaza()
	{
		try
		{
			Class.forName("com.mysql.jdbc.Driver");
			con = DriverManager.getConnection(URL, user, pass);
		}
		catch(Exception ex)
        {
            
        }
	}

	public void inchide()
	{
		try
		{
			con.close();
		}
		catch(Exception ex)
        {

        }
	}
 

	public ResultSet interogheaza(String sql)
	{
		try
		{
			stat = con.createStatement();
			res = stat.executeQuery(sql);
			return res;
		}
		catch(Exception ex)
		{
			return null;
		}
	}

	public ResultSet interogheazaPrepared(String Sql, String Sql2)
	{
		try
		{
			pre = con.prepareStatement(Sql);
            pre.setString(1, Sql2);
            res = pre.executeQuery ();
            return res;
		}
		catch(Exception ex)
		{
			return null;
		}
	}
}

The JSP file:

JSP Syntax (Toggle Plain Text)
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ page import="java.sql.*" %>
<jsp:useBean id="conex" scope="page" class="com.packages.conexiune" />
 
<html>
    <head>
        <title>
            Lista contactelor
        </title>
 
        <SCRIPT LANGUAGE="JavaScript">
 
        </SCRIPT>
    </head>
 
    <body>
 
 
 
        <form name="form" action="index.jsp" method="get">
            Cautare
            <input name="cauta" type="text">
            <input type="submit" name="nume" value="Nume">
            <input type="submit" name="oras" value="Oras">
        </form>
        <form name="form" action="afisare.jsp" method="get">
 
 
            <table border="0" cellspacing=0 width="100%">
                <tr>
                    <th>Lista contactelor</th>
 
                </tr>
            </table>
            <br/>
 
            <table border="1" cellspacing=0 width="100%">
                <tr>
                    <th>Nr. crt.</th>
                    <th>Nume</th>
                    <th>Prenume</th>
                    <th>Adresa</th>
                    <th>Zip</th>
                    <th>Oras</th>
                    <th>Telefon</th>
                    <th>Civila</th>
                    <th>Nr. copii</th>
                    <th>Adresa mail</th>
                </tr>
 
 
                <%
 
                    conex.creeaza();
                    int i = 1;
                    ResultSet res;
                    res = conex.interogheaza("SELECT * from adresa");
                    while (res.next())
                    {
                %>
                <tr>
 
                    <td align="center"> <input type="radio" name="punct" checked="checked" value="<%=res.getString("id") %>"><%=i %></td>
                    <td align="center"><%=res.getString("Nume") %></td>
                    <td align="center"><%=res.getString("Prenume")%></td>
                    <td align="center"><%=res.getString("Adresa")%></td>
                    <td align="center"><%=res.getString("Cod_Zip")%></td>
                    <td align="center"><%=res.getString("Oras")%></td>
                    <td align="center"><%=res.getString("Nr_telefon")%></td>
                    <td align="center"><%=res.getString("Stare_civila")%></td>
                    <td align="center"><%=res.getString("Nr_copii")%></td>
                    <td align="center"><%=res.getString("Adresa_Mail")%></td>
                    <%
                        i++; 
                     }
                    %>
                </tr>
 
            </table>
 
            <br/>
            <input type="submit" name="adaug"   value="Adauga">
            <input type="submit" name="modific" value="Modifica" >
            <input type="submit" name="sterg"   value="Sterge" onclick="return confirm('Doriti stergerea persoanei selectate?');" />
 
        </form>  </body>
</html>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ page import="java.sql.*" %>
<jsp:useBean id="conex" scope="page" class="com.packages.conexiune" />

<html>
    <head>
        <title>
            Lista contactelor
        </title>

        <SCRIPT LANGUAGE="JavaScript">

        </SCRIPT>
    </head>

    <body>



        <form name="form" action="index.jsp" method="get">
            Cautare
            <input name="cauta" type="text">
            <input type="submit" name="nume" value="Nume">
            <input type="submit" name="oras" value="Oras">
        </form>
        <form name="form" action="afisare.jsp" method="get">


            <table border="0" cellspacing=0 width="100%">
                <tr>
                    <th>Lista contactelor</th>

                </tr>
            </table>
            <br/>

            <table border="1" cellspacing=0 width="100%">
                <tr>
                    <th>Nr. crt.</th>
                    <th>Nume</th>
                    <th>Prenume</th>
                    <th>Adresa</th>
                    <th>Zip</th>
                    <th>Oras</th>
                    <th>Telefon</th>
                    <th>Civila</th>
                    <th>Nr. copii</th>
                    <th>Adresa mail</th>
                </tr>


                <%
                
                    conex.creeaza();
                    int i = 1;
                    ResultSet res;
                    res = conex.interogheaza("SELECT * from adresa");
                    while (res.next())
                    {
                %>
                <tr>

                    <td align="center"> <input type="radio" name="punct" checked="checked" value="<%=res.getString("id") %>"><%=i %></td>
                    <td align="center"><%=res.getString("Nume") %></td>
                    <td align="center"><%=res.getString("Prenume")%></td>
                    <td align="center"><%=res.getString("Adresa")%></td>
                    <td align="center"><%=res.getString("Cod_Zip")%></td>
                    <td align="center"><%=res.getString("Oras")%></td>
                    <td align="center"><%=res.getString("Nr_telefon")%></td>
                    <td align="center"><%=res.getString("Stare_civila")%></td>
                    <td align="center"><%=res.getString("Nr_copii")%></td>
                    <td align="center"><%=res.getString("Adresa_Mail")%></td>
                    <%
                        i++; 
                     }
                    %>
                </tr>

            </table>

            <br/>
            <input type="submit" name="adaug"   value="Adauga">
            <input type="submit" name="modific" value="Modifica" >
            <input type="submit" name="sterg"   value="Sterge" onclick="return confirm('Doriti stergerea persoanei selectate?');" />

        </form>  </body>
</html>

When I'm trying to run the app, I receive this error:

Quote ...

org.apache.jasper.JasperException: An exception occurred processing JSP page /index.jsp at line 65

62: int i = 1;
63: ResultSet res;
64: res = conex.interogheaza("SELECT * from adresa");
65: while (res.next())
66: {
67: %>
68: <tr>

Similar Threads

JSP connection to database in JSP
JSP, database problem (Urgent) in JSP
JSP database connectivity according to Model View Controller (MVC) Model 2 in JSP
Sending data from a JSP to javaBean that then enters into Access database in JSP
picture saving in database. problem in Visual Basic 4 / 5 / 6

TryingToDo

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

4 posts
since Aug 2009

Permalink

Aug 19th, 2009

Re: JSP - Database problem

i dont know mysql..

but with toad. you have to open toad for oracle. then click on tnsnames editor. then click on orcl.

there is something called host= something, port="number" and servicename=something

"jdbc:mysql://something:number/something";

you have to replace those. plus also the user pass you have to put the username and password for the database. how do you enter your sql? you type a username and password. you have to put thoser two.

hajjo

Reputation Points: 10

Solved Threads: 0

Junior Poster

Offline

101 posts
since Mar 2008

Permalink

Aug 20th, 2009

Re: JSP - Database problem

There are quite a few things I would like to tell you in this post:-

Firstly never ever use the root account in mysql, apart from for performing administrative tasks.
Telling that you do not have the time for following Good Design (and following MVC) is like telling you don't have the time to do any research before spending millions on buying a lavish new sports car, eventually you are going to regret it.
Your catch blocks are not only for show, or just to stop the compiler from complaining of uncaught exceptions, they are there so that you handle those exceptional situations by writing contingency plans there or at least print a simple stack trace of the exception so that you can signal yourself or the rest of the program of problems like not able to establish a database connection etc.
Next is follow consistent indentation, if not for anyone else, it will ultimately aid you in reading your own code.
Do not return a ResultSet directly from a function, a ResultSet requires that its associated database connection be open throughout the time the ResultSet is needed, Use a CachedRowSet in case you have to return a ResultSet, or the best approach would be what Peter followed in the MVC thread.

Last edited by stephen84s; Aug 20th, 2009 at 5:01 am.

stephen84s

Featured Poster

Reputation Points: 653

Solved Threads: 151

Nearly a Posting Virtuoso

Offline

1,316 posts
since Jul 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in JSP Forum Timeline: cant access servlet context object

Next Thread in JSP Forum Timeline: Jsp with Microsoft Sql Server

DaniWeb Message

Cancel Changes

User Name
Password