Java 使用execute方法执行Sql语句

Java 使用execute方法执行Sql语句。

mysql.ini是一个配置文件。配置内容可以看上一篇。

class  ExecuteSql {      private  String driver;      private  String url;      private  String user;      private  String pass;      Connection conn;      Statement stmt;      ResultSet rs;      public  void  initParam(String paramFile) throws  Exception {          Properties props = new  Properties();          props.load( new  FileInputStream(paramFile));          driver = props.getProperty( "driver" );          url = props.getProperty( "url" );          user = props.getProperty( "user" );          pass = props.getProperty( "pass" );            }            public  void  executeSql(String sql) throws  Exception{          try  {              Class.forName(driver);              conn = DriverManager.getConnection(url,user,pass);              stmt = conn.createStatement();              boolean  hasResultSet = stmt.execute(sql);              if  (hasResultSet) {                  rs = stmt.getResultSet();                  java.sql.ResultSetMetaData rsmd = rs.getMetaData();                  int  columnCount = rsmd.getColumnCount();                                    while  (rs.next()) {                      for  ( int  i = 0 ; i < columnCount; i++) {                          System.out.print(rs.getString(i+ 1 ) + "\t" );                      }                      System.out.println();                                        }              }              else  {                  System.out.println( "改SQL语句影响的记录有"  + stmt.getUpdateCount() + "条" );              }          }          finally          {              if  (rs != null ) {                  rs.close();              }              if  (stmt != null ) {                  stmt.close();              }              if  (conn != null ) {                  conn.close();              }          }      }            /**       * @param args       * @throws Exception       */      public  static  void  main(String[] args) throws  Exception {          // TODO Auto-generated method stub                    ExecuteDDL ed = new  ExecuteDDL();          ed.initParam( "src/mysql.ini" );                ed.executeSql( "drop table if exists school" ); //(insertSql);             ed.executeSql( "create table school(id int, name varchar(50), addr varchar(50))" );                ed.executeSql( "insert into school values(1, 'No1', 'BeiJing')" );             ed.executeSql( "select * from school" );       }         }

　　执行结果为：

本文转自Work Hard Work Smart博客园博客，原文链接：http://www.cnblogs.com/linlf03/archive/2012/12/16/2820677.html，如需转载请自行联系原作者