一旦你創(chuàng)建了Statement對象可以使用的即聲明接口的執(zhí)行方法之一執(zhí)行它，execute()，executeUpdate()和executeQuery()。

的execute()方法：該方法是用于執(zhí)行SQL DDL語句，它返回一個布爾值，指定的天氣ResultSet對象可以被檢索。

示例import?java.sql.Connection;

import?java.sql.DriverManager;

import?java.sql.SQLException;

import?java.sql.Statement;

public?class?Example?{

public?static?void?main(String?args[])?throws?SQLException?{

//注冊驅動程序

DriverManager.registerDriver(new?com.mysql.jdbc.Driver());

//獲得連接

String?mysqlUrl?=?"jdbc:mysql://localhost/sampleDB";

Connection?con?=?DriverManager.getConnection(mysqlUrl,?"root",?"password");

System.out.println("Connection?established......");

//創(chuàng)建語句

Statement?stmt?=?con.createStatement();

//執(zhí)行語句

String?createTable?=?"CREATE?TABLE?Employee(?"

+?"Name?VARCHAR(255),?"

+?"Salary?INT?NOT?NULL,?"

+?"Location?VARCHAR(255))";

boolean?bool?=?stmt.execute(createTable);

System.out.println(bool);

}

}

輸出結果Connection?established......

false

executeUpdate()：此方法用于執(zhí)行諸如插入，更新，刪除之類的語句。它返回一個整數(shù)值，表示受影響的行數(shù)。

示例import?java.sql.Connection;

import?java.sql.DriverManager;

import?java.sql.SQLException;

import?java.sql.Statement;

public?class?ExecuteUpdateExample?{

public?static?void?main(String?args[])?throws?SQLException?{

//注冊驅動程序

DriverManager.registerDriver(new?com.mysql.jdbc.Driver());

//獲得連接

String?mysqlUrl?=?"jdbc:mysql://localhost/sampleDB";

Connection?con?=?DriverManager.getConnection(mysqlUrl,?"root",?"password");

System.out.println("Connection?established......");

//創(chuàng)建語句

Statement?stmt?=?con.createStatement();

String?insertData?=?"INSERT?INTO?Employee("

+?"Name,?Salary,?Location)?VALUES?"

+?"('Amit',?30000,?'Hyderabad'),?"

+?"('Kalyan',?40000,?'Vishakhapatnam'),?"

+?"('Renuka',?50000,?'Delhi'),?"

+?"('Archana',?15000,?'Mumbai')";

int?i?=?stmt.executeUpdate(insertData);

System.out.println("Rows?inserted:?"+i);

}

}

輸出結果Connection?established......

Rows?inserted:?4

executeQuery()：此方法用于執(zhí)行返回表格數(shù)據(jù)的語句(示例select)。它返回ResultSet類的對象。

示例import?java.sql.Connection;

import?java.sql.DriverManager;

import?java.sql.ResultSet;

import?java.sql.SQLException;

import?java.sql.Statement;

public?class?ExecuteQueryExample?{

public?static?void?main(String?args[])?throws?SQLException?{

//注冊驅動程序

DriverManager.registerDriver(new?com.mysql.jdbc.Driver());

//獲得連接

String?mysqlUrl?=?"jdbc:mysql://localhost/sampleDB";

Connection?con?=?DriverManager.getConnection(mysqlUrl,?"root",?"password");

System.out.println("Connection?established......");

//創(chuàng)建語句

Statement?stmt?=?con.createStatement();

//檢索數(shù)據(jù)

ResultSet?rs?=?stmt.executeQuery("Select?*from?Employee");

while(rs.next())?{

System.out.print("Name:?"+rs.getString("Name")+",?");

System.out.print("Salary:?"+rs.getInt("Salary")+",?");

System.out.print("City:?"+rs.getString("Location"));

System.out.println();

}

}

}

輸出結果Connection?established......

Name:?Amit,?Salary:?30000,?City:?Hyderabad

Name:?Kalyan,?Salary:?40000,?City:?Vishakhapatnam

Name:?Renuka,?Salary:?50000,?City:?Delhi

Name:?Archana,?Salary:?15000,?City:?Mumbai

總結

以上是生活随笔為你收集整理的java executequery,JDBC中的execute()，executeQuery()和executeUpdate()方法有什么区别？的全部內容，希望文章能夠幫你解決所遇到的問題。

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