溫馨提示×
您好，登錄后才能下訂單哦！
點擊 登錄注冊 即表示同意《億速云用戶服務條款》
您好，登錄后才能下訂單哦！
這篇文章主要介紹JDBC怎么實現(xiàn)數(shù)據(jù)庫增刪改查功能，文中介紹的非常詳細，具有一定的參考價值，感興趣的小伙伴們一定要看完！
具體如下：
1、添加數(shù)據(jù)
package cn.itcast.jdbc;
import java.sql.*;
public class JdbcDemo2 {
public static void main(String[] args) {
Connection connection = null;
PreparedStatement preparedStatement = null;
try {
//1、注冊驅(qū)動
Class.forName("com.mysql.jdbc.Driver");
//2、定義sql
String sql = "insert into course values(?,?,?)";
//3、獲取Connection對象
//student表示你要操作的數(shù)據(jù)庫
//如果是locakhost：3306，也可以簡寫為"jdbc:mysql:///student"
connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/student","root","root");
//4、獲取執(zhí)行sql的對象
preparedStatement = connection.prepareStatement(sql);
//傳入?yún)?shù)
preparedStatement.setInt(1,5);
preparedStatement.setString(2,"JavaWeb");
preparedStatement.setInt(3,88);
//5、執(zhí)行sql
int count = preparedStatement.executeUpdate();
//6、處理結(jié)果
System.out.println(count);
if (count > 0) {
System.out.println("添加成功");
} else {
System.out.println("添加失敗");
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} finally {
//7、釋放資源
//避免空指針異常
if (preparedStatement != null) {
try {
preparedStatement.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (connection != null) {
try {
connection.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
}2、刪除數(shù)據(jù)
package cn.itcast.jdbc;
import java.sql.*;
public class JdbcDemo4 {
public static void main(String[] args) {
Connection connection = null;
PreparedStatement preparedStatement = null;
try {
//1、注冊驅(qū)動
Class.forName("com.mysql.jdbc.Driver");
//2、獲取連接對象
connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/student","root","root");
//3、定義sql
String sql = "delete from course where cno = ?";
//4、獲取執(zhí)行sql對象
preparedStatement = connection.prepareStatement(sql);
preparedStatement.setInt(1,5);
//5、執(zhí)行sql
int count = preparedStatement.executeUpdate();
//6、處理結(jié)果
System.out.println(count);
if (count > 0) {
System.out.println("刪除成功");
} else {
System.out.println("刪除失敗");
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} finally {
//7、釋放資源
if (preparedStatement != null) {
try {
preparedStatement.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (connection != null) {
try {
connection.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
}3、修改數(shù)據(jù)
package cn.itcast.jdbc;
import java.sql.*;
public class JdbcDemo3 {
public static void main(String[] args) {
Connection connection = null;
PreparedStatement preparedStatement = null;
try {
//1、注冊驅(qū)動
Class.forName("com.mysql.jdbc.Driver");
//2、獲取連接對象
connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/student", "root", "root");
//3、定義sql
String sql = "update course set period = ? where cno = ?";
//4、獲取執(zhí)行sql對象
preparedStatement = connection.prepareStatement(sql);
//設置參數(shù)
preparedStatement.setInt(1,90);
preparedStatement.setInt(2,1);
//5、執(zhí)行sql
int count = preparedStatement.executeUpdate();
//6、處理結(jié)果
System.out.println(count);
if (count > 0) {
System.out.println("修改成功！");
} else {
System.out.println("修改失?。?quot;);
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} finally {
//7、釋放資源
if (preparedStatement != null) {
try {
preparedStatement.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (connection != null) {
try {
connection.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
}4、查詢數(shù)據(jù)
package cn.itcast.jdbc;
import cn.itcast.domain.Course;
import java.sql.*;
import java.util.ArrayList;
import java.util.List;
public class JDBCDemo5 {
/**
* 查詢所有Course對象
* @return
*/
public static void main(String[] args) {
Connection connection = null;
PreparedStatement preparedStatement = null;
ResultSet resultSet = null;
List<Course> list = null;
try {
//1、注冊驅(qū)動
Class.forName("com.mysql.jdbc.Driver");
//2、獲取連接
connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/student", "root", "root");
//3、定義sql
String sql = "select * from course";
//4、獲取執(zhí)行sql的對象
preparedStatement = connection.prepareStatement(sql);
//5、執(zhí)行sql
resultSet = preparedStatement.executeQuery();
//6、遍歷結(jié)果集，封裝對象，裝載集合
Course course = null;
list = new ArrayList<Course>();
while (resultSet.next()) {
//獲取數(shù)據(jù)
int cno = resultSet.getInt("cno");
String cname = resultSet.getString("cname");
int period = resultSet.getInt("period");
//創(chuàng)建Course對象并賦值
course = new Course();
course.setCno(cno);
course.setCname(cname);
course.setPeriod(period);
//裝載集合
list.add(course);
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} finally {
if (resultSet != null) {
try {
resultSet.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (preparedStatement != null) {
try {
preparedStatement.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (connection != null) {
try {
connection.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
System.out.println(list);
}
}我們可以發(fā)現(xiàn)，增刪改的操作基本都是差不多的語句，且執(zhí)行sql的語句都是一樣的，都是preparedStatement.executeUpdate()。但查詢操作就有所不同了，返回的是一個結(jié)果集，且執(zhí)行sql的語句就是preparedStatement.executeQuery()。
以上是“JDBC怎么實現(xiàn)數(shù)據(jù)庫增刪改查功能”這篇文章的所有內(nèi)容，感謝各位的閱讀！希望分享的內(nèi)容對大家有幫助，更多相關(guān)知識，歡迎關(guān)注億速云行業(yè)資訊頻道！
免責聲明：本站發(fā)布的內(nèi)容（圖片、視頻和文字）以原創(chuàng)、轉(zhuǎn)載和分享為主，文章觀點不代表本網(wǎng)站立場，如果涉及侵權(quán)請聯(lián)系站長郵箱：is@yisu.com進行舉報，并提供相關(guān)證據(jù)，一經(jīng)查實，將立刻刪除涉嫌侵權(quán)內(nèi)容。
億速云公眾號
手機網(wǎng)站二維碼