Home.... | log in.... | Pub my question! | Sign-up....
Java-index >> Enterprise & Remote Computing >> Web Tier APIs

how does it connect to the database

sorry for the long coding. but can anyone explain to me how the below code connects to the database?is it using beans or anything similar?

thank

<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*" errorPage="" %>

<html><!-- InstanceBegin template="/Templates/biome.dwt.jsp" codeOutsideHTMLIsLocked="false" -->

<head>

<!-- InstanceBeginEditable name="doctitle" -->

<title>Untitled Document</title>

<!-- InstanceEndEditable -->

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

<LINK href="bios.css" type=text/css rel=stylesheet>

<!-- InstanceBeginEditable name="head" --><!-- InstanceEndEditable -->

</head>

<body leftmargin="0" topmargin="0">

<%@ include file="useAndImport.jsp" %>

<%

String username = (String)session.getAttribute("username");

session.setMaxInactiveInterval(10*60);

boolean isLoggedIn=work.isUsable(username)?true:false;

%>

<table height="22" border="0" cellpadding="0" cellspacing="0" bgcolor="#CC3300" class="statusloginsearch">

<tr>

<SCRIPT LANGUAGE="JavaScript">

<!-- Idea by: Nic Wolfe (Nic@TimelapseProductions.com) -->

<!-- Web URL: http://fineline.xs.mw -->

<!-- This script and many more are available free online at -->

<!-- The JavaScript Source!! http://javascript.internet.com -->

<!-- Begin

function popUp(URL) {

day = new Date();

id = day.getTime();

eval("page" + id + " = window.open(URL, '" + id + "', 'toolbar=0,scrollbars=1,location=0,statusbar=0,menubar=0,resizable=0,width=600,height=500');");

}

// End -->

</script>

<form action=loginAction.jsp method=POST>

<td width="77%" valign="baseline" nowrap id="statusbar"> ?<% if (isLoggedIn)

out.println("<img src=images/active.gif width=10 height=15 align=middle><font size=1 color=white face=Verdana, Arial, Helvetica, sans-serif><b>Welcome, " + username + " ?lt;/b></font>");%> <% if (!isLoggedIn) { %>

<font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif">Username:</font><font size="1" face="Verdana, Arial, Helvetica, sans-serif">

<input type=text name=username class="form" ><%= work.getValueAttribute(username) %> >

<font color="#FFFFFF"> Password:</font>

<input type=password name=password class="form">

<input type="submit" name="action" value="Login" class="formbutton" onfocus="this.blur()" onmouseover="this.className='formbuttonover';" onmouseout="this.className='formbutton';" onmousedown="this.className='formbuttonover';" onmouseup="this.className='formbuttonover';">

<input type="reset" name="action" value="Reset" class="formbutton" onfocus="this.blur()" onmouseover="this.className='formbuttonover';" onmouseout="this.className='formbutton';" onmousedown="this.className='formbuttonover';" onmouseup="this.className='formbuttonover';">

<a href="javascript:popUp('membersAccess.jsp')"><img src="images/question.gif" alt="what's this?" width="15" height="15" border="0" align="middle"></a>

<% } %>

</font></td>

</form>

<td width="23%" valign="baseline" nowrap id="statusbar"> <div align="right">

<% if (isLoggedIn)

out.println("<form action=SignOut.jsp method=POST><input type=submit name=action value=Logout class=formbutton onfocus=this.blur() onmouseover=this.className='formbuttonover'; onmouseout=this.className='formbutton'; onmousedown=this.className='formbuttonover'; onmouseup=this.className='formbuttonover';></form>?lt;a href=tour.jsp><img src=images/newtothissite.gif border=0 align=middle></a>");%>

牋</div></td>

</tr>

</table>

<table width="650" border="0" cellspacing="4" cellpadding="1">

<tr>

<td><!-- InstanceBeginEditable name="main" -->

<table width="580" border="0" cellpadding="1">

<tr>

<td><img src="images/sitemap1.gif" width="350" height="28"></td>

</tr>

</table>

<table width="545" border="0" align="center" cellpadding="2" cellspacing="2">

<tr bgcolor="#FFFFFF">

<td colspan="2" align="left" valign="middle"><font color="#CC3300" size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>SC37

Documents</strong></font></td>

<td colspan="2" align="left" valign="middle"><font color="#CC3300" size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Forum</strong></font></td>

</tr>

<tr bgcolor="#FFFFFF">

<td width="32" align="left" valign="middle"></td>

<td width="181" align="left" valign="middle"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><a href="SearchForm.jsp">Documents

Search</a></font></td>

<td width="32" align="left" valign="middle">?lt;/td>

<td width="287" align="left" valign="middle"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><a href="Login.jsp">Log

in</a></font></td>

</tr>

<tr bgcolor="#FFFFFF">

<td align="left" valign="middle">

?lt;/p></td>

