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

2024-07-25 19:08:03

字體：大中小

供稿：網(wǎng)友

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

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

import java.util.Random;/***功能：隨機生成優(yōu)惠碼*@author iamwiam**/public class Activatedcode { public int ACTIVATEDCODENUM = 200; //生成的優(yōu)惠碼數(shù)量 Random random = new Random(); String candicatedCode = "abcedefghijklmnopqrstuvwxyz";//優(yōu)惠碼包含小寫字母 candicatedCode+=candicatedCode.toUpperCase()；//優(yōu)惠碼包含大寫字母 candicatedCode+="1234567890";//優(yōu)惠碼包含阿拉伯數(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);//隨機生成200個8位的優(yōu)惠碼 }}

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

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開始，第一個參數(shù)是占位符的位置，第二個參數(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;/** * 功能：隨機生成優(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é)果如下

優(yōu)惠碼,mysql,數(shù)據(jù)庫