display.java

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

package tom.bean;
import java.sql.*;
import java.util.*;
import tom.bean.Dbconnection;
public class Display{
	private String searchbook;
    private String key;
    private String title;
    private String condition;
    private String message;
private int rowcount;
    private ResultSet rs;
    public Display() {
    	searchbook=null;
    	key=null;
    }
    public void setSearchbook(String s)
    {
    	searchbook=s;
    }
    public String getSearchbook()
    {
    	return searchbook;
    }
    public void setKey(String s)
    {
    	key=s;
    }
    public String getKey()
    {
    	return key;
    }
    public void setTitle(String s)
    {
    	title=s;
    }
    public String getMessage()
    {
    	return message;
    }
    public int getRowcount()
    {
    	return rowcount;
    }
    public String getTitle()
    {
    	if(searchbook.equals("specialityid"))
    		condition="select specialityname from speciality where specialityid="+Integer.valueOf(key);
    	if(searchbook.equals("gradeid"))
    		condition="select grade from grade where gradeid="+Integer.valueOf(key);
    	if(searchbook.equals("courseid"))
    	    condition="select coursename from course where courseid="+Integer.valueOf(key);
    	Dbconnection e=new Dbconnection();
        e.condb();
        rs=e.select(condition);
    	try{if(rs.next())    
    		title=rs.getString(1);
    		else
    		title="";
    		}
    	catch(SQLException f){System.out.print("获得查询分类名称出错");}
    	return title;		
    }
    public ResultSet getRst()
    {
    	condition="SELECT bookid,bookname,booktype.booktype,author,bookconcern,bookdate,leavingbook FROM book,booktype where bookid in(select bookid from course where "+searchbook+"="+Integer.valueOf(key)+")"+"and book.booktypeid=booktype.booktypeid";
        Dbconnection e=new Dbconnection();
        e.condb();
        rs=e.select(condition);
        rowcount=e.getRowcount();
    	return rs;
    }
    
}