java简单db插入

package jdbc_insert;


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

	public class Insert_uc_invite_relationship {
	    public static void main(String[] args) {
	        try {
	            Class.forName("com.mysql.jdbc.Driver");
	            String url = "jdbc:mysql://xxx:3301/huhi?useUnicode=true&characterEncoding=utf-8&useSSL=false";
	            String user = "xx"; 
	            String password = "F3tTRPq_YaskCFehxx"; 
	            Connection conn = DriverManager.getConnection(url, user, password);
	            int[ ] userid={7000184,7000185};
	            for (int i=0;i<userid.length;i++) {
	            	 
	                     String sql = "INSERT INTO uc_invite_relationship( invitee_id, inviter_id, point_rate, usdt_rate, valid_day, end_time, gmt_created, gmt_modified, state, rebate_rate, rebate_switch, quota_limit, ht_rate) VALUES (?, 7000001, 0.3000, 0.3000, 90, '2020-02-06 16:00:00', '2019-11-09 06:29:15', '2019-11-09 06:29:15', 1, 0, 1, -1, 0.3000);"; // 生成一条sql语句
	                     PreparedStatement ps = conn.prepareStatement(sql);
	                     ps.setInt(1, userid[i]);

	                     ps.executeUpdate();
	                     System.out.println("第" +i+"个被邀请人：" +userid[i]);

	            

	                 }
	            
	            conn.close();
	            System.out.println("插入完毕！！！");
	 
	        } catch (ClassNotFoundException e) {
	            e.printStackTrace();
	        } catch (SQLException e) {
	            e.printStackTrace();
	        }
	    }
	}