隨機(jī)生成八位優(yōu)惠碼并保存至Mysql數(shù)據(jù)庫(kù)

2024-07-24 12:50:36

字體：大中小

供稿：網(wǎng)友

目前很多商家通過(guò)優(yōu)惠碼做活動(dòng)，現(xiàn)在我們簡(jiǎn)單的實(shí)現(xiàn)八位的優(yōu)惠碼，并保存在數(shù)據(jù)庫(kù)中。

1.隨機(jī)生成優(yōu)惠碼代碼如下：

import java.util.Random;/***功能：隨機(jī)生成優(yōu)惠碼*@author iamwiam**/public class Activatedcode { public int ACTIVATEDCODENUM = 200; //生成的優(yōu)惠碼數(shù)量 Random random = new Random(); String candicatedCode = "abcedefghijklmnopqrstuvwxyz";//優(yōu)惠碼包含小寫(xiě)字母 candicatedCode+=candicatedCode.toUpperCase()；//優(yōu)惠碼包含大寫(xiě)字母 candicatedCode+="1234567890";//優(yōu)惠碼包含阿拉伯?dāng)?shù)字 for(int i=0; i< ACTIVATEDCODENUM;i++){ String res =""; for(int j=0;j<8;j++){ res+=candicatedCode.charAt(random.nextInt(candicatedCode.lenght())); } System.out.println(res);//隨機(jī)生成200個(gè)8位的優(yōu)惠碼 }}

2.將優(yōu)惠碼保存在數(shù)據(jù)庫(kù)中

private static void insertToMySql(String res){ int n = 0; try{ Class.forName(“com.mysql.jdbc.Driver”); Connection connection = DriverMannager.getConnection(“jdbc:mysql://127.0.0.1/tb_act_code”,”zy”,”IamWiam”); String sql = “insert into checkNum(value) values(?)”; PreparedStatement ps = connection.prepareStatement(sql); ps.setObject(1,res); //占位符順序從1開(kāi)始，第一個(gè)參數(shù)是占位符的位置，第二個(gè)參數(shù)是占位符的值 n = ps.executeUpdate(); }catch(ClassNotFoundException e){ e.printStackTrace(); }catch(SQLException e){ e.printStackTrace(); } }

3.整合

import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.SQLException;import java.util.Random;/** * 功能：隨機(jī)生成優(yōu)惠碼 * @author iamwiam * */public class Activatedcode { public static void main(String[] args) { final int ACTIVATEDCODENUM = 200; Random random = new Random(); String candicatedCode = "abcdefghijklmnopqrstuvwxyz"; candicatedCode+=candicatedCode.toUpperCase(); candicatedCode+="1234567890"; for(int i=0;i<ACTIVATEDCODENUM;i++){ String res =""; for(int j=0;j<8;j++){ res+=candicatedCode.charAt(random.nextInt(candicatedCode.length())); }// String pwd = Activatedcode.getMD5(Activatedcode.getMD5(res)); insertToMysql(res); } } private static void insertToMysql(String res) { int n=0; try { Class.forName("com.mysql.jdbc.Driver"); Connection connection = DriverManager.getConnection( "jdbc:mysql://127.0.0.1/new2017", "zy", "IamWiam"); String sql = "insert into checkNum(value) values(?)"; PreparedStatement ps = connection.prepareStatement(sql); ps.setObject(1, res); n = ps.executeUpdate(); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } }}

4.結(jié)果如下

數(shù)據(jù)庫(kù)中內(nèi)容