package?DAO;
import?java.io.UnsupportedEncodingException;
import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.util.HashMap;
import?java.util.List;
import?java.util.Map;


import?javax.swing.ButtonGroup;
import?javax.swing.ButtonModel;
import?javax.swing.DefaultListModel;
import?javax.swing.JComboBox;
import?javax.swing.JLabel;
import?javax.swing.JList;
import?javax.swing.JPasswordField;
import?javax.swing.JRadioButton;
import?javax.swing.JTextField;
import?javax.swing.ListModel;

import?Model.user;
import?Model.Student;
import?Util.DBConnection;
import?View.Mainframe;
///////////////////////////////////此處部分代碼實現來自對StudentScore中對班級操作代碼的更改
public?class?InfoDAO?{
	///////////////////////////////登錄檢查
	public?void??logincheck（JTextField?nameJPasswordField?pwJLabel?label）
	{
		String?usersym?=?null;
		login?c?=?new?login（）;
		user?us?=?new?user（）;
		usersym=c.check（namepwus）;
		label.setText（usersym）;
		if（usersym.equals（“登錄成功“））{
			Mainframe?ma?=?new?Mainframe（）;
			ma.setVisible（true）;
		}
	}
	////////////////////////////////顯示列表中人的名字
	public?void?showlist?（JList?namelist）{
		List?user=?null;
		DBConnection?db?=?new?DBConnection（）;
		user=?db.getList（“select?name?from?info?“）;
		DefaultListModel?listModel?=?new?DefaultListModel（）;
		for（int?i?=0;i			Map?m?=?null;
			object?o?=?null?;
			o?=?user.get（i）;
			m?=?（HashMap）o;
			listModel.addElement（m.get（“name“））;
		}
		namelist.setModel（listModel）;
	}
	///////////////////////////////////顯示選中人的信息
	public?Student?showinfo（Connection?conString?name）?throws?Exception{
		String?sql=“SELECT?*?FROM?info?where?name=?“;
		sql=new?String（sql.getBytes（“ISO-8859-1“）“UTF-8“）;
		PreparedStatement?pstmt=con.prepareStatement（sql）;
		Student?usif=new?Student（）;
		ResultSet?rs=null;
		if（name!=null）{
		?pstmt.setString（1?name）;
		rs=pstmt.executeQuery（）;
		while?（rs.next（））{
			usif.setId（rs.getInt（“id“））;
			usif.setAddress（rs.getString（“address“））;
			usif.setBirthday（rs.getString（“birthday“））;
			usif.setName（rs.getString（“name“））;
			usif.setSex（rs.getString（“sex“））;
			usif.setTel（rs.getString（“tel“））;
		}
		}
		return?usif;
		}
	//////////////////////////////////通過人的名字查詢信息
	???public?void?findbyname?（JTextField?searchnameJList?namelist）{
		???String?name?=?searchname.getText（）;
		???ListModel?listModel?=?new?DefaultListModel（）;
		???listModel?=?namelist.getModel（）;
		???int?j?=?0;
		???for（int?i=?0;i			??
			???if（listModel.getElementAt（i）.equals（name））?{namelist.setSelectedIndex（i）;?j?=?1;}
			}
		???if（j==0）?System.out.println（“找不到該user“）;
	}
	???/////////////////////////////////查詢人數的方法
	???public?int?findnum?（JList?namelist）{
		???ListModel?listModel?=?new?DefaultListModel（）;
		???listModel?=?namelist.getModel（）;
		???int?i=listModel.getSize（）;
		???return?i;
	}
	???///////////////////

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-06-03?00:09??tongxinlu\
?????文件?????????306??2017-06-03?00:09??tongxinlu\.classpath
?????文件?????????385??2017-06-02?21:12??tongxinlu\.project
?????目錄???????????0??2017-06-02?21:12??tongxinlu\.settings\
?????文件?????????598??2017-06-02?21:12??tongxinlu\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2017-06-03?00:09??tongxinlu\bin\
?????目錄???????????0??2017-06-03?14:25??tongxinlu\bin\DAO\
?????文件????????5447??2017-06-03?14:45??tongxinlu\bin\DAO\InfoDAO.class
?????文件????????2283??2017-06-03?00:09??tongxinlu\bin\DAO\login.class
?????目錄???????????0??2017-06-03?00:09??tongxinlu\bin\images\
?????文件???????19889??2017-06-02?21:39??tongxinlu\bin\images\1.jpg
?????文件??????160972??2017-06-02?21:39??tongxinlu\bin\images\7.jpg
?????文件???????47652??2017-06-02?21:39??tongxinlu\bin\images\a.jpg
?????目錄???????????0??2017-06-03?00:09??tongxinlu\bin\Model\
?????文件????????1723??2017-06-03?00:09??tongxinlu\bin\Model\Student.class
?????文件????????1067??2017-06-03?00:09??tongxinlu\bin\Model\user.class
?????目錄???????????0??2017-06-03?00:09??tongxinlu\bin\Util\
?????文件????????5429??2017-06-03?14:45??tongxinlu\bin\Util\DBConnection.class
?????目錄???????????0??2017-06-03?12:36??tongxinlu\bin\View\
?????文件?????????692??2017-06-03?00:09??tongxinlu\bin\View\Login$1.class
?????文件?????????991??2017-06-03?00:09??tongxinlu\bin\View\Login$2.class
?????文件?????????867??2017-06-03?00:09??tongxinlu\bin\View\Login$3.class
?????文件????????2976??2017-06-03?00:09??tongxinlu\bin\View\Login.class
?????文件?????????712??2017-06-03?14:50??tongxinlu\bin\View\Mainframe$1.class
?????文件????????1972??2017-06-03?14:50??tongxinlu\bin\View\Mainframe$2.class
?????文件????????2161??2017-06-03?14:50??tongxinlu\bin\View\Mainframe$3.class
?????文件????????1944??2017-06-03?14:50??tongxinlu\bin\View\Mainframe$4.class
?????文件?????????921??2017-06-03?14:50??tongxinlu\bin\View\Mainframe$5.class
?????文件????????1945??2017-06-03?14:50??tongxinlu\bin\View\Mainframe$6.class
?????文件?????????912??2017-06-03?14:50??tongxinlu\bin\View\Mainframe$7.class
?????文件????????1098??2017-06-03?14:50??tongxinlu\bin\View\Mainframe$8.class
............此處省略19個文件信息