advancebook.java

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

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

public class Advancebook{
	private int specialityid;
	private String specialityname;
	private int classid;
	private String classname;
	private String quantity;
	private String condition;
	private int gradeid;
	private String grade;
	private String bookid;
	private String message;
	private int number;
	private String nowtime;
	ResultSet rs; 
    public Advancebook() {
    	classname=null;
    	message=null;
    }
    //
    public void setSpecialityid(int n)
    {
    	specialityid=n;
    }
    public int getSpecialityid()
    {
    	return specialityid;
    }
    //
    public void setClassid(int n)
    {
    	classid=n;
    }
    public int getClassid()
    {
    	return classid;
    }
    //
    public void setSpecialityname(String s)
    {
    	specialityname=s;
    }
    public String getSpecialityname()
    {
    	return specialityname;
    }
    //
    public void setClassname(String s)
    {
    	classname=s;
    }
    public String getClassname()
    {
    	return classname;
    }
    //
    public void setGrade(String s)
    {
    	grade=s;
    }
    public String getGrade()
    {
    	return grade;
    }
    //
    public void setGradeid(int n)
    {
    	gradeid=n;
    }
    public int getGradeid()
    {
    	return gradeid;
    }
    //
    public void setMessage(String s)
    {
    	message=s;
    }
    public String getMessage()
    {
    	return message;
    }
    //
    public void setNumber(int n)
    {
    	number=n;
    }
    public int getNumber()
    {
    	return number;
    }
    //
    public void setBookid(String s)
    {
    	bookid=s;
    }
    public String getBookid()
    {
    	return bookid;
    }
    //
    public void setQuantity(String s)
    {
    	quantity=s;
    }
    public String getQuantity()
    {
    	return quantity;
    }
    //
    public String getNowtime()
    {
    	nowtime=(new java.util.Date()).toLocaleString();
    	return nowtime;
    }
    //
    public void check()
    {condition="select class.specialityid,specialityname,classid,class.gradeid,grade from grade,class,speciality where class.gradeid=grade.gradeid and speciality.specialityid=class.specialityid and classname='"+classname+"'";
     setMessage("null");
     Dbconnection e=new Dbconnection();
      e.condb();
     rs=e.select(condition);
     try{
     	  if(rs.next())
         {specialityid=rs.getInt(1);
         specialityname=rs.getString(2);
	     classid=rs.getInt(3);
	     gradeid=rs.getInt(4);
	     grade=rs.getString(5);
         }
         else
         	message="error";
     }
     catch(SQLException f){System.out.print(f);}
    }
    //查询课程和所对应的教材
    public ResultSet booklist()
    {
    	condition="select courseid,coursename,bookname,course.bookid from course,book where course.bookid=book.bookid and gradeid="+gradeid+"and specialityid="+specialityid+"order by courseid";
        Dbconnection e=new Dbconnection();
        e.condb();
        rs=e.select(condition);
        return rs;
    }
    //教材预订信息入库
    public void addadvance()
    {   condition="insert into serveround(classid,bookid,quantity,advancetime)values("+Integer.valueOf(classid)+","+Integer.valueOf(bookid)+","+number+",'"+getNowtime()+"')";
        Dbconnection e=new Dbconnection();
        e.condb();
        e.update(condition);
    }
    //检测是否已经提交订单
    public void checkadvance()
    {
    	condition="select * from serveround where classid="+Integer.valueOf(classid)+"and bookid="+Integer.valueOf(bookid);
        setMessage("null");
        Dbconnection e=new Dbconnection();
        e.condb();
        rs=e.select(condition);
        try{if(rs.next())
        	setMessage("ERROR");
        else
        	addadvance();}
        	catch(SQLException f){System.err.println("Advancebook.checkadvance():"+f.getMessage());}
        
    }
    //查询订单
    public ResultSet demandadvance()
    {
    	condition="select book.bookid,bookname,leavingbook,quantity from book,serveround where flag=0 and classid="+Integer.valueOf(classid)+"and book.bookid=serveround.bookid"; 
        Dbconnection e=new Dbconnection();
        e.condb();
        rs=e.select(condition);
        return rs;
    }
    //
    public void output()
    {
    	condition="update book set leavingbook=leavingbook-"+Integer.valueOf(quantity)+"where bookid="+Integer.valueOf(bookid);
    	Dbconnection e=new Dbconnection();
        e.condb();
    	e.update(condition);
    	message=e.getMessage();
    	if(message==null)
    	{condition="update serveround set flag=1,managetime='"+getNowtime()+"' where classid="+Integer.valueOf(classid)+"and bookid="+Integer.valueOf(bookid);
    	 e.update(condition);
    	}
    }
    public static void main (String []args)
    {
      Advancebook e=new Advancebook();
      e.setClassid(5);
      e.setBookid("27");
      e.setQuantity("3");
      e.output();
      //e.check();
      //System.out.print(e.getMessage());
      //System.out.print(e.getSpecialityid());
      //System.out.print(e.getSpecialityname());
      //System.out.print(e.getClassname());
      //System.out.print(e.getGradeid());
    }
}