package?com.xyyz.jdbc;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;

public?class?JDBCDemo?{

	public?static?void?main（String[]?args）?throws?Exception?{
		query（）;
		insert（）;
		query（）;
		update（）;
		query（）;
		delete（）;
		query（）;
	}

	/**
	?*?查詢代碼
	?*?
	?*?@throws?Exception
	?*/
	public?static?void?query（）?throws?Exception?{
		//?注冊驅動
		Class.forName（“com.mysql.jdbc.Driver“）;
		//?連接數據需要的參數
		String?url?=?“jdbc:mysql:///jdbctestdata“;
		String?user?=?“root“;
		String?password?=?“root“;
		//?獲取數據庫連接
		Connection?connection?=?DriverManager.getConnection（url?user?password）;
		String?sql?=?“select?*?from?jdbctestdata“;
		//?獲取預編譯對象
		PreparedStatement?prepareStatement?=?connection.prepareStatement（sql）;
		//?執行sql語句
		ResultSet?resultSet?=?prepareStatement.executeQuery（）;
		//?遍歷打印sql語句
		while?（resultSet.next（））?{
			System.out.println（resultSet.getInt（1）?+?“--“?+?resultSet.getString（2））;
		}
		//?關閉釋放資源
		resultSet.close（）;
		prepareStatement.close（）;
		connection.close（）;
	}

	/**
	?*?插入數據
	?*/
	public?static?void?insert（）?throws?Exception?{
		//?注冊驅動
		Class.forName（“com.mysql.jdbc.Driver“）;
		//?連接數據需要的參數
		String?url?=?“jdbc:mysql:///jdbctestdata“;
		String?user?=?“root“;
		String?password?=?“root“;
		//?獲取數據庫連接
		Connection?connection?=?DriverManager.getConnection（url?user?password）;
		String?sql?=?“insert?into?jdbctestdata?value（???）“;
		//?獲取預編譯對象
		PreparedStatement?prepare?=?connection.prepareStatement（sql）;
		prepare.setString（1?“6“）;
		prepare.setString（2?“小白“）;
		prepare.setString（3?“30“）;
		int?i?=?prepare.executeUpdate（）;
		System.out.println（“i=“?+?i）;
		//?執行sql語句
		prepare.close（）;
		connection.close（）;
	}

	/**
	?*?更新數據
	?*/
	public?static?void?update（）?throws?Exception?{
		//?注冊驅動
		Class.forName（“com.mysql.jdbc.Driver“）;
		//?連接數據需要的參數
		String?url?=?“jdbc:mysql:///jdbctestdata“;
		String?user?=?“root“;
		String?password?=?“root“;
		//?獲取數據庫連接
		Connection?connection?=?DriverManager.getConnection（url?user?password）;
		String?sql?=?“update?jdbctestdata?set?name=???age=??where?id=?“;
		//?獲取預編譯對象
		PreparedStatement?prepare?=?connection.prepareStatement（sql）;
		prepare.setString（1?“小紅“）;
		prepare.setString（2?“20“）;
		prepare.setString（3?“6“）;
		int?i?=?prepare.executeUpdate（）;
		System.out.println（“i=“?+?i）;
		//?執行sql語句
		prepare.close（）;
		connection.close（）;
	}

	/**
	?*?刪除數據
	?*/
	public?static?void?delete（）?throws?Exception?{
		//?注冊驅動
		Class.forName（“com.mysql.jdbc.Driver“）;
		//?連接數據需要的參數
		String?url?=?“jdbc:mysql:///jdbctestdata“;
		String?user?=?“root“;
		String?password?=?“root“;
		//?獲取數據庫連接
		Connection?connection?=?DriverManager.getConnection（url?user?password）;
		String?sql?=?“delete?from?jdbctestdata?where?id?=??“;
		//?獲取預編譯對象
		PreparedStatement?prepare?=?connection.prepareStatement（sql）;
		prepare.setStr

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-07-04?21:32??JDBC\
?????文件?????????456??2017-07-04?22:12??JDBC\.classpath
?????文件?????????380??2017-07-04?21:20??JDBC\.project
?????目錄???????????0??2017-07-04?21:20??JDBC\.settings\
?????文件?????????598??2017-07-04?21:20??JDBC\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2017-07-04?22:12??JDBC\bin\
?????目錄???????????0??2017-07-04?22:12??JDBC\bin\com\
?????目錄???????????0??2017-07-04?22:12??JDBC\bin\com\xyyz\
?????目錄???????????0??2017-07-04?22:12??JDBC\bin\com\xyyz\jdbc\
?????文件????????3247??2017-07-04?22:35??JDBC\bin\com\xyyz\jdbc\JDBCDemo.class
?????目錄???????????0??2017-07-04?21:32??JDBC\lib\
?????文件??????540852??2017-07-04?21:32??JDBC\lib\mysql-connector-java-5.0.8-bin.jar
?????目錄???????????0??2017-07-04?21:21??JDBC\src\
?????目錄???????????0??2017-07-04?22:04??JDBC\src\com\
?????目錄???????????0??2017-07-04?22:04??JDBC\src\com\xyyz\
?????目錄???????????0??2017-07-04?21:21??JDBC\src\com\xyyz\jdbc\
?????文件????????3461??2017-07-04?22:35??JDBC\src\com\xyyz\jdbc\JDBCDemo.java