statement executing static SQL statements

 PackageCom.isoftstone.jdbc;Importjava.sql.Connection;ImportJava.sql.DriverManager;ImportJava.sql.ResultSet;Importjava.sql.SQLException;Importjava.sql.Statement;Importorg.junit.Test; Public classMYSQLJDBC {PrivateString url = "Jdbc:mysql://127.0.0.1:3306/scott"; PrivateString user = "root"; PrivateString password = "root"; @Test Public voidTestjdbc () {Connection conn=NULL; Statement stmt=NULL; ResultSet RS=NULL; Try{            //1. Registered DriverClass.forName ("Com.mysql.jdbc.Driver"); //2. Create a Connection objectconn =drivermanager.getconnection (URL, user, password); //3. Create a statement objectstmt =conn.createstatement (); //4. Preparing SQL statementsString updatesql = "CREATE TABLE student (id INT PRIMARY KEY auto_increment,name varchar (), gender varchar (2))"; //String querysql = "SELECT * from EMP"; //5. Sending SQL statements, executing SQL statements//rs= stmt.executequery (querysql); SQL statement for Query            intCount = Stmt.executeupdate (updatesql);//Modified SQL statements//6. SQL for output query and modified SQL do not execute together            /*while (Rs.next ()) {String empno = rs.getstring ("Empno");            System.out.println (EMPNO); }*/System.out.println (count); }Catch(Exception e) {e.printstacktrace (); }finally{            //7, close the connection (order: After opening the first closed)            if(rs! =NULL){                Try{rs.close (); } Catch(SQLException e) {//TODO auto-generated Catch blockE.printstacktrace (); }            }            if(stmt! =NULL){                Try{stmt.close (); } Catch(SQLException e) {//TODO auto-generated Catch blockE.printstacktrace (); }            }            if(Conn! =NULL){                Try{conn.close (); } Catch(SQLException e) {//TODO auto-generated Catch blockE.printstacktrace (); }            }        }    }}

statement executing static SQL statements