home.jsp

来自「test pour j2ee et jsp」· JSP 代码 · 共 23 行

<%@page import="java.sql.*" language="java" %>
<jsp:useBean id="u" class="test.User" />
<%
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://localhost:3306/db";
Connection con=DriverManager.getConnection(url,"root","deye");
Statement s=con.createStatement();
String l=request.getParameter("nom");
String  p=request.getParameter("mdp");
 ResultSet r=s.executeQuery("select * from personne where login='"+l+"' and pwd='"+p+"'");
if(r.next()){%>
Bienvenue 
<%}
else 
{%>
Votre mot de passe est errone
<%}
r.close();
con.close();
%>