logic.java

这是一个班级 教师 学生 课程管理的软件实现对学生教师课程的添加修改删除查询

	 * @return 更新成功 true
	 */
	public boolean updateClassInfo(String cid,String cdate,String cname,String csum,String ctname,String cstatus,String cbz){
		boolean upok=false;
		if(csum.length()==0){
			csum="0";
		}
		if(cname.length()<=0||cname.length()>20){
			JOptionPane.showMessageDialog(null, "班级名称称非法!请检查你的输入!");
			
		}
		else if(cname.length()>0&&(cdate.length()>=9&&cdate.length()<=13)){
			String sqls="update classt set cdate='"+cdate+"',cname='"+cname+"',csum='"+csum+"',ctname='"+ctname+"',cstatus='"+cstatus+"',cbz='"+cbz+"' where cid="+cid;
			if(db.executeSqls(sqls)==true){
				JOptionPane.showMessageDialog(null, "修改"+cname+"班级成功!");
				upok=true;
			}else{
				JOptionPane.showMessageDialog(null, "修改"+cname+"班级失败");
			}
		}
		
		return upok;
	}
	
	/**
	 * 返回要加入的班级编号
	 * @return
	 */
	public int getClassid(){
		return db.howMuchline("classt", "cid");
	}
	
	
	/**
	 * 实现对专业的判断及添加
	 * @param zyid 专业编号
	 * @param zyname 专业名称
	 * @param zyms 专业描述
	 * @param zybz 专业备注
	 * @return boolean true 添加成功
	 */
	public boolean addZhuanye(String zyid,String zyname,String zyms,String zybz){
		boolean addokzy=false;
		if(zybz.length()==0){
			zybz="";
		}
		if(zyms.length()==0){
			zyms="";
		}
		if(zyname.length()>0&&zyname.length()<20){
			String sqls="insert into zhuanyet values("+zyid+",'"+zyname+"','"+zyms+"','"+zybz+"')";
			boolean exeok=db.executeSqls(sqls);
			if(exeok==true){
			JOptionPane.showMessageDialog(null, "添加"+zyname+"专业成功");
			addokzy=true;
			}
		}else{
			JOptionPane.showMessageDialog(null, "你输入的专业名不合法!");
		}
		return addokzy;
	}
	
	/**
	 * 更新专业方法
	 * @param zyid 专业编号 
	 * @param zyname 专业名
	 * @param zyms 专业描述
	 * @param zybz 专业备注
	 * @return 成功 true
	 */
	public boolean updateZhuanye(String zyid,String zyname,String zyms,String zybz){
		boolean upok=false;
		if(zyname.length()>0){
			String sqls="update zhuanyet set zyname='"+zyname+"',zyms='"+zyms+"',zybz='"+zybz+"' where zyid="+zyid;
			if(db.executeSqls(sqls)==true){
				upok=true;
				JOptionPane.showMessageDialog(null, "更新"+zyname+"专业成功!");
			}else{
				JOptionPane.showMessageDialog(null, "更新"+zyname+"专业失败!");
			}
		}
		return upok;
	}
	
	
	
