package?com.jdbc;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.util.ArrayList;
import?java.util.List;

import?com.springemployee.crud.entities.Employee;


public?class?JDBC?{
	?PreparedStatement?ps;
?????ResultSet?rs;
????
????//寫一個連接數據庫的方法
????private?static?Connection?getConnection（）{
????	String?url=“jdbc:mysql://localhost:3306/emp“;
????	String?userName=“root“;
????	String?password=“123456“;
????	Connection?conn=null;
???????
????	try{
????		Class.forName（“com.mysql.jdbc.Driver“）;
????	}catch（ClassNotFoundException?e）{
????		System.out.println（“找不到驅動！“）;
????		e.printStackTrace（）;
????	}
????	
????	try{
????		conn=DriverManager.getConnection（urluserNamepassword）;
????		if（conn!=null）{
????			System.out.println（“connection?successful“）;
????		}
????	}catch（SQLException?e）{
????		System.out.println（“connection?fail“）;
????		e.printStackTrace（）;
????	}
????	return?conn;
????}
????//寫一個查詢數據庫語句的方法
????
????
????public?static?int?insert（Employee?employee）?{
????	Connection?conn?=?getConnection（）;
????????int?i?=?0;
????????String?sql?=?“insert?into?Employee?（lastNameemailgenderdepartment）?values（????）“;
????????PreparedStatement?pstmt;
????????try?{
????????????pstmt?=?（PreparedStatement）?conn.prepareStatement（sql）;
????????????pstmt.setString（1?employee.getLastName（））;
????????????pstmt.setString（2?employee.getEmail（））;
????????????pstmt.setInt（3?employee.getGender（））;
????????????pstmt.setInt（4?employee.getDepartment（））;
????????????pstmt.execute（）;
????????????pstmt.close（）;
????????????conn.close（）;
????????}?catch?（SQLException?e）?{
????????????e.printStackTrace（）;
????????}
????????return?i;
????}
????
????
????
????public?static?int?update（Employee?employee）?{
????	Connection?conn?=?getConnection（）;
????????int?i?=?0;
????????String?sql?=?“update?Employee?set?lastName=‘“+employee.getLastName（）+“‘?email=‘“+employee.getEmail（）+“‘?gender=“+employee.getGender（）+“?department=“+employee.getDepartment（）+“?where?id=“?+employee.getId（）;
????????PreparedStatement?pstmt;
????????try?{
????????????pstmt?=?（PreparedStatement）?conn.prepareStatement（sql）;
????????????i?=?pstmt.executeUpdate（）;
????????????System.out.println（“resutl:?“?+?i）;
????????????pstmt.close（）;
????????????conn.close（）;
????????}?catch?（SQLException?e）?{
????????????e.printStackTrace（）;
????????}
????????return?i;
????}
????
????
????public?static?List?getAll（）?{
????	Connection?conn?=?getConnection（）;
????	List?list=new?ArrayList（）;
????????String?sql?=?“select?*?from?Employee“;
????????PreparedStatement?pstmt;
????????try?{
????????????pstmt?=?（PreparedStatement）conn.prepareStatement（sql）;
????????????ResultSet?rs?=?pstmt.executeQuery（）;
???????????//?int?col?=?rs.getmetaData（）.getColumnCount（）;
????????????System.out.println（“=

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-03-23?16:01??springemployee\
?????文件?????????898??2017-03-21?14:18??springemployee\.classpath
?????文件????????1122??2017-03-16?10:22??springemployee\.project
?????目錄???????????0??2017-03-16?11:58??springemployee\.settings\
?????文件?????????567??2017-03-16?10:11??springemployee\.settings\.jsdtscope
?????文件?????????122??2017-03-22?19:10??springemployee\.settings\org.eclipse.core.resources.prefs
?????文件?????????364??2017-03-16?10:11??springemployee\.settings\org.eclipse.jdt.core.prefs
?????文件?????????494??2017-03-16?10:11??springemployee\.settings\org.eclipse.wst.common.component
?????文件?????????349??2017-03-16?10:11??springemployee\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2017-03-16?10:11??springemployee\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2017-03-16?10:11??springemployee\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????文件?????????455??2017-03-16?10:22??springemployee\.springBeans
?????目錄???????????0??2017-03-16?10:11??springemployee\build\
?????目錄???????????0??2017-03-25?09:41??springemployee\build\classes\
?????目錄???????????0??2017-03-25?09:41??springemployee\build\classes\com\
?????目錄???????????0??2017-03-25?09:41??springemployee\build\classes\com\jdbc\
?????文件????????5260??2017-03-25?09:41??springemployee\build\classes\com\jdbc\JDBC.class
?????文件????????4898??2017-03-25?09:41??springemployee\build\classes\com\jdbc\JdbcUtil.class
?????目錄???????????0??2017-03-25?09:41??springemployee\build\classes\com\springemployee\
?????目錄???????????0??2017-03-25?09:41??springemployee\build\classes\com\springemployee\crud\
?????目錄???????????0??2017-03-25?09:41??springemployee\build\classes\com\springemployee\crud\dao\
?????文件????????1567??2017-03-25?09:41??springemployee\build\classes\com\springemployee\crud\dao\DepartmentDao.class
?????文件????????1417??2017-03-25?09:41??springemployee\build\classes\com\springemployee\crud\dao\EmployeeDao.class
?????目錄???????????0??2017-03-25?09:41??springemployee\build\classes\com\springemployee\crud\entities\
?????文件????????1405??2017-03-25?09:41??springemployee\build\classes\com\springemployee\crud\entities\Department.class
?????文件????????2226??2017-03-25?09:41??springemployee\build\classes\com\springemployee\crud\entities\Employee.class
?????目錄???????????0??2017-03-25?09:41??springemployee\build\classes\com\springemployee\crud\handlers\
?????文件????????3512??2017-03-25?09:41??springemployee\build\classes\com\springemployee\crud\handlers\EmployeeHandler.class
?????文件????????3524??2017-03-25?09:41??springemployee\build\classes\com\springemployee\crud\handlers\JdbcTest.class
?????文件????????1165??2017-03-20?10:03??springemployee\build\classes\springmvc.xml
?????文件?????????857??2017-03-25?09:45??springemployee\emp.sql
............此處省略59個文件信息