jdbc 连接sqlserver模板

 

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