This article originates from: Http://blog.csdn.net/svitter
Resources Download:
GitHub
git clone https://github.com/Svtter/JSP-tomcat-mysql
I wrote the register and the login in a servlet processing. One with get, one with post, that's not right.
Have time to correct it later. Suppose simply to submit this for the job.
The simple difference between get and post is that post is more secure.
Can look into it in detail.
The servlet is used:
Xml:
<?
XML version= "1.0" encoding= "UTF-8"?
><web-app xmlns:xsi= "http://www.w3.org/2001/XMLSchema-instance" xmlns= "http://xmlns.jcp.org/xml/ns/ Java ee "xsi:schemalocation=" Http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1. XSD "version=" 3.1 "> <display-name>JSP_servlet_javabean</display-name><servlet>< description> configuration for user login servlet</description><display-name>loginservlet</display-name>< servlet-name>loginservlet</servlet-name><servlet-class>loginservlet</servlet-class></ Servlet> <servlet-mapping><servlet-name>loginservlet</servlet-name><url-pattern>/ Loginservlet</url-pattern></servlet-mapping><welcome-file-list> <welcome-file> Login.html</welcome-file> </welcome-file-list></web-app>
Four Java files:
loginservlet.java://for verification:
Import Java.io.*;import Javax.servlet.*;import Javax.servlet.http.httpservlet;import Javax.servlet.http.httpservletrequest;import Javax.servlet.http.httpservletresponse;import Bean. Connectionbean;import bean.userbean;/** * @author svitter * */@SuppressWarnings ("Serial") public class Loginservlet Extends HttpServlet {UserBean user = new UserBean (); Connectionbean Connbean = new Connectionbean ();p ublic void DoPost (HttpServletRequest request, HttpServletResponse Response) throws Servletexception, IOException {String checklogin; String username = request.getparameter ("login"); String Password = request.getparameter ("password"); Checklogin = connbean.checkuser (username, password); if ( Checklogin.equals ("Success")) {User.setusername (username); Request.setattribute ("User", user); Getservletconfig (). Getservletcontext (). Getrequestdispatcher ("/loginsuccess.jsp"). Forward (request, response);} else {request.setattribute ("Checklogin", Checklogin), Getservletconfig (). Getservletcontext (). Getrequestdispatcher ("/logincheck.jsp "). Forward (request, response);} public void doget (HttpServletRequest request, httpservletresponse response) throws Servletexception, ioexception{ String username = request.getparameter ("login"); String Password = request.getparameter ("password"); Connbean.adduser (username, password); Getservletconfig (). Getservletcontext (). Getrequestdispatcher ("/login.html"). Forward (request, response);}}
Bean. The getconnection.java://is used to connect to the database. Database configuration file property.conf
Package Bean;import java.io.*;import java.util.properties;import java.sql.*;p ublic class Getconnection {private static Properties P;static{try{p = new properties (); InputStream is = GetConnection.class.getResourceAsStream ("property.conf" );p. Load (IS); Is.close ();} catch (Exception e) {e.printstacktrace ();}} public static string GetProperty (String key) {return P.getproperty (key);} static string driver = Getconnection.getproperty ("driver"); static string url = Getconnection.getproperty ("url"); String name = Getconnection.getproperty ("user"); static string pass = Getconnection.getproperty ("password"); Static{try{class.forname (driver);} catch (ClassNotFoundException e) {e.printstacktrace ();}} public static Connection getconnection () throws SQLException {return drivermanager.getconnection (URL, name, pass);}}
Property.conf:
Driver=com.mysql.jdbc.driverurl=jdbc:mysql://localhost:3306/usersuser=rootpassword=root
Bean. connectionbean.java://for database operations
Package Bean;import java.sql.*;p ublic class Connectionbean {private Connection con;public Connectionbean () {Try{con = Get Connection.getconnection ();} catch (Exception e) {e.printstacktrace ();}} Add information to the database public boolean addUser (string name, string password) {try{preparedstatement pstmt = con.preparestatement (" insert into ur (name, passwd) VALUES (?,?
);p stmt.setstring (1, name);p stmt.setstring (2, password);p stmt.execute (); return true;} catch (Exception e) {e.printstacktrace (); return false;}} Public ResultSet GetUser (String name) {try {Statement stm = Con.createstatement (); ResultSet result = Stm.executequery ("select * from ur where name= '" +name+ "'"); return result; catch (Exception e) {e.printstacktrace (); return null;}} public string CheckUser (string name, String passwd) {string Checkuser=null;try{statement stm = Con.createstatement (); ResultSet result = Stm.executequery ("select * from ur where name= '" +name+ "'"); if (Result.next () ==false) {CheckUser = "No US Er ";} Else{if (result.getstring ("passwd"). Equals (passwd)) {CheckUser = "Success";} Else{checkuser = "wrong passwd";}} catch (Exception e) {e.printstacktrace ();} return checkUser;}}
Jsp_tomcat_mysql_ verification User;