MD5加密实战

MD5加密实战

项目结构：

jar包：

配置文件1： db.prope

db.username=root
db.password=root
db.url=jdbc:mysql://127.0.0.1:3306/test

配置文件2：log4j.properties

# DEBUG\u8BBE\u7F6E\u8F93\u51FA\u65E5\u5FD7\u7EA7\u522B\uFF0C\u7531\u4E8E\u4E3ADEBUG\uFF0C\u6240\u4EE5ERROR\u3001WARN\u548CINFO \u7EA7\u522B\u65E5\u5FD7\u4FE1\u606F\u4E5F\u4F1A\u663E\u793A\u51FA\u6765
log4j.rootLogger=DEBUG,Console,RollingFile

#\u5C06\u65E5\u5FD7\u4FE1\u606F\u8F93\u51FA\u5230\u63A7\u5236\u53F0
log4j.appender.Console=org.apache.log4j.ConsoleAppender
log4j.appender.Console.layout=org.apache.log4j.PatternLayout
log4j.appender.Console.layout.ConversionPattern= [%-5p]-[%d{yyyy-MM-dd HH:mm:ss}] -%l -%m%n
#\u5C06\u65E5\u5FD7\u4FE1\u606F\u8F93\u51FA\u5230\u64CD\u4F5C\u7CFB\u7EDFD\u76D8\u6839\u76EE\u5F55\u4E0B\u7684log.log\u6587\u4EF6\u4E2D
log4j.appender.RollingFile=org.apache.log4j.DailyRollingFileAppender
log4j.appender.RollingFile.File=D://log.log
log4j.appender.RollingFile.layout=org.apache.log4j.PatternLayout
log4j.appender.RollingFile.layout.ConversionPattern=%d [%t] %-5p %-40.40c %X{traceId}-%m%n

工具类：

IRowMapper接口：

package com.jd.tool.db;

import java.sql.ResultSet;

public interface IRowMapper {
	void rowMapper(ResultSet rs);
}

MD5Tool加密工具类：

package com.jd.tool;

import java.math.BigInteger;
import java.security.MessageDigest;

public class MD5Tool {
	
	public static String encrypt(String password) {
		byte[] bytes = null;
		try {
			MessageDigest messageDigest = MessageDigest.getInstance("MD5");
			messageDigest.update(password.getBytes());//加密
			bytes = messageDigest.digest();//获得加密结果
		} catch (Exception e) {
			e.printStackTrace();
		}
		
		String result = new BigInteger(1, bytes).toString(16);// 将加密后的数据转换为16进制数字
		// 生成数字未满32位，则前面补0
		for (int i = 0; i < 32 - result.length(); i++) {
			result = "0" + result;
		}
		return result;
	}
}

Propeties工具类：

package com.jd.tool;

import java.io.IOException;
import java.io.InputStream;
import java.util.Properties;

public class PropertiesTool {
	
	private static Properties properties=new Properties();
	
		static {
			InputStream inputStream=PropertiesTool.class.getClassLoader().getResourceAsStream("db.properties");//将db.properties变为IO流
			try {
				properties.load(inputStream);
			} catch (IOException e) {
				e.printStackTrace();
			}
		}
	public static String getValue(String key) {
		return properties.getProperty(key);
	}
}

DBLink工具类：

package com.jd.tool.db;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import org.apache.log4j.Logger;

import com.jd.tool.PropertiesTool;

/**
 * 
 *	JDBC工具类
 *
 * @author ChenLingFeng
 */
public class DBLink {
	
	private Logger logger=Logger.getLogger(DBLink.class);

	/**
	 * 获取数据库连接	 
	 *
	 * @author Lenovo
	 */
	private Connection getConnection() {
		try {
			Class.forName("com.mysql.jdbc.Driver"); //加载驱动
			String username=PropertiesTool.getValue("db.username");
			String password=PropertiesTool.getValue("db.password");
			String url= PropertiesTool.getValue("db.url");
			return DriverManager.getConnection(url, username, password); //建立连接
		} catch (Exception e) {
			// TODO Auto-generated catch block
			logger.debug(e.getMessage(),e);
		} 
		return null;
		
		
	}
	
	/**
	 * 对数据进行添加，删除，修改等操作
	 * 
	 *
	 * @author Lenovo
	 */
	public boolean update(String sql,Object ...params) {
		Connection connection=null;
		PreparedStatement preparedStatement=null;
			try {
				connection=getConnection();
				preparedStatement=connection.prepareStatement(sql);
				for (int i = 0; i < params.length; i++) {
					preparedStatement.setObject(i+1, params[i]);
				}
				return preparedStatement.executeUpdate()>0;
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				logger.debug(e.getMessage(),e);
			}finally {
				close(preparedStatement,connection);
			}
		return false;
	}

