<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<%@page import="java.sql.*"%>
<%@page import="java.text.*"%>
<%@page import="java.util.*"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Liste des matieres</title>
</head>
<body>
<h1 align="center">Liste des personnes</h1>
<table align="center" bordercolor="#008080" border="1">
<tr><td bgcolor="#E6FFE6" align="center">Num</td>
<td bgcolor="#E6FFE6" align="center">Libelle</td>
<td bgcolor="#E6FFE6" align="center">Coeffient</td>
<td></td>
</tr>
<%
String num=request.getParameter("txtnum");
int n=Integer.parseInt("num");
%> <%
String url="jdbc:odbc:personne";
String driver="sun.jdbc.odbc.JdbcOdbcDriver";
Class.forName(driver).newInstance();
Connection conn=DriverManager.getConnection(url,"","");
Statement stat=conn.createStatement();
// ResultSet rs=stat.executeQuery("select * from personne where nom like '%"+request.getParameter("txtnom")+"%'");
ca marche
ResultSet rs=stat.executeQuery("select * from personne where code="+n+""); %>
// pour integer ca marche plus
<% while(rs.next()){%>
<tr>
<td align="center"><%=rs.getInt(1)%></td>
<td align="center"><%=rs.getString(2)%></td>
<td align="center"><%=rs.getDate(3)%></td>
</tr>
<% conn.close();}%>
</table>
</body>
</html>
Partager