package?DAO;

import?java.util.ArrayList;
import?java.util.List;

import?Util.jdbcUtil;
import?Vo.User;

import?java.sql.*;
public?class?userDao?{
	
	public?userDao（）{}
	
	//查詢數(shù)據(jù)庫(kù)中所有學(xué)生的基本信息
	public?List?queryAll（）{
		Connection?conn=null;
		PreparedStatement?st=null;
		ResultSet?rs=null;
		List?userList=new?ArrayList（）;
		
		try{
			conn=jdbcUtil.getconn（）;
			String?sql=“select?*?from?students_info“;
			st=conn.prepareStatement（sql）;
			rs=st.executeQuery（）;
			while（rs.next（））{
				User?user=new?User（）;
				user.id=rs.getInt（“id“）;
				user.name=rs.getString（“name“）;
				user.sex=rs.getString（“sex“）;
				user.age=rs.getInt（“age“）;
				user.weight=rs.getFloat（“weight“）;
				user.height=rs.getFloat（“height“）;
				userList.add（user）;
			}
			
			
		}catch（Exception?e）{e.printStackTrace（）;
		
		}finally{
		
		??jdbcUtil.free（rs?st?conn）;
		}
		
		return?userList;
			
	}
	//根據(jù)id值查詢數(shù)據(jù)庫(kù)中的學(xué)生信息
	

	public?User?findUserById（int?id）{
		User?user=new?User（）;
		Connection?conn=null;
		PreparedStatement?st=null;
		ResultSet?rs=null;
		
		
		try{
			conn=jdbcUtil.getconn（）;
			String?sql=“select?*?from?students_info?where?id=?“;
			st=conn.prepareStatement（sql）;
			st.setInt（1?id）;
			rs=st.executeQuery（）;
			while（rs.next（））{
				
				user.id=rs.getInt（“id“）;
				user.name=rs.getString（“name“）;
				user.sex=rs.getString（“sex“）;
				user.age=rs.getInt（“age“）;
				user.weight=rs.getFloat（“weight“）;
				user.height=rs.getFloat（“height“）;
			
			}
			
			
		}catch（Exception?e）{e.printStackTrace（）;
		
		}finally{
		
		??jdbcUtil.free（rs?st?conn）;
		}
		
		
		return?user;
	}
	
	
	
	
	//增加學(xué)生信息
	public?int?add（User?user）{
		int?n=0;
		Connection?conn=null;
		PreparedStatement?st=null;
		ResultSet?rs=null;
		
		
		try{
			conn=jdbcUtil.getconn（）;
			String?sql=“insert?into?students_info?values（??????）“;
			st=conn.prepareStatement（sql）;
			st.setInt（1?user.getId（））;
			st.setString（2?user.getName（））;
			st.setString（3?user.getSex（））;
			st.setInt（4?user.getAge（））;
			st.setFloat（5?user.getWeight（））;
			st.setFloat（6?user.getHeight（））;
			
		????n=st.executeUpdate（）;
			
			
			
		}catch（Exception?e）{e.printStackTrace（）;
		
		}finally{
		
		??jdbcUtil.free（rs?st?conn）;
		}
		
		return?n;
	}
	
	//修改某個(gè)學(xué)生的信息
	public?int?update（User?user）{
		int?n=0;
		Connection?conn=null;
		PreparedStatement?st=null;
		ResultSet?rs=null;
		
		
		try{
			conn=jdbcUtil.getconn（）;
			String?sql=“update?students_info?set?name=?sex=?age=?weight=?height=??where?id=?“;
			st=conn.prepareStatement（sql）;
			st.setInt（6?user.getId（））;
			st.setString（1?user.getName（））;
			st.setString（2?user.getSex（））;
			st.setInt（3?user.getAge（））;
			st.setFloat（4?user.getWeight（））;
			st.setFloat（5?user.getHeight（））;
			
		????n=st.executeUpdate（）;
			
			
			
		}catch（Exception?e）{e.printStackTrace（）;
		
		}finally{
		

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2020-05-06?21:33??StuDatabase\
?????文件????????1171??2020-05-06?22:29??StuDatabase\.classpath
?????文件????????1336??2020-05-07?16:11??StuDatabase\.project
?????目錄???????????0??2020-05-06?21:33??StuDatabase\.settings\
?????文件?????????522??2020-05-06?21:33??StuDatabase\.settings\.jsdtscope
?????文件?????????364??2020-05-06?21:33??StuDatabase\.settings\org.eclipse.jdt.core.prefs
?????文件?????????492??2020-05-06?21:33??StuDatabase\.settings\org.eclipse.wst.common.component
?????文件?????????414??2020-05-06?21:33??StuDatabase\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2020-05-06?21:33??StuDatabase\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2020-05-06?21:33??StuDatabase\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2020-05-07?00:53??StuDatabase\src\
?????目錄???????????0??2020-05-07?02:09??StuDatabase\src\DAO\
?????文件????????3607??2020-05-07?03:35??StuDatabase\src\DAO\userDao.java
?????文件?????????152??2020-05-21?17:10??StuDatabase\src\db.properties
?????目錄???????????0??2020-05-07?02:15??StuDatabase\src\Test\
?????文件????????1486??2020-05-07?03:57??StuDatabase\src\Test\testUserDao.java
?????文件?????????647??2020-05-06?22:46??StuDatabase\src\Test\testUtil.java
?????目錄???????????0??2020-05-07?02:09??StuDatabase\src\Util\
?????文件????????1319??2020-05-06?22:19??StuDatabase\src\Util\jdbcUtil.java
?????目錄???????????0??2020-05-07?00:54??StuDatabase\src\Vo\
?????文件?????????810??2020-05-07?02:10??StuDatabase\src\Vo\User.java
?????目錄???????????0??2020-05-07?16:10??StuDatabase\WebRoot\
?????文件????????2859??2020-04-29?02:13??StuDatabase\WebRoot\addStudent.jsp
?????文件????????1442??2020-05-07?20:25??StuDatabase\WebRoot\delete.jsp
?????文件????????3331??2020-05-07?17:00??StuDatabase\WebRoot\edit.jsp
?????文件????????1941??2020-05-07?17:05??StuDatabase\WebRoot\editDB.jsp
?????文件????????3667??2020-04-27?15:57??StuDatabase\WebRoot\findStudent.jsp
?????文件????????1128??2020-04-27?02:13??StuDatabase\WebRoot\index.jsp
?????文件????????1035??2020-04-29?01:50??StuDatabase\WebRoot\index_left.jsp
?????文件?????????858??2020-04-27?02:14??StuDatabase\WebRoot\index_right.jsp
?????文件?????????884??2020-04-27?03:07??StuDatabase\WebRoot\index_title.jsp
............此處省略19個(gè)文件信息