apc.java

采用基于B/S结构进行开发学生管理信息系统,本系统采用Servlet+Jsp+JavaBean+MySQL 的设计方式

package myBean;
import java.sql.*;
import myBeans.SQLBean;

public class APC {

  private String code;
  private String description;

  public String getCode() {
    return code;
  }
  public void setCode(String code) {
    this.code = code;
  }
  public String getDescription() {
    return description;
  }
  public void setDescription(String description) {
    this.description = description;
  }
  
  public String findTable(String code){
    if(code.startsWith("A"))
       return "award_levels";
    else if(code.startsWith("P"))
       return "punish_levels";
    else
       return "change_code";
  }
  
  public ResultSet getAPC(String s){
    String table = "";
    if(s.equals("A")){
    	table = "award_levels";
    }else if(s.equals("P")){
    	table = "punish_levels";
    }else{
      table = "change_code";
    }
  	String sql="select CODE,DESCRIPTION from "+table;
  	SQLBean db = new SQLBean();
  	ResultSet rs = db.executeQuery(sql);
  	return rs;
  }
                              
  public boolean hasLogin(String code,String description){   
  	boolean f=false;
  	String table = findTable(code);
    String sql="select * from "+table+" where CODE ='"+code+"' or DESCRIPTION='"+description+"'";
  	SQLBean db =new SQLBean();
  	try{
  	ResultSet rs=db.executeQuery(sql);
  	if(rs.next()){ f=true;}
  	else{ f=false;}
  	}catch(Exception e){ e.getMessage();}
  	return f;
  }
  	                                                                            	                   	                  
  public void addAPC(){
  	String table = findTable(code);
  	String sql="insert into "+table+"(CODE,DESCRIPTION)  "+
  	           "values ('"+code+"','"+description+"') ";
  	    try{       
  		    SQLBean db =new SQLBean(); 
  		    db.executeInsert(sql);
  		   } catch(Exception e){System.out.print(e.toString());}
  		}
  		
  		
   public void updateAPC(String code,String description){ 
   	String table = findTable(code);   	
      String sql="update "+table+
                 "  set DESCRIPTION='"+description+"'"+
                 " where CODE='"+code+"'";
                 SQLBean db= new SQLBean();
                 db.executeInsert(sql);
   }
                 
   public int deleteAPC(String code){  
        int num=0; 	
        String table = findTable(code);
    	  String sql="delete  from "+table+" where CODE ='"+code+"'";
    	  SQLBean db= new SQLBean();
        num=db.executeDelete(sql);
        return num;
   }
    
}