用java向mysql数据库中写入规则数据

该程序向database数据库的tablename表中写入了一个规则体数据，附带品位值为0.

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 java.util.ArrayList;

public class Trasys {
static Databasecon dbc1;
static java.sql.ResultSet rst = null;
static Connection con = null;
static Connection con1 = null;
static int xx,yy,zz;
         ArrayList tset=new ArrayList();
public static void main(String[] args) throws ClassNotFoundException,SQLException {
  Trasys tsss=new Trasys();
  tsss.insert1();
}
public  void insert1()
Connection connection1 = null;
Statement statement1 = null;
String url = "jdbc:mysql://127.0.0.1:3306/databasename"; String userName = "name"; //指定用户名
String password = "code";
String insert = "insert into tablename(x,y,z,grade)" +
        "values(?,?,?,?)";
    try {
      Class.forName("com.mysql.jdbc.Driver");
      connection1 = (Connection) DriverManager.getConnection(url, userName,password);
statement1 = connection1.createStatement();
PreparedStatement insertps = (PreparedStatement) connection1.
prepareStatement(insert);
for (xx = 1; xx<= 1000; xx = xx + 10) {
for ( yy = 1; yy <= 1000; yy = yy + 10) {
for ( zz = -100; zz >= -200; zz = zz - 1) { 
      insertps.setDouble(1, xx);
      insertps.setDouble(2, yy);
      insertps.setDouble(3, zz);
      insertps.setDouble(4, 0);
      insertps.executeUpdate();
                        }}}
      }
    catch (SQLException ex2) {
    }
    catch (ClassNotFoundException ex) {
System.out.println("no driver is found!" + ex);
    }

    finally {
      try {
        statement1.close();
        connection1.close();
      }
      catch (Exception ex) {
        //    System.out.println("Close error!");
      }
    }
}
}