sscotti
asked on
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.
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
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>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER