student.java

学生课程和成绩的管理系统

package classes;

import java.sql.*;
public class student {
  private String name;
  private String password;
  private double id;
  private String jiguan;
  private String sex;
  private String dep;
  
  public void setDep(String s){dep=s;}
  public String getDep(){return dep;}
  public void setSex(String s){sex=s;}
  public String getSex(){return sex;}	                                                                    
  public double getId() {
    return id;
  }
 
  public String getName() {
    return name;
  }
  public void setName(String name) {
    this.name = name;
  }
  public String getPassword() {
    return password;
  }
  public void setPassword(String password) {
    this.password = password;
  }

  public String getJiguan() {
    return jiguan;
  }
  public void setJiguan(String jiguan) {
    this.jiguan = jiguan;
  } 	                       
  public ResultSet  getStudent(){
		String sql="select * from student   ";
		sqlBean db= new sqlBean();
		ResultSet rs = db.executeQuery(sql);
		 return rs;
		                         } 
		                         
		                         
  public void updateStudent(){
    	
      String sql="update student "+
                 " set name='"+name+"',sex='"+sex+"',department='"+dep+"',	 "+
                 "password='"+password+"',jiguan='"+jiguan+"'  "+
                 " where id='"+id+"' ";
                 sqlBean db= new sqlBean();
                 db.executeInsert(sql);
                 
    	}	    
  			                         		                                                 	                       	                       
  public void deleteStudent(){
    
    	String sql="delete  from student_v where id ='"+id+"' ";
    	sqlBean db= new sqlBean();
    	db.executeDelete(sql);
    	}                       
  	       
  public int deleteStudent(String id){
    	int num=0;
    	String sql="delete  from student where id ='"+id+"' ";
    	sqlBean db= new sqlBean();
    	num=db.executeDelete(sql);
    	return num;
    	}                        	                       
  public void addStudent()  {
    String sql="insert into student(name,password,id,sex,department,jiguan)  "+	
            "VALUES('"+name+"','"+password+"',"+"stu_id_seq.nextval"+",'"+sex+"','"+dep+"','"+jiguan+"')";
            sqlBean db =new sqlBean();
          
               db.executeInsert(sql);
        }
                           
                         	
}