package?com.xyyz.jdbc;

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

import?com.xyyz.utils.JDBCUtils;

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?{
		Connection?connection?=?JDBCUtils.getConnection（）;
		//?獲取數(shù)據(jù)庫連接
		String?sql?=?“select?*?from?jdbctestdata“;
		//?獲取預編譯對象
		PreparedStatement?prepareStatement?=?connection.prepareStatement（sql）;
		//?執(zhí)行sql語句
		ResultSet?resultSet?=?prepareStatement.executeQuery（）;
		//?遍歷打印sql語句
		while?（resultSet.next（））?{
			System.ou

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件?????????917??2017-07-04?22:03??JdbcTestDemo.sql
?????目錄???????????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:43??JDBC\bin\com\xyyz\
?????目錄???????????0??2017-07-04?22:12??JDBC\bin\com\xyyz\jdbc\
?????文件????????2736??2017-07-04?23:17??JDBC\bin\com\xyyz\jdbc\JDBCDemo.class
?????目錄???????????0??2017-07-04?22:43??JDBC\bin\com\xyyz\utils\
?????文件????????1872??2017-07-04?23:14??JDBC\bin\com\xyyz\utils\JDBCUtils.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:43??JDBC\src\com\xyyz\
?????目錄???????????0??2017-07-04?21:21??JDBC\src\com\xyyz\jdbc\
?????文件????????2639??2017-07-04?23:17??JDBC\src\com\xyyz\jdbc\JDBCDemo.java
?????目錄???????????0??2017-07-04?22:43??JDBC\src\com\xyyz\utils\
?????文件????????1431??2017-07-04?23:14??JDBC\src\com\xyyz\utils\JDBCUtils.java