public?static?void?main(String[]?args)?{

//?TODO?Auto-generated?method?stub

String?url?=?"jdbc:jtds:sqlserver://127.0.0.1:1433;databaseName=base_name;user=sa;password=?pas";//sa身份連接

Connection?con?=?null;

Statement?stmt?=?null;

//ResultSet?rs?=?null;

boolean?rs?;

try?{

Class.forName("net.sourceforge.jtds.jdbc.Driver");

con?=?DriverManager.getConnection(url);

stmt?=?con.createStatement();

System.out.println("end.");

String?sql1="drop?table?aa";

rs?=?stmt.execute(?sql1);

System.out.println("我刪除了一張表");

String?SQL?=?"create?table?aa("?+

"idint?null,"?+

"currdatedate?null,)";

rs?=?stmt.execute(SQL);

System.out.println("我創建了一張表");

//?rs?=?stmt.executeQuery(SQL);

/*??while?(rs.next())?{

System.out.println(rs.getString(4)?+?"?"?+?rs.getString(6));

}???*/

}

catch?(Exception?e)?{

e.printStackTrace();

}

finally?{

/*if(rs!=null){

rs.colse();

}*/

if?(stmt?!=?null)

try?{

stmt.close();

}?catch?(Exception?e)?{

}

if?(con?!=?null)

try?{

con.close();

}?catch?(Exception?e)?{

}

}

}

總結

以上是生活随笔為你收集整理的sql java 创建数据库_java动态创建数据库(sql server)的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。