1、Statement接口引入

作用：用于執行靜態 SQL 語句并返回它所生成結果的對象。

常用方法：

• int executeUpdate(String sql) 執行給定 SQL 語句，該語句可能為 INSERT、UPDATE 或DELETE 語句，或者不返回任何內容的 SQL 語句（如 SQL DDL 語句）。
• void close() 立即釋放此 Statement 對象的數據庫和 JDBC 資源，而不是等待該對象自動關閉時發生此操作。

2、使用 Statement 接口實現添加數據操作

實例1：
創建工具類DbUtil：

import java.sql.Connection; import java.sql.DriverManager;public class DbUtil {private static String dbUrl="jdbc:mysql://localhost:3306/book?useUnicode=true&characterEncoding=UTF-8";private static String dbUserName="root";private static String dbPassword="root";private static String jdbcName="com.mysql.jdbc.Driver";/*** 獲取數據庫連接* @return* @throws Exception*/public Connection getCon() throws Exception{Class.forName(jdbcName);Connection con=DriverManager.getConnection(dbUrl,dbUserName,dbPassword); return con;}/*** 關閉連接* @param con* @throws Exception*/public void close(Connection con)throws Exception{if(con!=null){con.close();}} } import java.sql.Connection; import java.sql.Statement;import com.cn.jdbc.Util.DbUtil;public class jdbcTest {public static void main(String[] args) throws Exception {DbUtil dbUtil=new DbUtil();String sql="insert into student values(null,'東方不敗','女',1000) ";Connection con=dbUtil.getCon();//獲取數據庫連接Statement stmt=con.createStatement();//獲取Statementint result=stmt.executeUpdate(sql);//判斷是否成功System.out.println("操作的結果："+result+"數據");stmt.close();//關閉Statementcon.close();//關閉連接} }

運行結果：


實例2：使用變量，面向對象的方法
1、創建學生模型

public class Student {private String stuName;private String stuSex;private int stuAge;public Student() {super();// TODO Auto-generated constructor stub}public Student(String stuName, String stuSex, int stuAge) {super();this.stuName = stuName;this.stuSex = stuSex;this.stuAge = stuAge;}public String getStuName() {return stuName;}public void setStuName(String stuName) {this.stuName = stuName;}public String getStuSex() {return stuSex;}public void setStuSex(String stuSex) {this.stuSex = stuSex;}public int getStuAge() {return stuAge;}public void setStuAge(int stuAge) {this.stuAge = stuAge;} }

2、工具類DbUtil

public class DbUtil {private static String jdbcName="com.mysql.jdbc.Driver";private static String dbUrl="jdbc:mysql://localhost:3306/book?useUnicode=true&characterEncoding=UTF-8";private static String dbUserName="root";private static String dbPassword="root";public Connection getCon() throws Exception{Class.forName(jdbcName);Connection con=DriverManager.getConnection(dbUrl,dbUserName,dbPassword);return con;}public void close(Statement stmt,Connection con) throws Exception{if(stmt!=null){stmt.close();if(con!=null){con.close();}}} }

3、測試類

public class JDBCTest {private static DbUtil dbUtil=new DbUtil();Student student=new Student();/*** 添加學生* @param student* @return* @throws Exception*/public static int addStudent(Student student)throws Exception{Connection con=dbUtil.getCon();//獲取連接String sql="insert into student values(null,'"+student.getStuName()+"','"+student.getStuSex()+"',"+student.getStuAge()+")";Statement stmt=con.createStatement();//創建Statementint result=stmt.executeUpdate(sql);dbUtil.close(stmt, con);//關閉Statement和連接return result;}public static void main(String[] args)throws Exception {Student student=new Student("三娃","男",77);int result=addStudent(student);if(result==1){System.out.println("成功");}else{System.out.println("失敗");}} }

3、使用 Statement 接口實現更新數據操作

實例1：通過ID更新數據
1、創建學生模型

public class Student {private int id;private String stuName;private String stuSex;private int stuAge;public Student() {super();// TODO Auto-generated constructor stub}public Student(int id, String stuName, String stuSex, int stuAge) {super();this.id = id;this.stuName = stuName;this.stuSex = stuSex;this.stuAge = stuAge;}public String getStuName() {return stuName;}public void setStuName(String stuName) {this.stuName = stuName;}public String getStuSex() {return stuSex;}public void setStuSex(String stuSex) {this.stuSex = stuSex;}public int getStuAge() {return stuAge;}public void setStuAge(int stuAge) {this.stuAge = stuAge;}public int getId() {return id;}public void setId(int id) {this.id = id;} }

2、工具類DbUtil

public class DbUtil {private static String dbUrl="jdbc:mysql://localhost:3306/book?useUnicode=true&characterEncoding=UTF-8";private static String dbUserName="root";private static String dbPassword="root";private static String jdbcName="com.mysql.jdbc.Driver";/*** 獲取數據庫連接* @return* @throws Exception*/public Connection getCon() throws Exception{Class.forName(jdbcName);Connection con=DriverManager.getConnection(dbUrl,dbUserName,dbPassword); return con;}/*** 關閉連接* @param con* @throws Exception*/public void close(Statement stmt,Connection con)throws Exception{if(stmt!=null){stmt.close();if(con!=null){con.close();}}} }

3、測試類

public class jdbcTest {private static DbUtil dbUtil=new DbUtil();private static Student student=new Student();/*** 更新數據* @param stuName* @param stuSex* @param stuAge* @return*/public static int updateStudent(Student student)throws Exception{Connection con=dbUtil.getCon();//獲取連接String sql="update student set stuName='"+student.getStuName()+"',stuSex='"+student.getStuSex()+"',stuAge="+student.getStuAge()+" where stuId="+student.getId()+"";Statement stmt=con.createStatement();//創建Statementint result=stmt.executeUpdate(sql);//判斷是否成功dbUtil.close(stmt, con);//關閉Statement和連接return result;}public static void main(String[] args) throws Exception {Student student=new Student(1,"擎天柱","男",999);updateStudent(student);} }

運行結果：

第四節：使用 Statement 接口實現刪除數據操作

實例1：
3、測試類

public class jdbcTest {private static DbUtil dbUtil=new DbUtil();private static Student student=new Student();/*** 刪除數據* @param stuName* @param stuSex* @param stuAge* @return*/public static int deleteStudent(int id)throws Exception{Connection con=dbUtil.getCon();//獲取連接String sql="delete from student where stuId="+id;Statement stmt=con.createStatement();//創建Statementint result=stmt.executeUpdate(sql);//判斷是否成功dbUtil.close(stmt, con);//關閉Statement和連接return result;}public static void main(String[] args) throws Exception {deleteStudent(1);} }

運行結果：

總結

以上是生活随笔為你收集整理的3、使用Statement接口实现增，删，改操作的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。