comboboxframe.java

简单的书店管理系统,是课设期间教师指导完成的,希望会对大家有帮助!

package book;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

import javax.swing.JComboBox;


public class ComboboxFrame extends JComboBox {
	
	ComboboxFrame(String str) throws SQLException {
		MainDAO dao = new MainDAO();
		if (str.equals("读者类别")) {
			String leibie;
			boolean boo = false;
			ResultSet rs = dao.getSelect("select * from duzheleibie");
			while ((boo = rs.next()) == true) {
				leibie=rs.getString("读者类别");
				this.addItem(leibie);
			}
		}
		
		if(str.equals("性别")){
			this.addItem("男");
			this.addItem("女");
		}
		
		
		if(str.equals("出版社")){
			String leibie;
			boolean boo = false;
			ResultSet rs = dao.getSelect("select * from chubanshe");
			while ((boo = rs.next()) == true) {
				leibie=rs.getString("出版社名称");
				this.addItem(leibie);
		    }
	 	
	    }
		
		
		if(str.equals("ISBN")){
			String leibie;
			boolean boo = false;
			ResultSet rs = dao.getSelect("select * from chubanshe");
			while ((boo = rs.next()) == true) {
				leibie=rs.getString("ISBN");
				this.addItem(leibie);
			
		   }
		}
		
		
		if(str.equals("图书类别")){
			String leibie;
			boolean boo = false;
			ResultSet rs = dao.getSelect("select * from tushuleibie");
			while ((boo = rs.next()) == true) {
				leibie=rs.getString("图书类别");
				this.addItem(leibie);
		   }
			
		}
		
	}
	
}