package demo1;
/**
* <p>Title: 创建项目数库。</p>
*/
import java.sql.*;
public class CreateDatabase {
public static void main(String[] args) {
Connection con = null;
PreparedStatement pstm;
try {
//建立SQL sever数据连接
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
con = DriverManager.getConnection(
"jdbc:sqlserver://localhost:1433", "sa", "sa");
String sql = "create database AddressList " + "on"
+ "(name='SI_dat'," + "filename='D://AddressList.mdf',"
+ "size= 10,"
+ "maxsize=50,"
+ "filegrowth=2)"
+ "log "
+ "on"
+ "(name='SI_log',"
+ "filename='D://AddressList.ldf',"
+ "size=5mb,"
+ "maxsize= 25mb,"
+ "filegrowth=2mb)";
pstm = con.prepareStatement(sql);
System.out.println(sql + "/n/n/n");
pstm.execute();
pstm.close();
con.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}