JSP (Tomcat) MYSQL Connection.
MySQL Connector JAR herunterladen:mysql-connector-java-5.0.8-bin.jar Datei kopieren und zu Tomcat lib einfügen.(Tomcat 6 --> lib, Tomcat 5.5 --> common --> lib) Tomcat neu Start |
||
als JSP Datei speichern |
||
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<html>
<head>
<title>Connection with mysql database</title>
</head>
<body>
<h1>Tomcat MYSQL</h1>
<%
/********* declare Variablen BEG ********/
String SP1;
String SP2;
/********* declare Variablen END ********/
/********* connection BEG ********/
String connectionURL = "jdbc:mysql://localhost:3306/test";
Connection connection = null;
Class.forName("com.mysql.jdbc.Driver").newInstance();
connection = DriverManager.getConnection(connectionURL, "user", "password");
/********* connection END ********/
/********* check connection and exception BEG ********/
try{
out.println("<font size='+2' color='green'></b>");
out.println("Successfully connected<br><br>");
out.println("</font>");
/********* BODY BEG ********/
out.println("<table border=1>");
out.println("<tr><th>Spalte1</th><th>Spalte2</th></tr>");
Statement sqlStatement = connection.createStatement();
// Generate the SQL query.
String query = "SELECT Spalte1, Spalte2 FROM Tabelle;";
// Get the query results and display them.
ResultSet sqlResult = sqlStatement.executeQuery(query);
while(sqlResult.next())
{
SP1 = sqlResult.getString("Spalte1");
SP2 = sqlResult.getString("Spalte2");
out.println("<tr><td>" + SP1 + "</td><td>" + SP2 + "</td></tr>");
}
/********* BODY BEG ********/
/********* close all BEG ********/
connection.close();
sqlResult.close();
sqlStatement.close();
/********* close all BEG ********/
}
catch(Exception ex){
out.println("<font size='+2' color='red'></b>");
out.println("DB QUERY ERROR");
out.println("</font>");
return;
}
/********* check connection and exception END ********/
%>
</table>
</body>
</html>
|
||