java项目实战-超市管理系统（七）如何导入数据到数据库？Dao包源码与分析

package duan.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

import duan.db.DbClose;
import duan.db.DbConn;
import duan.entity.Goods;
import duan.tools.ScannerChoice;

import java.sql.DriverManager;
import java.sql.Statement;

/**
 * 数据库goods表操作
 * @author duan
 */
public final class GoodsDao 
{
		Connection        conn  = null;
		PreparedStatement pstmt = null;
		ResultSet 		  rs    = null;
		
	
	/**
	 * 1.添加商品到数据库goods表
	 * @param goods 商品对象
	 * @return boolean
	 */
	public boolean addGoods(Goods goods)
	{
		boolean bool = false;
		conn = DbConn.getconn();
		String sql = "INSERT INTO GOODS(gid,GNAME,GPRICE,GNUM) VALUES(?,?,?,?)";
			
			try
			{
				pstmt = conn.prepareStatement(sql);
				pstmt.setInt(1,goods.getGid());
				pstmt.setString(2,goods.getGname());
				pstmt.setDouble(3,goods.getGprice());
				pstmt.setInt(4,goods.getGnum());
				
				int rs = pstmt.executeUpdate();
				if (rs > 0)
				{
					bool = true;
				}
			} catch (SQLException e)
			{
				e.printStackTrace();
			}finally
					{
						DbClose.addClose(pstmt,conn);
					}
	 return bool;
	}

	/**
	 * 2.更改商品信息到数据库goods表
	 * @param key   选择要更改商品信息
	 * @param goods 商品对象
	 * @return boolean
	 */
	public boolean updateGoods(int key,Goods goods)
	{
		boolean bool = false;
		conn = DbConn.getconn();
			switch (key)
			{
			case 1:		//	key=1,更改商品名称
						String sqlName = "UPDATE GOODS SET GNAME=? WHERE GID=?";
						
					    try
						{
							pstmt = conn.prepareStatement(sqlName);
							pstmt.setString(1, goods.getGname());
							pstmt.setInt(2,goods.getGid());
							
							int rs = pstmt.executeUpdate();
							if (rs > 0)
							{
								bool = true;
							}
						} catch (SQLException e)
						{
							e.printStackTrace();
						}finally{
									DbClose.addClose(pstmt,conn);
								}
				break;
			case 2:		//	key=2,更改商品价格
						String sqlPrice = "UPDATE GOODS SET GPRICE=? WHERE GID=?";
						
						try
						{
							pstmt = conn.prepareStatement(sqlPrice);
							pstmt.setDouble(1, goods.getGprice());
							pstmt.setInt(2,goods.getGid());
							
							int rs = pstmt.executeUpdate();
							if (rs > 0)
							{
								bool = true;
							}
						} catch (SQLException e)
						{
							e.printStackTrace();
						}finally{
									DbClose.addClose(pstmt,conn);
								}
				break;
			case 3:		//	key=3,更改商品数量
						String sqlNum = "UPDATE GOODS SET GNUM=? WHERE GID=?";
							
						try
						{
							pstmt = conn.prepareStatement(sqlNum);
							pstmt.setInt(1, goods.getGnum());
							pstmt.setInt(2,goods.getGid());
							
							int rs = pstmt.executeUpdate();
							if (rs > 0)
							{
								bool = true;
							}
						} catch (SQLException e)
						{
							e.printStackTrace();
						}finally{
									DbClose.addClose(pstmt,conn);
								}
				break;
			default:
				break;
			}
		return bool;
	}
	
	/**
	 * 3.从数据库goods表中-刪除商品
	 * @param gid 商品编号
	 * @return boolean
	 */
	public boolean deleteGoods(int gid)
	{
		boolean bool = false;