studentdaoimpl.java

实现从用户登陆页面到用户信息页面的跳转。完成数据库连接

package cn.com.yunda.daoImpl;

import java.sql.ResultSet;
import java.util.ArrayList;

import cn.com.yunda.dao.StudentDAO;
import cn.com.yunda.vo.StudentInfo;
import cn.com.yunda.util.*;

/**
 *
 *@author baiwei
 *@version 2008-11-6 下午06:49:47
 */
public class StudentDAOImpl implements StudentDAO{
	
	public void deleteStudent(StudentInfo student) {
		// TODO Auto-generated method stub
		JDBConnection jdb=new JDBConnection();
		String deleteStudent="delete from t_studentInfo where sId='"+student.getSid()+"'";
		try{
		jdb.delete(deleteStudent);	
		jdb.close();		
		}catch(Exception e){
			
		}
	}
	public void insertStudent(StudentInfo student) {
		// TODO Auto-generated method stub
		JDBConnection jdb=new JDBConnection();
		String insertStudent="insert into t_studentInfo values('"+student.getSid()+"','"+student.getSname()+"','"+student.getSage()+"','"+student.getTeamid()+"','"+student.getSaddr()+"','"+student.getSduty()+"','"+student.getPassword()+"')";
		try{
		jdb.insert(insertStudent);
		jdb.close();
		}
		catch(Exception e)
		{
			
		}
	}
	public ArrayList<StudentInfo> selectStudentByIdAndName(String studentId,String passWord) {
		// TODO Auto-generated method stub
		JDBConnection jdb=new JDBConnection();
		String selectStudentById="select * from t_studentInfo where sId='"+studentId+"' and password='"+passWord+"'";
		ResultSet rs=jdb.query(selectStudentById);
	
		ArrayList<StudentInfo> studentList=new ArrayList<StudentInfo>();
		try{
		while(rs.next()){
		
		String sId=rs.getString("sId");
		String sName=rs.getString("sName");
		String sAge=rs.getString("sAge");
		String teamID=rs.getString("teamID");
		String sAddr=rs.getString("sAddr");
		String password=rs.getString("password");
		String sDuty=rs.getString("sDuty");
		
		StudentInfo stdInfo=new StudentInfo();
		stdInfo.setSname(sName);
		stdInfo.setSid(sId);
		stdInfo.setSage(sAge);
		stdInfo.setTeamid(teamID);
		stdInfo.setSaddr(sAddr);
		stdInfo.setPassword(password);
		stdInfo.setSduty(sDuty);
			
		studentList.add(stdInfo);	
		}
		}catch(Exception e){
	
		}
		jdb.close();
        System.out.println(studentList.size());
		return studentList;
	}
	public void updateStudent(StudentInfo student) {
		// TODO Auto-generated method stub
	JDBConnection jdb=new JDBConnection();
	String updateStudent="update t_studentInfo set sName='"+student.getSname()+"',sAge='"+student.getSage()+"',teamID='"+student.getTeamid()+"',sAddr='"+student.getSaddr()+"',sDuty='"+student.getSduty()+"',password='"+student.getPassword()+"' where sId='"+student.getSid()+"'";
	jdb.update(updateStudent);
	jdb.close();
	}
	public ArrayList<StudentInfo> selectAllStudent() {
		// TODO Auto-generated method stub
		JDBConnection jdb=new JDBConnection();
		String selectAllStudent="select * from t_studentInfo";
		ResultSet rs=jdb.query(selectAllStudent);
		ArrayList<StudentInfo> studentList=new ArrayList<StudentInfo>();
		try{
			while(rs.next()){
				
				String sId=rs.getString("sId");
				String sName=rs.getString("sName");
				String sAge=rs.getString("sAge");
				String teamID=rs.getString("teamID");
				String sAddr=rs.getString("sAddr");
				String password=rs.getString("password");
				String sDuty=rs.getString("sDuty");
				
				StudentInfo stdInfo=new StudentInfo();
				stdInfo.setSname(sName);
				stdInfo.setSid(sId);
				stdInfo.setSage(sAge);
				stdInfo.setTeamid(teamID);
				stdInfo.setSaddr(sAddr);
				stdInfo.setPassword(password);
				stdInfo.setSduty(sDuty);
					
				studentList.add(stdInfo);	
			}
		}catch(Exception e){
			
			
		}
		jdb.close();
        System.out.println(studentList.size());
		return studentList;
	}
	public ArrayList<StudentInfo> selectStudentById(String studentId) {
		// TODO Auto-generated method stub
		JDBConnection jdb=new JDBConnection();
		String selectStudentById="select * from t_studentInfo where sId='"+studentId+"'";
		ResultSet rs=jdb.query(selectStudentById);
	
		ArrayList<StudentInfo> studentList=new ArrayList<StudentInfo>();
		try{
		while(rs.next()){
		
		String sId=rs.getString("sId");
		String sName=rs.getString("sName");
		String sAge=rs.getString("sAge");
		String teamID=rs.getString("teamID");
		String sAddr=rs.getString("sAddr");
		String password=rs.getString("password");
		String sDuty=rs.getString("sDuty");
		sAge=sAge.trim();
		StudentInfo stdInfo=new StudentInfo();
		stdInfo.setSname(sName);
		stdInfo.setSid(sId);
		stdInfo.setSage(sAge);
		stdInfo.setTeamid(teamID);
		stdInfo.setSaddr(sAddr);
		stdInfo.setPassword(password);
		stdInfo.setSduty(sDuty);
			
		studentList.add(stdInfo);	
		}
		}catch(Exception e){
	
		}
		jdb.close();
        System.out.println(studentList.size());
		return studentList;
		
	}
	

}