Reference content is as follows: <Html> <Head> <Title> logon </title> <Meta http-equiv = "content-type" content = "text/html; charset = UTF-8"> <Meta http-equiv = "Content-Language" content = "ch-cn"> </Head> <Body> <! -- Form is used to extract information entered and submitted by users --> <Form method = "post" name = "frmLogin" action = "verifylogin. jsp"> <H1 align = "center"> User Logon <Div align = "center"> User Name: <Input type = "text" name = "txtUserName" value = "Your name" Onfocus = "if (this. value = 'your name') this. value =''; "> <br> password: <Input type = "password" name = "txtPassword" value = "Your password" Onfocus = "if (this. value = 'your password') this. value =''; "> <br> <Input type = "submit" name = "Submit" value = "submit"> & nbsp; <Input type = "reset" name = "Reset" value = "reset"> <br> </Div> </form> </body> </Html> Verifylogin. jsp content: <% @ Page language = "java" contentType = "text/html; charset = gb2312" PageEncoding = "UTF-8" %> <% @ Page import = "java. SQL. *" %> <% @ Page import = "java. util. *" %> <! Doctype html public "-// W3C // dtd html 4.01 Transitional // EN"> <Html> <Head> <Title> logon </title> <Meta http-equiv = "pragma" content = "no-cache"> <Meta http-equiv = "cache-control" content = "no-cache"> <Meta http-equiv = "expires" content = "0"> <Meta http-equiv = "keywords" content = "keyword1, keyword2, keyword3"> <Meta http-equiv = "description" content = "This is my page"> <! -- <Link rel = "stylesheet" type = "text/css" href = "styles.css"> --> </Head> <Body> <Div align = center> <% // Obtain the user name String sUserName = request. getParameter ("txtUserName "); // Obtain the password String sPasswd = request. getParameter ("txtPassword "); // Register the JDBC driver Class. forName ("org. gjt. mm. mysql. Driver"). newInstance (); // The Connection parameters are different from the Access parameters. String url = "jdbc: mysql: // localhost/LearnJSP "; // Establish a connection Connection connection = DriverManager. getConnection (url, "root ", "011124 "); // SQL statement String SQL = "select * from userinfo where username = '" + sUserName + "'And userpwd ='" + sPasswd + "'"; Statement stmt = connection. createStatement (); ResultSet rs = stmt.exe cuteQuery (SQL); // return the query result // If the record set is not empty, it indicates that a matched user name and password exist and the logon is successful. If (rs. next ()) { Out. println ("Logon successful! "); } Else // Otherwise, the logon fails. { Out. println ("the user name does not exist or the password is incorrect! "); } Rs. close (); Stmt. close (); Connection. close (); %> </Body> </Html> |