<%@ page language="java" import="java.sql.*" import="java.util.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>testando banco de dados</title>
</head>
<body>
<p>TESTE</p>
<p> </p>
<p>
<%!
private int erro = 0;
%>
<%
try{
String driverName = "org.gjt.mm.mysql.Driver";
Class.forName(driverName);
try{
String url = "jdbc:mysql://localhost/test";
Connection con =
DriverManager.getConnection(url,
"root", "admin");
Statement s = con.createStatement();
String sql = "SELECT * FROM test";
ResultSet rs = s.executeQuery(sql);
if(rs.next()) {
rs.close();
out.println("ok");
}
s.close();
con.close();
}
catch (SQLException e){
out.println(e.toString());
}
catch (Exception e){
out.println(e.toString());
e.printStackTrace();
}
}
catch(ClassNotFoundException e){
out.println(e.toString() + " erro ");
}
%>
<%= ++ erro %>
</p>
<form id="form1" name="form1" method="get" action="">
<label for="textfield"></label>
</form>
</body>
</html>
uso o tomcat.
nas variáveis de ambiente só tem uma que eu criei que é essa
CLASSPATH C:\mysql-connector-java-5.1.6-bin
Desde já agradeço
