import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
public class InsertData {
public static void main(String[] args) throws Exception {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver")
.newInstance();
String URL = "jdbc:sqlserver://localhost:1433;DatabaseName=master";
String USER = "sa"; // 根据你自己设置的数据库连接用户进行设置
String PASSWORD = ""; // 根据你自己设置的数据库连接密码进行设置
Connection conn = DriverManager.getConnection(URL, USER, PASSWORD);
Statement s = conn.createStatement();
for (int i = 1; i <= 50; i++) {
String sql = "insert into daifabiao values(1,'18952475482','超市新开张,欢迎光临!',4,"+i+")";
s.execute(sql);
}
System.out.println("OK");
}
}