course.java

教材管理系统,一个完整的学校教材管理系统,可以作为大学生课程设计使用

package tom.bean;
import java.sql.*;
import java.util.*;
import tom.bean.Dbconnection;

public class Course {
    private int courseid;
	 private String coursename;
	 private int bookid;
	 private int gradeid;
	 private int specialityid;
	 private String action;
	 private String condition;
     private ResultSet rs;
     private int rowcount;
     private String message;
     private int id;
    public Course() {
    	courseid=0;
     	coursename=null;
     	bookid=0;
     	specialityid=0;
     	gradeid=0;
     	message=null;
    }
    public void setAction(String s)
    {
    	action=s;
    }
    //
    public void setCourseid(int n)
    {
    	courseid=n;
    }
    public int getCourseid()
    {
    	return courseid;
    }
    //
    public void setCoursename(String s)
    {
    	coursename=s;
    }
    public String getCoursename()
    {
    	return coursename;
    }
    //
    public void setBookid(int n)
    {
    	bookid=n;
    }
    public int getBookid()
    {
    	return bookid;
    }
    //
    public void setSpecialityid(int n)
    {
    	specialityid=n;
    }
    public int getSpecialityid()
    {
    	return specialityid;
    }
    //
    public void setGradeid(int n)
    {
    	gradeid=n;
    }
    public int getGradeid()
    {
    	return gradeid;
    }
    //
    public void setId(int n)
    {
    	id=n;
    }
    public int getId()
    {
    	return id;
    }
    public String getMessage()
    {
    	return message;
    }
    //
    public int getRowcount()
    {
    	return rowcount;
    }
    //
    public ResultSet courselist()
    {
    	condition="SELECT courseid,coursename,book.bookname,speciality.specialityname,grade.grade from course,grade,speciality,book where course.gradeid=grade.gradeid and course.specialityid=speciality.specialityid and course.bookid=book.bookid order by courseid";
    	Dbconnection e=new Dbconnection();
        e.condb();
    	rs=e.select(condition);
    	rowcount=e.getRowcount();
        message=e.getMessage();
    	return rs;
    }
    //
    public void selectspec()
    {
    	condition="SELECT * from course where courseid="+courseid;
    	Dbconnection e=new Dbconnection();
        e.condb();
    	rs=e.select(condition);
    	try{
    		rs.next();
    		courseid=rs.getInt(1);
    		coursename=rs.getString(2);
    		bookid=rs.getInt(3);
    		specialityid=rs.getInt(4);
    		gradeid=rs.getInt(5);
    	}
    	catch(SQLException f){message="error";}
    }
    public void ManageCourse()
    {
    	if(action.equals("add"))
    	condition="INSERT INTO course VALUES"+"("+courseid+","+"'"+coursename+"',"+bookid+","+specialityid+","+gradeid+")";
        if(action.equals("edit"))
        condition="update course set courseid="+courseid+",coursename='"+coursename+"',bookid="+bookid+",specialityid="+specialityid+",gradeid="+gradeid+" where courseid="+id;
        if(action.equals("delete"))
        condition="DELETE FROM course WHERE courseid="+courseid; 
        Dbconnection e=new Dbconnection();	
        e.condb();
    	e.update(condition);
        message=e.getMessage();
    	  	
    }
    
}