JDBC连接数据库

LoginBean 

package com.mvc.bean;

public class LoginBean {
	private int id;
	private String UserName;
	private String PassWord;
	public String getUserName() {
		return UserName;
	}
	public void setUserName(String userName) {
		UserName = userName;
	}
	public String getPassWord() {
		return PassWord;
	}
	public void setPassWord(String passWord) {
		PassWord = passWord;
	}
}

LoginControl 

package com.mvc.control;

import com.mvc.bean.LoginBean;
import com.mvc.dao.LoginDao;

public class LoginControl {

	public void Login(String name, String pwd) 
	{
		LoginBean loginBeanInput = new LoginBean(); // Bean classes are efficiently used to access user information wherever required in the application.

        loginBeanInput.setUserName(name);
        loginBeanInput.setPassWord(pwd);
        LoginDao loginDao = new LoginDao();

        String userValidate = loginDao.authenticateUser(loginBeanInput);
        if(userValidate.equals("SUCCESS")){
            System.out.print("SUCCESSyes");
        } 

        else{
            System.out.print("SUCCESSno");
        }
	}
	
	public void InsertUser()
	{
		LoginDao loginDao = new LoginDao();
		loginDao.InsertUser();
		System.out.print("SUCCESInsert");
	}
}

LoginDao 
 

package com.mvc.dao;


import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import com.mvc.bean.LoginBean;
import com.mvc.util.DBConnection;
import com.mysql.jdbc.Connection;


public class LoginDao {


    public String authenticateUser(LoginBean loginBeanInput) {

        String userNameInput = loginBeanInput.getUserName(); //Keeping user entered values in temporary variables.
        String passwordInput = loginBeanInput.getPassWord();

        Connection con = null;
        Statement statement = null;
        ResultSet resultSet = null;

        String userNameDB = "";
        String passwordDB = "";

        try {
            con = DBConnection.createConnection(); //establishing connection
            statement = con.createStatement(); //Statement is used to write queries.
            resultSet = statement.executeQuery("SELECT userName,password FROM hello.usres");


            // Until next row is present otherwise it return false
            while (resultSet.next()){

                userNameDB = resultSet.getString("userName"); //fais attention c'est les valeurs du DB
                passwordDB = resultSet.getString("password");

                if (userNameInput.equals(userNameDB) && passwordInput.equals(passwordDB)) {
                    return "SUCCESS";
                }
            }



        } catch (SQLException e) {
            e.printStackTrace();
        }
        System.out.print("Invalid user credentials");
        return "Invalid user credentials";

    }
    
    public void InsertUser() {
        // 1.获取数据库连接
        Connection con = null;
        // 4.执行插入
        // 4.1 获取操作SQL语句的Statement对象：
        // 调用Connection的createStatement()方法来创建Statement的对象
        Statement statement = null;

        ResultSet resultSet = null;
        try {
        	con = DBConnection.createConnection(); //establishing connection
            statement = con.createStatement(); //Statement is used to write queries.

            // 3.准备插入的SQL语句
            String sql = "insert into usres(UserName,PassWord) values('小敏','123')";

            statement = con.createStatement();

            // 4.2 调用Statement对象的executeUpdate(sql) 执行SQL 语句的插入
            statement.executeUpdate(sql);
        } catch (SQLException e) {
            e.printStackTrace();
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            // 5.关闭Statement对象
            if (statement != null) {
                try {
                    statement.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
            if (con != null) {
                // 2.关闭连接
                try {
                    con.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
        }
    }
}

 DBConnection 

package com.mvc.util;

import java.sql.DriverManager;
import java.sql.SQLException;

import com.mysql.jdbc.Connection;

public class DBConnection {

	 public static Connection createConnection(){
	        Connection con = null;
	        String url = "jdbc:mysql://localhost:3306/hello?useUnicode=true&characterEncoding=utf8"; 
	        String username = "root";
	        String password = "";


	        try {

	            Class.forName("com.mysql.jdbc.Driver"); //loading mysql driver
	            con = (Connection) DriverManager.getConnection(url, username, password); //attempting to connect to MySQL database
	            System.out.println("Printing connection object "+con);

	        } catch (ClassNotFoundException e) {
	            e.printStackTrace();
	        }
	        catch (SQLException e) {
	            e.printStackTrace();
	        }



	        return con;
	    }
	    
		/**
		 * 杩炴帴oracle
		 * @return
		 */
 
	
}

LoginView 

package com.mvc.view;

import java.util.Scanner;

import com.mvc.control.LoginControl;

public class LoginView {


	public static void main(String[] args) {
		// TODO Auto-generated method stub\
		System.out.println("请输入用户名和账户密码:");
		Scanner sc = new Scanner(System.in);
		String name = sc.next();
		String pwd = sc.next();
		if (!name.equals("") && !pwd.equals("")) {
			LoginControl lc = new LoginControl();
			lc.Login(name, pwd);
		}
	}
}

Register 

package com.mvc.view;

import com.mvc.control.LoginControl;

public class Register {

	public static void main(String[] args) {
		// TODO Auto-generated method stub
		System.out.println("完成账户注册");
		LoginControl lc = new LoginControl();
		lc.InsertUser();
	}

}