<td align="left" valign="middle"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><a href="AdvancedSearch.jsp">Advanced

Search</a></font></td>

<td align="left" valign="middle">

?lt;/p></td>

<td align="left" valign="middle"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><a href="CreateAccountForm.jsp">Create

a new account </a></font></td>

</tr>

<tr bgcolor="#FFFFFF">

<td align="left" valign="middle"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">?lt;/font></td>

<td align="left" valign="middle">?lt;/td>

<td align="left" valign="middle">

?lt;/p></td>

<td align="left" valign="middle"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><a href="search.jsp">Search

for messages</a></font></td>

</tr>

<tr bgcolor="#FFFFFF">

<td colspan="2" align="left" valign="middle"><font color="#CC3300" size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Meetings</strong></font></td>

<td colspan="2"><blockquote><font face="Verdana, Arial, Helvetica, sans-serif"></font></blockquote></td>

</tr>

<tr bgcolor="#FFFFFF">

<td align="left" valign="middle">

<font size="2" face="Verdana, Arial, Helvetica, sans-serif"></font>

</td>

<td align="left" valign="middle"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><a href="Meetings.jsp">Meetings</a></font></td>

<td colspan="2"><font color="#CC3300" size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Contact

</strong></font></td>

</tr>

<tr bgcolor="#FFFFFF">

<td colspan="2" align="left" valign="middle">?lt;/td>

<td>

?lt;/p></td>

<td><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><a href="contact.jsp">Contact</a></font></td>

</tr>

<tr bgcolor="#FFFFFF">

<td colspan="2" align="left" valign="middle"><font color="#CC3300" size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>News

& Events</strong></font></td>

<td colspan="2"><font face="Verdana, Arial, Helvetica, sans-serif">?lt;/font></td>

</tr>

<tr bgcolor="#FFFFFF">

<td align="left" valign="middle">?lt;/td>

<td align="left" valign="middle"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><a href="NewsAndEvents.jsp">News

& Events</a></font></td>

<td colspan="2"><font color="#CC3300" size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Site

Map</strong></font></td>

</tr>

<tr bgcolor="#FFFFFF">

<td align="left" valign="middle">

?lt;/p></td>

<td align="left" valign="middle">?lt;/td>

<td>

?lt;/p></td>

<td><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><a href="sitemap.jsp">Site

Map</a></font></td>

</tr>

<tr bgcolor="#FFFFFF">

<td colspan="2" align="left" valign="middle">

<font color="#CC3300" size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Seminars</strong></font>

</td>

<td colspan="2"><font face="Verdana, Arial, Helvetica, sans-serif">?lt;/font></td>

</tr>

<tr bgcolor="#FFFFFF">

<td align="left" valign="middle"><font face="Verdana, Arial, Helvetica, sans-serif">?lt;/font></td>

<td align="left" valign="middle"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><a href="Seminars.jsp">Seminars</a></font></td>

<td colspan="2"><font color="#CC3300" size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Search

Tips</strong></font></td>

</tr>

<tr bgcolor="#FFFFFF">

<td colspan="2" align="left" valign="middle">?lt;/td>

<td>

?lt;/p></td>

<td><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><a href="SearchTip.jsp">Search

Tips</a></font></td>

</tr>

<tr bgcolor="#FFFFFF">

<td colspan="2" align="left" valign="middle">

<font color="#CC3300" size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Members</strong></font>

</td>

<td colspan="2"><font face="Verdana, Arial, Helvetica, sans-serif">?lt;/font></td>

</tr>

<tr bgcolor="#FFFFFF">

<td align="left" valign="middle"><font face="Verdana, Arial, Helvetica, sans-serif">?lt;/font></td>

<td align="left" valign="middle"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><a href="Login.jsp">Members

Login</a></font></td>

<td colspan="2">?lt;/td>

</tr>

<tr bgcolor="#FFFFFF">

<td colspan="2" align="left" valign="middle">?lt;/td>

<td>?lt;/td>

<td>?lt;/td>

</tr>

</table>

<!-- InstanceEndEditable -->

</td>

</tr>

</table>

</body>

<!-- InstanceEnd --></html>

Message was edited by:

pUnKzT3r

Message was edited by:

pUnKzT3r

[11892 byte] By [pUnKzT3ra] at [2007-10-2 20:04:43]
«« API for performing search in Documents like df,doc,excel etc
»» Confused in store.connect() function
# 1
i didn't see any connection
jgalacambraa at 2007-7-13 22:44:48 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...
# 2
in a way yes?but can the above coding be connected using beans btw, thank for the reply
pUnKzT3ra at 2007-7-13 22:44:48 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...
# 3
in a way yes!.. it can connect to a database but we cannt not know if it is using beans or something to cannect to a database.. there are lot of stuffs to connect ot a database..
jgalacambraa at 2007-7-13 22:44:48 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...
# 4

oh. if i pst the error message i get will u be able to tell me from the above coding how is it connected to the database. anyway thank for replyin.

