package com.ata.shoping.user;


import java.sql.*;
import java.util.ArrayList;
import java.util.Iterator;


public class JDBC {

		public static Connection getConnection()throws SQLException,InstantiationException,IllegalAccessException,ClassNotFoundException{
		
		Connection conn=null;
		
		//加載數據庫驅動
		Class.forName("com.mysql.jdbc.Driver");
		//數據庫連接
		String url="jdbc:mysql://192.168.2.187:3306/My_db";
		//數據庫用戶名稱
		String user="root";
		//數據庫密碼
		String password="root";
		//根據數據庫取得一個數據庫的鏈接
		conn=DriverManager.getConnection(url,user,password);
		return conn;
		
	}
	
	
	
	//根據SQL語句返回一個對象的鏈表
	public ArrayList select(String sql)throws Exception{
		ArrayList<User> result=new ArrayList<User>();
		Connection conn=null;
		Statement stmt=null;
		ResultSet rs=null;
		
		try{
			conn=getConnection();
			stmt=conn.createStatement();
			rs=stmt.executeQuery(sql);
			while(rs.next()){
				User user1=new User();
				user1.setUsername(rs.getString("username"));

//				product1.setNumber(rs.getInt("number"));
				
				
				result.add(user1);
				
				
				
			}
			
			
			
			
		}
		catch(SQLException sqle){
			sqle.printStackTrace();
		}
		catch(Exception e){
			e.printStackTrace();
		}
		finally{
			try{
			if(rs !=null){
				rs.next();
			}
			}
			catch(Exception e){
				e.printStackTrace();
			}
			try{
				if(stmt !=null)
					stmt.close();
			}
			catch(Exception e){
				e.printStackTrace();
			}
			try{
				if(conn !=null)
					conn.close();
			}
			catch(Exception e){
				e.printStackTrace();
			}
		}
		
		return result;
	}
	
	//使用鏈表進行插入
	
	
	
	
	
	
	//根據傳入的對象向數據庫插入一條數據
	
	

}