Login Port
<%@ page language= "java" contenttype= "text/html; Charset=utf-8 " pageencoding=" UTF-8 "%><! DOCTYPE HTML PUBLIC "-//w3c//dtd HTML 4.01 transitional//en" "Http://www.w3.org/TR/html4/loose.dtd" >card number:<input type=" text "name=" cardid1 "><br> password:<input type= "Password" name= "Password1" ><br><input type= "submit" value= "Login" ></form>></body >
Connection request Side
<% @pageImport= "Com.web.cardDAO"%><%@ page language= "java" contenttype= "text/html; Charset=utf-8 "pageencoding= "UTF-8"%><! DOCTYPE HTML PUBLIC "-//w3c//dtd HTML 4.01 transitional//en" "Http://www.w3.org/TR/html4/loose.dtd" >String Cardid=request.getparameter ("Cardid1"); String Password=request.getparameter ("Password1");if(cardid==NULL|| password==NULL|| Cardid.equals ("") | | Password.equals ("") {out.write ("Please log into the system correctly");}Else{ //Check login InformationCarddao cd=NewCarddao (); if(Cd.checklogin (cardid, password)) {Out.write ("Login Successful"); } Else{out.write ("Login Failed"); }}%></body>Java code class
Package Com.web;import Java.sql.connection;import Java.sql.preparedstatement;import java.sql.resultset;import Java.sql.sqlexception;import Com.mchange.v2.c3p0.combopooleddatasource;public class CardDAO {ComboPooledDataSource Cpd=new Combopooleddatasource ("helloc3p0");p ublic boolean checklogin (String cardid,string password) {Boolean boo= false;try {Connection conn=cpd.getconnection (); PreparedStatement ps=conn.preparestatement ("SELECT * from bank where ba_card=?") and ba_password=? "); Ps.setstring (1, Cardid);p s.setstring (2, password); ResultSet rs=ps.executequery (); Boo=rs.next (); Rs.close ();p s.close (); Conn.close (); Cpd.close ();} catch (SQLException e) {//TODO auto-generated catch block E.printstacktrace ();} return boo;}}
Java EE Connection Database exercises