• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1116
  • Last Modified:

Need Help with jsp in Eclipse talking to MySQL database

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
sscotti
Asked:
sscotti
1 Solution
 
contactkarthiCommented:
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
 
sscottiAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now