503b6d3da2b1001d1de7ee8c06cd5ee5

jsp的课程实践

package student.dao;
import java.io.UnsupportedEncodingException;
import java.sql.ResultSet;
import java.sql.SQLException;

import student.beans.Student;
public class StudentDAO {
	private DataBase db;
	public StudentDAO()
	{
		super();
		db=new DataBase();
	}
    public Student getStudentInfo(String stuNum)
    {
    	Student student=null;
    	try
    	{
        	String sql="select * from student2 where stuNum='"+stuNum+"'";
        	ResultSet rst=db.executeQuery(sql);
        	while(rst.next())
        	{
        		String stuNum2=rst.getString("stuNum");
        		String stuName=rst.getString("stuName");
        		String sex=rst.getString("sex");
        		String stuCollege=rst.getString("stuCollege");
        		String stuClass=rst.getString("stuClass");
        		String stuPass=rst.getString("stuPass");
        		student=new Student(stuNum2,stuName,stuCollege,stuClass,stuPass,sex);
        	}
    	}
    	catch(SQLException ex)
    	{
    		ex.printStackTrace();
    	}
    	return student;
    }
    public String getPass(String stuNum)
    {
    	String stuPass=null;
    	try
    	{
    		String sql="select stuPass from student2 where stuNum= '"+stuNum+"'";
        	ResultSet rst=db.executeQuery(sql);
        	if(rst.next())
        	{
        		//用户存在
        		stuPass=rst.getString("stuPass");
        	}
    	}
    	catch(SQLException ex)
    	{
    		ex.printStackTrace();
    	}
    	return stuPass;
    }
    public boolean addStudent(Student student)
    {
    	boolean flag=false;  
    	try
    	{
    		/*String stuNum=new String((student.getStuNum()).getBytes("iso-8859-1"),"gbk");
    		String stuName=new String((student.getStuName()).getBytes("iso-8859-1"),"gbk");
        	String sex=new String((student.getSex()).getBytes("iso-8859-1"),"gbk");
        	String stuCollege=new String((student.getStuCollege()).getBytes("iso-8859-1"),"gbk");
        	String stuClass=new String((student.getStuClass()).getBytes("iso-8859-1"),"gbk");
        	String stuPass=new String((student.getStuPass()).getBytes("iso-8859-1"),"gbk");*/
        	String stuNum=student.getStuNum();
        	String stuName=student.getStuName();
        	String stuCollege=(student.getStuCollege();
    		String sql="insert into student2 values('"+stuNum+"','"+stuName+"','"+sex+"','"+stuCollege+"','"+stuClass+"','"+stuPass+"')";
    		db.executeUpdate(sql);
    		flag=true;
    	}
    	catch(SQLException ex)
    	{
    		ex.printStackTrace();
    	}
    	catch( UnsupportedEncodingException ex)
    	{
    		ex.printStackTrace();
    	}
    	return flag;
    }
}