	/**
	 * 查询数据select,
	 * 调用时可对IRowMapper接口通过内部类实现具体想要进行的操作。
	 *
	 * @author Lenovo
	 */
	public void select(String sql ,IRowMapper rowMapper,Object ... params) {
		Connection connection=null;
		PreparedStatement preparedStatement=null;
		ResultSet rs=null;
		try {
			connection=getConnection();
			preparedStatement=connection.prepareStatement(sql);//获取含有？占位符的sql语句
			for (int i = 0; i < params.length; i++) {
				preparedStatement.setObject(i+1, params[i]);//填充？
			}
			rs=preparedStatement.executeQuery();
			rowMapper.rowMapper(rs);
		} catch (Exception e) {
			logger.debug(e.getMessage(),e);
		}finally {
			close(rs,preparedStatement,connection);
		}
	}
	
	/**

	 * 判断sql语句是否能查出数据
	 * 
	 *
	 * @author Lenovo
	 */
	public boolean exist(String sql,Object...params) {
		Connection connection=null;
		PreparedStatement preparedStatement=null;
		ResultSet resultSet=null;
		try {
			connection=getConnection();
			preparedStatement=connection.prepareStatement(sql);
			for (int i = 0; i < params.length; i++) {
				preparedStatement.setObject(i+1, params[i]);
			}
			resultSet=preparedStatement.executeQuery();
			return resultSet.next();
		} catch (Exception e) {
			logger.debug(e.getMessage(),e);
		}finally {

			close(resultSet,preparedStatement,connection);
		}
		return false;
	}
	
	/**
	 * 释放资源
	 * 
	 *
	 * @author Lenovo
	 */
	private void close(ResultSet resultSet,Statement statement,Connection connection) {
			try {
				if(resultSet!=null) {
					resultSet.close();
				}
			} catch (SQLException e) {
				logger.debug(e.getMessage(),e);
			}
		
			try {
				if(statement!=null) {
					statement.close();
				}
			} catch (SQLException e) {
				logger.debug(e.getMessage(),e);
			}
		
			try {
				if(connection!=null) {
					connection.close();
				}
			} catch (SQLException e) {
				logger.debug(e.getMessage(),e);
			}
		}
	
	/**
	 * (重载)释放资源
	 * 
	 *
	 * @author Lenovo
	 */
	public void close(Statement statement,Connection connection) {
		if(statement!=null) {
			try {
				statement.close();
			} catch (SQLException e) {
				logger.debug(e.getMessage(),e);
			}
		}
		if(connection!=null) {
			try {
				connection.close();
			} catch (SQLException e) {
				logger.debug(e.getMessage(),e);
			}
		}
	}
	


}

Main方法：

package com.jd.test;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Scanner;
import java.util.UUID;

import com.jd.tool.MD5Tool;
import com.jd.tool.db.DBLink;
import com.jd.tool.db.IRowMapper;

public class Main {
	private static DBLink db=new DBLink();
	public static void main(String[] args) {
		
		System.out.println("*********************");
		System.out.println("欢迎使用学生管理系统");
		System.out.println("*********************");
		Scanner scanner=new Scanner(System.in);
		for(;;) { 
			menu(scanner);
		}
	}
	public static void menu(Scanner scanner) {
		System.out.println("1.注册");
		System.out.println("2.登录");
		System.out.println("3.退出");
		System.out.println("*******************");
		System.out.println("请输入操作项，点击enter项");
		int option=scanner.nextInt();				
		switch (option) {
			case 1:{
				System.out.println("1.注册");//用户名，密码，确认密码
				System.out.println("请输入用户名");
				String username= scanner.next();
				String sql="select username from users where username=?";
				if(db.exist(sql,username)) {
					System.out.println("该用户名已经存在，注册失败!");
					return;
				}
				System.out.println("请输入密码");
				String password= scanner.next();
				System.out.println("再次输入密码");
				String checkPassword=scanner.next();
				if(!password.equals(checkPassword)) {
					System.out.println("两次输入的密码不一样，注册失败");
					return;
				}
				String id=UUID.randomUUID().toString();
				password=MD5Tool.encrypt(password);
				sql="insert into users(username,password,id) values(?,?,?)";
				if (db.update(sql,username, password,id)) {
					System.out.println("注册成功");
				}
				break;
			}case 2:{
				System.out.println("2.登录");
				System.out.println("请输入用户名");
				String username= scanner.next();
				System.out.println("请输入密码");
				String password= scanner.next();
				password=MD5Tool.encrypt(password);
				String sql="select username,password from users where username=? and password=?";
				if(db.exist(sql,username,password)) {
					System.out.println("登录成功");
					return;
				}
				System.out.println("登录失败");
				break;
			}case 3:{
				System.out.println("成功退出系统");//System.exit(0);
				System.exit(0);
			}default:{
		
			}
		}
	}

}