用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!");
}
}
}
}