mysql資料庫__Jdbc直接操作__Statement__update

標籤：update   close   lock   操作   new   nal   exce   system   char   

一、代碼如下

private void updateMysql() {// TODO Auto-generated method stubjava.sql.Statement sm= null;java.sql.Connection cn = null;ResultSet rs = null;try {//載入驅動程式Class.forName("com.mysql.jdbc.Driver").newInstance();//得到串連cn = DriverManager.getConnection("jdbc:mysql://localhost:3306/learn?user=root&password=&useUnicode=true&characterEncoding=UTF8");sm= cn.createStatement();int i= sm.executeUpdate("update user set username=‘hhh‘ where username= ‘fff‘");System.out.println(i);if(i >= 1) {System.out.println("更新：成功");}else {System.out.println("更新：失敗");}} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();} finally {try {if(sm != null) {sm.close();}if(cn != null) {cn.close();}} catch (SQLException e) {e.printStackTrace();}}}

 

mysql資料庫__Jdbc直接操作__Statement__update