Tableau jsp

<?xml version="1.0" encoding="ISO-8859-1" ?>
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<%@ page import="java.util.Date" %>
<%@ page import=" java.awt.*"%>
<%@ page import=" java.awt.Image"%>
<%@ page import=" javax.swing.*" %>
<%@ page import="java.util.Vector"%>
<%@ page import="java.lang.String"%> 
<%@ page import="java.sql.*" %>



   
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
 
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />

<title>Essai</title>
<script type="text/javascript">

</script>

</head>
<body>
<% 
try {
		Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); 
		 String url="jdbc:sqlserver://10.247.65.71;databaseName=whatsup;integratedSecurity=false";
Connection con = DriverManager.getConnection(url,"sa","xxx");

	Statement requete = con.createStatement();

	ResultSet resultat = requete.executeQuery("select * from Device where nBestStateID=10"); 
	int i=0;
	while(resultat.next())
	{
int numero = resultat.getInt(1);
	String nom = resultat.getString(2);
	out.println(numero + " " +nom);
	
	i++;
	}
	resultat.close();
}




	catch(Exception e1) 
{
	e1.printStackTrace();
	javax.swing.JOptionPane.showMessageDialog(null,e1); 
	
}
		
%>


 <br/>
</body>
</html>