mysql数据库__Jdbc直接操作__PreparedStatement__新增数据表

表

⼀、代码如下

private void cTable() {

// TODO Auto-generated method stub java.sql.PreparedStatement ps = null; java.sql.Connection cn = null; ResultSet rs = null;

try {

// Class.forName(\"com.microsoft.jdbc.sqlserver.SQLServerDriver\"); Class.forName(\"com.mysql.jdbc.Driver\").newInstance(); cn = DriverManager.getConnection(

\"jdbc:mysql://localhost:3306/learn?user=root&password=&useUnicode=true&characterEncoding=UTF8\"); ps = cn.prepareStatement(\"create table xxxx(aa int)\");

int i= ps.executeUpdate(); System.out.println(i); if(i>=1) {

System.out.println(\"数据表新增：成功\"); }else {

System.out.println(\"数据表新增：失败\"); }

} catch (Exception e) {

// TODO Auto-generated catch block e.printStackTrace(); } finally { try {

ps.close(); cn.close();

} catch (SQLException e) { e.printStackTrace(); } } }