I've been trying to connect this jsp site with MySQL database for a school assignment and I just can't seem to get it to work. It's getting really really frustrating because I have copied my friend's code(which does work on his pc) and for some odd reason it just won't work on my pc!(yes i changed the database names/passwords/table names in the code)
I'm using Tomcat, MySQL front and MySQL server(same as my classmates).
Here's the code:
Code:
<html>
<head><title>Enter to database</title></head>
<body>
<table>
<%@ page import="java.util.*" %>
<%@ page import="javax.sql.*" %>
<%@ page import="java.sql.*" %>
<%@ page import = "java.awt.*" %>
<%@ page import = "java.awt.event.*" %>
<%@ page import = "java.util.*" %>
<%@ page import = "javax.swing.*" %>
<%
String queryString =null;
PreparedStatement statement = null;
Connection connection = null;
ResultSet myData = null;
Object ophalen;
try {
Class.forName("com.mysql.jdbc.Driver");
connection = DriverManager.getConnection
("jdbc:mysql://localhost:3306/friends","root", "root");
queryString = "SELECT * from tableoffriends" ;
statement = connection.prepareStatement(queryString);
myData = statement.executeQuery();
myData.next();
//zet alles in een variable en roep de variable onder op , stayli <%= variable
}
catch(Exception SQLException) {
}
%>
<%= myData.getString(1) %>
<%= myData.getString(2) %>
<%= myData.getString(3) %>
</body>
</html>