//	/**
//	 * 根据专业id删除专业
//	 * @param 专业id
//	 * @return 删除成功返回true
//	 */
//	public boolean delZhuanye(String zyid){
//		boolean delok=false;
//		String sqls="delete from zhuanyet where zyid="+zyid;
//		boolean exeok=db.executeSqls(sqls);
//		if(exeok==true){
//			delok=true;
//			JOptionPane.showMessageDialog(null, "删除专业成功");
//		}else{
//			JOptionPane.showMessageDialog(null, "删除专业失败");
//		}
//		return delok;
//	}
//	
	
	
	/**
	 * 根据表名 列名 列值删除数据
	 * 
	 */
	public boolean delInfobyID(String tablename,String columnname,String values){
		boolean delok=false;
		String sqls="delete from "+tablename+" where "+columnname+"="+values;		
		if(db.executeSqls(sqls)==true){
			delok=true;
			JOptionPane.showMessageDialog(null, "删除成功");
		}else{
			JOptionPane.showMessageDialog(null, "删除失败");
		}
		return delok;
		
	}	

	
	/**
	 * 班级查询 并返回结果 根据
	 * @param cnames 是否要用班名查询 boolean
	 * @param cstatuss 是否要用班级状态查询 boolean
	 * @param bossnames 是否要用班主任名查询 boolean
	 * @param cname 要查的班名
	 * @param cstatus 要查的班级状态
	 * @param bossname 要查的班主任名字
	 * @return 查到的信息 Vector
	 */
	public Vector searchClassResult(boolean cnames,boolean cstatuss,boolean bossnames,String cname,String cstatus,String bossname){
		Vector result=new Vector();
		String sqls="select cdate,cname,csum,ctname,cstatus,cbz from classt ";
		if(cnames==true){
			sqls=sqls+" where cname like '%"+cname+"%'";
			if(cstatuss==true){
				sqls=sqls+" and cstatus like '%"+cstatus+"%'";
			}
			if(bossnames==true){
				sqls=sqls+" and ctname like '%"+bossname+"%'";
			}
		}else{
			if(cstatuss==true){
				sqls=sqls+" where cstatus like '%"+cstatus+"%'";
				if(bossnames==true){
					sqls=sqls+" and ctname like '%"+bossname+"%'";
				}
			}else{
				if(bossnames==true){
					sqls=sqls+" where ctname like '%"+bossname+"%'";
				}
			}
		}
		result=db.selectDB(sqls);
		return result;
		
	}
	
	
	/**
	 * 
	 * @param 专业是否被选中作为查询项
	 * @param 专业描述查询项是否被选中
	 * @param 得到专业名内容
	 * @param 得到专业描述内容
	 * @return 返回查询到的结果
	 */
	public Vector searchResult(boolean nameu,boolean msu,String zyname,String zyms){
		Vector result=new Vector();
		String sqls="select zyname,zyms,zybz from zhuanyet ";
		if(nameu==true){
			sqls=sqls+" where zyname like'%"+zyname+"%'";
			if(msu==true){
				sqls=sqls+" and zyms like'%"+zyms+"%";
			}
		}else{
			if(msu=true){
				sqls=sqls+" where zyms like'%"+zyms+"%'";
			}
		}
		result=db.selectDB(sqls);
		return result;
	}
	
	
	/**
	 * 传入表名与列名 得到列内容 返回字符串数组
	 * @param tableNames 表名
	 * @param columnNames 列名
	 * @return 字符串数组
	 */
		public String[] getName(String tableNames,String columnNames){
		Vector vnames=new Vector();
		vnames=db.selectDB("select "+columnNames+" from "+tableNames);
		String[] anames=new String[vnames.size()];
		for(int i=0;i<vnames.size();i++){
			anames[i]=((Vector)(vnames.get(i))).get(0).toString();			
		}
		return anames;		
	}
		
	
		
		
		
	/**
	 * 查询学生信息 模糊查询
	 * @param cbsname boolean 姓名是否被选中作为查询项
	 * @param cbssex boolean 性别
	 * @param cbsages boolean 年龄
	 * @param cbsinyear boolean 入学日期
	 * @param cbszy boolean 专业
	 * @param cbsclass boolean 班级
	 * @param cbsstatus boolean 状态
	 * @param sname String 要查的学生名字
	 * @param ssex boolean 性别是不是男
	 * @param sage String 年龄
	 * @param sinyear String 入学年份
	 * @param szy String 专业
	 * @param sclass String 班级
	 * @param status String 状态
	 * @return 容器
	 */
	public Vector searchStudentResult(boolean cbsname,boolean cbssex,boolean cbsages,boolean cbsinyear,boolean cbszy,boolean cbsclass,boolean cbsstatus,String sname,boolean ssex,String sage,String sinyear,String szy,String sclass,String status){
		Vector vst=new Vector();
		String sqls="select sname,ssex,sage,sindate,szy,sclass,ssfid,sstatus from studentt ";
		if(cbsname==true){
			sqls=sqls+" where sname like'%"+sname+"%'";
			if(cbssex==true){
				String sx="男";
				if(ssex==false){
					sx="女";					
				}
				sqls=sqls+" and ssex='"+sx+"'";				
			}
			if(cbsages==true&&sage.length()>0){
				sqls=sqls+" and sage ="+sage;
			}
			if(cbsinyear==true){
				sqls=sqls+" and sindate like'%"+sinyear+"%'";
			}
			if(cbszy==true){
				sqls=sqls+" and szy like '%"+szy+"%'";
			}
			if(cbsclass==true){
				sqls=sqls+" and sclass like '%"+sclass+"%'";
			}
			if(cbsstatus==true){
				sqls=sqls+" and sstatus='"+status+"'";
			}
		}else{
			if(cbssex==true){
				String sx="男";
				if(ssex==false){
					sx="女";					
				}
				sqls=sqls+" where ssex='"+sx+"'";
				if(cbsages==true&&sage.length()>0){
					sqls=sqls+" and sage ="+sage;
				}
				if(cbsinyear==true){
					sqls=sqls+" and sindate like'%"+sinyear+"%'";
				}
				if(cbszy==true){
					sqls=sqls+" and szy like '%"+szy+"%'";
				}
				if(cbsclass==true){
					sqls=sqls+" and sclass like '%"+sclass+"%'";
				}
				if(cbsstatus==true){
					sqls=sqls+" and sstatus='"+status+"'";
				}
			}else{
				if(cbsages==true&&sage.length()>0){
					sqls=sqls+" where sage ="+sage;
					if(cbsinyear==true){
						sqls=sqls+" and sindate like'%"+sinyear+"%'";
					}
					if(cbszy==true){
						sqls=sqls+" and szy like '%"+szy+"%'";
					}
					if(cbsclass==true){
						sqls=sqls+" and sclass like '%"+sclass+"%'";
					}
					if(cbsstatus==true){
						sqls=sqls+" and sstatus='"+status+"'";
					}	
				}else if(cbsages==false){
					if(cbsinyear==true){
						sqls=sqls+" where sindate like'%"+sinyear+"%'";
						if(cbszy==true){
							sqls=sqls+" and szy like '%"+szy+"%'";
							if(cbsclass==true){
								sqls=sqls+" and sclass like '%"+sclass+"%'";
							}
							if(cbsstatus==true){
								sqls=sqls+" and sstatus='"+status+"'";
							}
						}
	
					}else{
						if(cbszy==true){
							sqls=sqls+" where szy like '%"+szy+"%'";
							if(cbsclass==true){
								sqls=sqls+" and sclass like '%"+sclass+"%'";
							}
							if(cbsstatus==true){
								sqls=sqls+" and sstatus='"+status+"'";
							}
						}else{
							if(cbsclass==true){
								sqls=sqls+" where sclass like '%"+sclass+"%'";
								if(cbsstatus==true){
									sqls=sqls+" and sstatus='"+status+"'";
								}
							}else{
								if(cbsstatus==true){
									sqls=sqls+" where sstatus='"+status+"'";
								}
							}

						}
					}
					
				}else if(sage.length()==0){
					JOptionPane.showMessageDialog(null, "你输入的年龄非法了");
				}
			
			}	
			
		}		
		vst=db.selectDB(sqls);
		return vst;
		
	}
		
		
		
	
	/**
	 * 查询教师返回查询的结果
	 * @param tnames
	 * @param tsexes
	 * @param tages
	 * @param tinworkths
	 * @param tstatuss
	 * @param tname
	 * @param tsexe
	 * @param tage
	 * @param tinworkth
	 * @param tstatus
	 * @return Vector
	 */
	public Vector searchResultteacher(boolean tnames,boolean tsexes,boolean tages,boolean tinworkths,boolean tstatuss,String tname,boolean tsexe,String tage,String tinworkth,String tstatus){
		Vector resultt=new Vector();
		String sqls=" select tname,tsex,tage,tinwork,tsfid,taddre,tphone,tstatus from teachert ";
		if(tnames==true){
			sqls=sqls+" where tname like'%"+tname+"%'";			
			if(tsexes==true){	
				String str="男";
				if(tsexe==false){
					str="女";
				}
				sqls=sqls+" and tsex='"+str+"'";			
			}//end if sex
			if(tages==true){
				sqls=sqls+" and tage="+tage;			
			}
			if(tinworkths==true){
				sqls=sqls+" and tinwork like'%"+tinworkth+"%'";
			}
			if(tstatuss==true){
				sqls=sqls+" and tstatus like'"+tstatus+"'";
			}
			
		}else{
			if(tsexes==true){	
				String str="男";
				if(tsexe==false){
					str="女";
				}
				sqls=sqls+" where tsex='"+str+"'";
				if(tages==true){
					sqls=sqls+" and tage="+tage;			
				}
				if(tinworkths==true){
					sqls=sqls+" and tinwork like'%"+tinworkth+"%'";
				}
				if(tstatuss==true){
					sqls=sqls+" and tstatus like'"+tstatus+"'";
				}
			}else{
				if(tages==true){
					sqls=sqls+" where tage="+tage;	
					if(tinworkths==true){
						sqls=sqls+" and tinwork like'%"+tinworkth+"%'";
					}
					if(tstatuss==true){
						sqls=sqls+" and tstatus like'"+tstatus+"'";
					}
				}else{
					if(tinworkths==true){
						sqls=sqls+" where tinwork like'%"+tinworkth+"%'";
						if(tstatuss==true){
							sqls=sqls+" and tstatus like'"+tstatus+"'";
						}
					}else{
						if(tstatuss==true){
							sqls=sqls+" where tstatus like'"+tstatus+"'";
						}						
					}	
					
				}			
				
			}
			
		}//end elsename	
		resultt=db.selectDB(sqls);
		return resultt;
	}
	
	
	public Vector serachResultStudent(){
		Vector result=new Vector();
		
		return result;
	}
	
	/**
	 * 断开数据库方法
	 *
	 */
	public void closeDB(){
		if(db.closeDB()==true){
			JOptionPane.showMessageDialog(null, "断开数据库成功你现在不能对数据库进行操作了");
		}else{
			JOptionPane.showMessageDialog(null, "断开数据库失败");
		}
	}
	
	/**
	 * 调用连接数据库方法判断传入参数是否正确 logic中
	 * @param hostName 主机名
	 * @param portsNum 端口号
	 * @param uname 数据库用户名
	 * @param upwd 数据库用户密码
	 * @return 连接成功返回true 
	 */
	public boolean connectDB(String hostName,String portsNum,String uname,String upwd){
		boolean conok=false;
		if(hostName.length()==0){
			hostName="localhost";
		}
		if(uname.length()==0){
			uname="sa";
		}
		if(upwd.length()==0){
			upwd="";
		}
		if(db.connectDB(hostName, portsNum, uname, upwd)==true){
			conok=true;
			JOptionPane.showMessageDialog(null, "数据库连接成功!现在可以对数据库进行操作了");			
		}else{
			JOptionPane.showMessageDialog(null, "数据库连接失败!你现在不能对数据库进行操作!");
		}
		return conok;
	}  		


}//end class logic