One, the code is as follows
private void CTable () {//TODO auto-generated method Stubjava.sql.PreparedStatement PS = Null;java.sql.connection cn = nul L 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 ");p s = cn.prepareStatement (" CREATE table xxxx (AA int)); int i= ps.executeupdate (); System.out.println (i); if (i>=1) {System.out.println ("Data sheet added: Success");} else {System.out.println ("data table added: Failed");}} catch (Exception e) {//TODO auto-generated catch Blocke.printstacktrace ();} finally {try {ps.close (); Cn.close ();} catch ( SQLException e) {e.printstacktrace ();}}}
MySQL database __jdbc Direct operation __preparedstatement__ New data Sheet