MySql用statement實現DDL,DML,DQL的操作Demo

標籤：style   blog   io   color   ar   os   sp   for   資料   

Demo1

Connection connection=null;        Statement stmt=null;        int result=-1;                try {            Class.forName("com.mysql.jdbc.Driver");                    } catch (ClassNotFoundException e) {            e.printStackTrace();        }                        try {            //建立串連            String url="jdbc:mysql://localhost:3306/jdbcdb";            connection= DriverManager.getConnection(url, "root", "mysql");        } catch (SQLException e) {            e.printStackTrace();        }                try {            //建立Statement            String sql="CREATE TABLE s_user(id INT PRIMARY KEY AUTO_INCREMENT,    NAME VARCHAR(20),PASSWORD VARCHAR(15)) ";             stmt=connection.createStatement();             //執行sql語句，返回受影響行數 ————int值             result= stmt.executeUpdate(sql);        } catch (SQLException e) {            e.printStackTrace();        }                System.out.println("result="+result);                try {            //關閉流            if(stmt!=null)            {                stmt.close();            }                        if(connection!=null)            {                connection.close();            }                    } catch (SQLException e) {            e.printStackTrace();        }

Demo2

Connection connection=null;        Statement stmt=null;        ResultSet rSet=null;        try {            Class.forName("com.mysql.jdbc.Driver");            String url="jdbc:mysql://localhost:3306/jdbcdb";            String user="root";            String password="mysql";            //串連            connection= DriverManager.getConnection(url, user, password);            stmt= connection.createStatement();//statement            String sql="SELECT * from s_user;";            rSet= stmt.executeQuery(sql);//執行sql語句---資料集（類似於map）                        while (rSet.next()) {                //擷取值（通過索引）                int id= rSet.getInt(1);                String name=rSet.getString(2);                String pwd=rSet.getString(3);                                System.out.println("id="+id+";name="+name+";pwd="+pwd);                //通過行列號                id=rSet.getInt("id");                name=rSet.getString("name");                pwd=rSet.getString("password");                                System.out.println("~~~~~~~id="+id+";name="+name+";pwd="+pwd);                            }                    } catch

 

MySql用statement實現DDL,DML,DQL的操作Demo