org.apache.jasper.JasperException: class kw.search.DbAccess : java.sql.SQLException: Invalid authorization specification message from server: "Access denied for user: 'javauser@localhost' (Using password: YES)"

at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:254)

at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)

at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)

at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)

at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)

at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2422)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)

at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)

at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)

at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:163)

at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)

at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)

at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)

at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:199)

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:828)

at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:700)

at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:584)

at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)

at java.lang.Thread.run(Thread.java:595)

pUnKzT3ra at 2007-7-13 22:44:48 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...
# 5

you error says:

org.apache.jasper.JasperException: class kw.search.DbAccess : java.sql.SQLException: Invalid authorization specification message from server: "Access denied for user: 'javauser@localhost' (Using password: YES)"

there are a lot of stuffs going on on your db connection.

1. Maybe invalid username

2. Invalid password.

3. Maybe your logon has no acces to your remote db

jgalacambraa at 2007-7-13 22:44:48 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...
# 6

erm...cos i m continuin someone else project but we are not given the database so we are tryin to create our database to connected to the jsp page. but i was couldn't find the connection to database in the coding. so i was wondering if u can point out the connection to database portion where i can change to other coding rather than using bean which is pretty new to me

pUnKzT3ra at 2007-7-13 22:44:48 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...
# 7

I can't see anything on this page you have posted that would be database connection code.

The error is coming from the class kw.search.DbAccess.

So look for accesses to that class.

Again, there aren't any references on the page but you include this file:

<%@ include file="useAndImport.jsp" %>

Maybe the database connection is defined in the included file?

Check out "useAndImport.jsp" for any references to the DbAccess class.

Cheers,

evnafets

evnafetsa at 2007-7-13 22:44:48 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...
# 8

oh. i have find the useAndImport.jsp but i dunno how to apply. can u kindly teach me how do i apply this to connect to my database. thank

<%-- thingsToUseAndImport.jsp --%>

<jsp:useBean id="db"

class="kw.search.DbAccess"

scope="application"/>

<jsp:useBean id="work"

class="kw.search.Worker"

scope="application"/>

<jsp:useBean id="dataB"

class="bb.messageBoard.DataB"

scope="application"/>

<jsp:useBean id="forum"

class="bb.messageBoard.Forum"

scope="application"/>

<%@ page import="java.text.DateFormat, java.util.Vector, java.io.*" %>

pUnKzT3ra at 2007-7-13 22:44:49 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...
# 9

sorry 1 more thing to do

the following is the DbAcess.java

package kw.search;

import java.sql.*;

public class DbAccess implements java.io.Serializable {

private Connection connection;

private Statement statement;

String db = "btc";

String user = "javauser";

String password = "javauser";

String dbUrl = "jdbc:mysql://localhost:3306/" +db;

//dbUrl = "jdbc:mysql://localhost:3306/"+db;

public DbAccess ()

throws ClassNotFoundException, SQLException

{

Class.forName("com.mysql.jdbc.Driver");

//connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/btc?"+"user=javauser&password=javauser");

connection = DriverManager.getConnection

(dbUrl+"?user="+user+"&password="+password);

connection.setAutoCommit(false);

statement = connection.createStatement();

}

public void executeUpdate(String sqlCommand)

throws SQLException

{

statement.executeUpdate(sqlCommand);

}

public ResultSet executeQuery(String sqlCommand)

throws SQLException

{

return statement.executeQuery(sqlCommand);

}

public void commit() throws SQLException

{

connection.commit();

}

public void rollback() throws SQLException

{

connection.rollback();

}

protected void finalize() throws SQLException

{

statement.close();

connection.close();

}

}

pUnKzT3ra at 2007-7-13 22:44:49 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...
# 10

Ok, as you may have guessed from the name, this class has the database connection code.

It is trying to connect to a MySQL database on the local system, with the username "javauser" and password "javauser"

This corresponds to the message : "Access denied for user: 'javauser@localhost' (Using password: YES)"

- Is there a mysql database installed on this system?

- Is there a user "javauser" with password "javauser" enabled to log in from "localhost"

see the mySQL documentation for details on setting up users in the database. Probably there is no user called "javauser" on this database.

That means you can either

- add a user "javauser"

- change the username password encoded in this file.

- set up a JNDI datasource on your server, and access that instead (thats a whole new kettle of fish)

evnafetsa at 2007-7-13 22:44:49 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...
# 11

erm... i created a database named 'btc' and table named 'users'. then i created insert into the table field 'user' and 'password'. and into them are javauser and javauser but the same problem still occur.

thank for the reply previously

Message was edited by:

pUnKzT3r

pUnKzT3ra at 2007-7-13 22:44:49 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...
Enterprise & Remote Computing
Web Tier APIs

Enterprise & Remote Computing New Topic

Enterprise & Remote Computing Hot Topic

Enterprise & Remote Computing

All Classified