java鎬庝箞瀹炵幇鏁版嵁淇濆瓨鍒版暟鎹簱
瑕佸皢鏁版嵁淇濆瓨鍒版暟鎹簱涓紝棣栧厛闇€瑕佸缓绔嬫暟鎹簱杩炴帴锛屽苟鍒涘缓涓€涓搴旂殑琛ㄧ粨鏋勩€傜劧鍚庯紝浣跨敤Java鐨凧DBC锛圝ava Database Connectivity锛?API鏉ユ墽琛屾彃鍏ユ搷浣溿€?br/>浠ヤ笅鏄竴涓畝鍗曠殑绀轰緥浠g爜锛屾紨绀轰簡濡備綍灏嗘暟鎹繚瀛樺埌MySQL鏁版嵁搴撲腑锛?br/>
import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.SQLException; public class DataSavingExample {聽聽聽聽public聽static聽void聽main(String[]聽args)聽{
聽聽聽聽聽聽聽聽//聽鏁版嵁搴撹繛鎺ヤ俊鎭?/p>
聽聽聽聽聽聽聽聽String聽url聽=聽鈥渏dbc:mysql://localhost:3306/mydatabase鈥?
聽聽聽聽聽聽聽聽String聽username聽=聽鈥渞oot鈥?
聽聽聽聽聽聽聽聽String聽password聽=聽鈥減assword鈥?
聽聽聽聽聽聽聽聽//聽鏁版嵁
聽聽聽聽聽聽聽聽String聽name聽=聽鈥淛ohn鈥?
聽聽聽聽聽聽聽聽int聽age聽=聽25;
聽聽聽聽聽聽聽聽String聽email聽=聽鈥渏ohn@example.com鈥?
聽聽聽聽聽聽聽聽//聽寤虹珛鏁版嵁搴撹繛鎺?/p>
聽聽聽聽聽聽聽聽try聽(Connection聽connection聽=聽DriverManager.getConnection(url,聽username,聽password))聽{
聽聽聽聽聽聽聽聽聽聽聽聽//聽鍒涘缓鎻掑叆璇彞
聽聽聽聽聽聽聽聽聽聽聽聽String聽sql聽=聽鈥淚NSERT聽INTO聽users聽(name,聽age,聽email)聽VALUES聽(?,聽?,聽?)鈥?
聽聽聽聽聽聽聽聽聽聽聽聽PreparedStatement聽statement聽=聽connection.prepareStatement(sql);
聽聽聽聽聽聽聽聽聽聽聽聽//聽璁剧疆鎻掑叆鍙傛暟
聽聽聽聽聽聽聽聽聽聽聽聽statement.setString(1,聽name);
聽聽聽聽聽聽聽聽聽聽聽聽statement.setInt(2,聽age);
聽聽聽聽聽聽聽聽聽聽聽聽statement.setString(3,聽email);
聽聽聽聽聽聽聽聽聽聽聽聽//聽鎵ц鎻掑叆鎿嶄綔
聽聽聽聽聽聽聽聽聽聽聽聽int聽rowsInserted聽=聽statement.executeUpdate();
聽聽聽聽聽聽聽聽聽聽聽聽if聽(rowsInserted聽>聽0)聽{
聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽System.out.println(鈥滄暟鎹彃鍏ユ垚鍔燂紒鈥?;
聽聽聽聽聽聽聽聽聽聽聽聽}
聽聽聽聽聽聽聽聽}聽catch聽(SQLException聽e)聽{
聽聽聽聽聽聽聽聽聽聽聽聽System.out.println(鈥滄暟鎹簱杩炴帴澶辫触锛佲€?;
聽聽聽聽聽聽聽聽聽聽聽聽e.printStackTrace();
聽聽聽聽聽聽聽聽}
聽聽聽聽} }
鍦ㄧず渚嬩唬鐮佷腑锛屾垜浠鍏堝缓绔嬩簡涓€涓暟鎹簱杩炴帴锛屽苟涓旀寚瀹氫簡鏁版嵁搴撶殑URL銆佺敤鎴峰悕鍜屽瘑鐮併€傜劧鍚庯紝鎴戜滑瀹氫箟浜嗚淇濆瓨鐨勬暟鎹紝鍖呮嫭name銆乤ge鍜宔mail銆傛帴涓嬫潵锛屾垜浠垱寤轰簡涓€涓狪NSERT璇彞锛屽苟涓斾娇鐢≒reparedStatement瀵硅薄鏉ヨ缃彃鍏ュ弬鏁扮殑鍊笺€傛渶鍚庯紝鎴戜滑閫氳繃璋冪敤executeUpdate()鏂规硶鏉ユ墽琛屾彃鍏ユ搷浣滐紝骞舵鏌ユ彃鍏ョ殑琛屾暟鏄惁澶т簬0锛屼互鍒ゆ柇鎻掑叆鏄惁鎴愬姛銆?br/>璇锋敞鎰忥紝绀轰緥浠g爜涓娇鐢ㄤ簡try-with-resources璇彞鏉ヨ嚜鍔ㄥ叧闂暟鎹簱杩炴帴锛屽湪Java 7鍙婁互涓婄増鏈腑鍙敤銆傛澶栵紝绀轰緥涓殑琛ㄥ悕涓簎sers锛岄渶鏍规嵁瀹為檯鎯呭喌杩涜淇敼銆?br/>