Jsp+servlet+mysql case

Project name ： Personal website system
implementation technique ：jsp+servlet+java+html+css+js;
development tool ：eclipse development environment ：jdk1.8,Tomcat7.0 above .
database ： mysql5.7
Project description ： This project is a website system for personal information description , Have website （ The front desk ） And background management . Have the operation of adding, deleting, modifying and querying , Personal information 、 message management 、 User management has three modules . The database connection is msyqq

Author's words ：

1.jdbcl Connect to database

public class DBUtil {
static String CLASSFORNAME="com.mysql.jdbc.Driver";
  static String SERVANDDB="jdbc:mysql://localhost:3306/person?useUnicode=true&characterEncoding=utf-8";
  static String USER="root";
  static String PWD="123456";
     static{  
         //  Load database driver   
                 try {  
                     Class.forName(CLASSFORNAME);  
                 } catch (ClassNotFoundException e) {  
                     e.printStackTrace();  
                 }  
     }  
       public static Connection getConnection() {  
         Connection conn = null;  
         try {  
             //  Get database connection   
             conn = DriverManager  
                     .getConnection(SERVANDDB,  
                             USER, PWD);  
     }catch (SQLException e) {  
         e.printStackTrace();  
     }   
         return conn;  
     }  
        

2. Login screen

main interface

Message module

If you need source code and information, please follow my wechat official account .