扫描二维码下载沐宇APP

沐宇

微信扫码使用沐宇小程序

沐宇

jdbc鎬庝箞鍒犻櫎鏁版嵁搴撶殑鏁版嵁

扬州沐宇科技
2023-12-21 10:39:35
jdbc, 鏁版嵁搴?/a>

瑕佸垹闄ゆ暟鎹簱涓殑鏁版嵁锛屽彲浠ヤ娇鐢↗DBC鏉ユ墽琛孲QL鐨凞ELETE璇彞銆?br/>棣栧厛锛屼綘闇€瑕佸缓绔嬩竴涓狫DBC杩炴帴鍒颁綘鐨勬暟鎹簱銆傚彲浠ヤ娇鐢ㄤ互涓嬩唬鐮佺ず渚嬫潵寤虹珛杩炴帴锛?br/>

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class JdbcDeleteExample {

聽聽聽聽public聽static聽void聽main(String[]聽args)聽{

聽聽聽聽聽聽聽聽//聽JDBC杩炴帴淇℃伅

聽聽聽聽聽聽聽聽String聽url聽=聽鈥渏dbc:mysql://localhost:3306/your_database鈥?

聽聽聽聽聽聽聽聽String聽username聽=聽鈥測our_username鈥?

聽聽聽聽聽聽聽聽String聽password聽=聽鈥測our_password鈥?

聽聽聽聽聽聽聽聽//聽寤虹珛JDBC杩炴帴

聽聽聽聽聽聽聽聽try聽(Connection聽conn聽=聽DriverManager.getConnection(url,聽username,聽password))聽{

聽聽聽聽聽聽聽聽聽聽聽聽//聽鍦ㄨ繛鎺ヤ笂鎵ц鍒犻櫎鎿嶄綔

聽聽聽聽聽聽聽聽聽聽聽聽deleteData(conn);

聽聽聽聽聽聽聽聽聽聽聽聽System.out.println(鈥滄暟鎹垹闄ゆ垚鍔燂紒鈥?;

聽聽聽聽聽聽聽聽}聽catch聽(SQLException聽e)聽{

聽聽聽聽聽聽聽聽聽聽聽聽e.printStackTrace();

聽聽聽聽聽聽聽聽}

聽聽聽聽}

聽聽聽聽private聽static聽void聽deleteData(Connection聽conn)聽throws聽SQLException聽{

聽聽聽聽聽聽聽聽//聽鍒涘缓鍒犻櫎璇彞

聽聽聽聽聽聽聽聽String聽sql聽=聽鈥淒ELETE聽FROM聽your_table聽WHERE聽condition鈥?

聽聽聽聽聽聽聽聽//聽鍒涘缓涓€涓狿reparedStatement瀵硅薄

聽聽聽聽聽聽聽聽try聽(PreparedStatement聽stmt聽=聽conn.prepareStatement(sql))聽{

聽聽聽聽聽聽聽聽聽聽聽聽//聽鍙€夛細璁剧疆鍒犻櫎鏉′欢鐨勫弬鏁?/p>

聽聽聽聽聽聽聽聽聽聽聽聽stmt.setString(1,聽鈥渧alue鈥?;

聽聽聽聽聽聽聽聽聽聽聽聽//聽鎵ц鍒犻櫎鎿嶄綔

聽聽聽聽聽聽聽聽聽聽聽聽stmt.executeUpdate();

聽聽聽聽聽聽聽聽}

聽聽聽聽} }

鍦ㄤ笂杩颁唬鐮佷腑锛屼綘闇€瑕佹浛鎹?code>url銆?code>username銆?code>password銆?code>your_table鍜?code>condition涓轰綘鐨勫疄闄呰繛鎺ヤ俊鎭拰鍒犻櫎鏉′欢銆傜劧鍚庯紝浣跨敤stmt.setString()鏂规硶璁剧疆鍒犻櫎鏉′欢鐨勫弬鏁帮紙濡傛灉鏈夌殑璇濓級锛屾渶鍚庤皟鐢?code>stmt.executeUpdate()鏂规硶鎵ц鍒犻櫎鎿嶄綔銆?br/>闇€瑕佹敞鎰忕殑鏄紝鎵ц鍒犻櫎鎿嶄綔鏃惰璋ㄦ厧锛屽洜涓哄垹闄ょ殑鏁版嵁灏嗘棤娉曟仮澶嶃€傚湪鎵ц鍒犻櫎鎿嶄綔涔嬪墠锛屽缓璁厛杩涜鏁版嵁澶囦唤锛屼互闃叉鏁版嵁涓㈠け銆?br/>

扫码添加客服微信