show.java

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

package tom.bean;
import java.sql.*;
import java.util.*;
import tom.bean.Dbconnection;
public class Show{
private String searchbook;
private String key;
private String select;
private String condition;
private String message;
private int rowcount;
ResultSet rs;
    public Show() {
    	searchbook="bookname";
    	key="";
    	select="unexact";
    	condition="";
    }
    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 setSelect(String s)
    {
    	select=s;
    }
    public String getSelect()
    {
    	return select;
    }
    public String getMessage()
    {
    	return message;
    }
    public int getRowcount()
    {
    	return rowcount;
    }
    public ResultSet getRst()
    {
    	if(select.equals("unexact"))
		condition="SELECT bookid,bookname,booktype.booktype,author,bookconcern,bookdate,leavingbook FROM book,booktype where "+searchbook+" like'%"+key+"%'and book.booktypeid=booktype.booktypeid";
		else
	    condition="SELECT bookid,bookname,booktype.booktype,author,bookconcern,bookdate,leavingbook FROM book,booktype where "+searchbook+"='"+key+"'and book.booktypeid=booktype.booktypeid";
        Dbconnection e=new Dbconnection();
        e.condb();
        rs=e.select(condition);
        rowcount=e.getRowcount();
    	return rs;	
    }
}