teacher.java

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

package classes;

import java.sql.*;

public class teacher {
  
 int id;
 String name;
 String password;
 String title;
 
 public void setPassword(String s){password = s;}
 public String getPassword(){return password;}
 public void setName(String s){name=s;}
 public String getName(){return name;}
 public void setTitle(String  s){title=s;}
 public String getTitle(){return title;}
 public int  getId(){return id;}	                              

 	public ResultSet getCourse( ){
 	String sql="select course.name "+
          "from classes,course "+
           "where classes.tea_id='"+id+"' "+
          "and course.id=classes.cour_id";
	  sqlBean  sqlbean = new sqlBean();
  	  ResultSet rs = sqlbean.executeQuery(sql);
  	  return rs;
	}
	
	public void addTeacher(){
		
		
		try{//调用oracle存储过程add_tea_func（）;
			Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@210.30.106.105:1521:MyheartY",
				"dbo_classDB","dbo_classDB");

			CallableStatement proc = conn.prepareCall("{ call add_tea_func(?,?,?) }"); 

			proc.setString(1, name);
			proc.setString(2, title);
			proc.setString(3, password); 
			proc.execute();
		}catch(Exception e){e.printStackTrace();}
	}
		                    
	public ResultSet getAll(){
		
		String sql="select * from teacher";
		sqlBean db =new sqlBean();
		ResultSet rs = db.executeQuery(sql);
		return rs;
		}
		
    public  void update()	{
    	
    	String sql= "update teacher set name='"+name+"', "+
    	             "title='"+title+"' ,password='"+password+"' "+
    	             "where id='"+id+"' ";
    	
    	            sqlBean db =new sqlBean();
    	           db.executeInsert(sql); 
    	           
    	}
    	
    	
    public int delete(String id){
    	int num=0;
    	String sql="delete  from teacher_v where id ='"+id+"' ";
    	sqlBean db= new sqlBean();
    	num=db.executeDelete(sql);
    	return num;
    	}			                    
		                    
}