Solved

Need Help with jsp in Eclipse talking to MySQL database

Posted on 2007-11-24
2
1,092 Views
Last Modified: 2013-12-02
I have this skeleton Framework for a jsp server app in Eclipse running tomcat 6.x and external MySQL server.

After some initial tweaking this seems to at least run without errors, suggesting that I am connecting to the database.  I did, however, have to add the following two .jar files to the Referenced Libraries path in my project.  Is it normal to have to do that?  Can I not add these to the eclipse libraries or plug-ins so that I won't have to add them for each application that uses MySQL, and why do I have to add aspectj-1.5.3.jar.  It seems that this is necessary.

mysql-connector-java-5.1.5-bin.jar
aspectj-1.5.3.jar

My main question is:

How can I verify that the database connection is working and what other code can I use to test the driver (i.e. insert, removing, joining, etc).  With the way I have it configured it seems to be connecting but I'm not getting any output despite a non-empty database.

I do have the ability to create and manipulate a database using phpmyadmin or similar tool, so I would appreciate some instructions on how to set up a test database and how to access it via the .jsp page using struts and or java code.

Thanks.
<%@ page language="java" import="java.sql.*" pageEncoding="UTF-8"%>
<%
Class.forName("com.mysql.jdbc.Driver").newInstance(); 
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/confluence","user","pass");
Statement stmt = con.createStatement();  
String query = "SELECT * from content"; 
ResultSet rs = stmt.executeQuery(query); 
System.out.println(rs); 
while (rs.next()) { 
String s = rs.getString("CONTENTTYPE"); 
System.out.println(s); 
}
%>    
<%String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
 
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>My JSP 'index.jsp' starting page</title>
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<meta http-equiv="expires" content="0">    
	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
	<meta http-equiv="description" content="This is my page">
	<!--
	<link rel="stylesheet" type="text/css" href="styles.css">
	-->
  </head>
  
  <body>
    This is my JSP page. <br>
  </body>
</html>

Open in new window

0
Comment
Question by:sscotti
2 Comments
 
LVL 17

Accepted Solution

by:
contactkarthi earned 500 total points
ID: 20355764
instead of System.out.println give out.println so that you can see the output in jsp

here is a link for a good tutorial on Struts
http://www.roseindia.net/struts/
0
 
LVL 5

Author Closing Comment

by:sscotti
ID: 31410830
Not quite what I was looking for but it helped.  I can use the struts reference and I was able to figure it out.  
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
eclipse buid path vs tomcat lib path 10 23
jboss wildfly 10.1 10 92
SELECT query on two levels (detail and summary) 13 50
Java: The Public Class Main 4 16
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
The viewer will learn how to implement Singleton Design Pattern in Java.
This tutorial covers a practical example of lazy loading technique and early loading technique in a Singleton Design Pattern.

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question