src/com/dao/zuoyeDao.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;




import com.bean.zuoye;
import com.util.DBO;
import java.util.List;
import java.sql.ResultSet;
public class zuoyeDao {
	private DBO db=null;//
	 private zuoye zuoye=null;
	 public void  insert(zuoye zuoye) throws Exception{//添加作业
			db=new DBO();
		   db.open();
			
			String sql = "insert into zuoye (zy,zybh,fbsj,nr,fj,kc,fbr,wcsj,bz ) values ('"+zuoye.getZy()+"','"+zuoye.getZybh()+"','"+zuoye.getFbsj()+"','"+zuoye.getNr()+"','"+zuoye.getFj()+"','"+zuoye.getKc()+"','"+zuoye.getFbr()+"','"+zuoye.getWcsj()+"','"+zuoye.getBz()+"')";
		
			
			db.update(sql);
			//db.commit();
			db.close();
		
		}
	 public void  modify(zuoye zuoye) throws Exception{//修改作业
			db=new DBO();
		   db.open();
			
			String sql = "update zuoye set  zy='"+zuoye.getZy()+"',zybh='"+zuoye.getZybh()+"',fbsj='"+zuoye.getFbsj()+"',nr='"+zuoye.getNr()+"',fj='"+zuoye.getFj()+"',kc='"+zuoye.getKc()+"',fbr='"+zuoye.getFbr()+"',wcsj='"+zuoye.getWcsj()+"',bz='"+zuoye.getBz()+"' where zyid ='"+zuoye.getZyid()+"'";
		
			
			db.update(sql);
			//db.commit();
			db.close();
		
		}
	 public void  delete(String keyid) throws Exception{//删除作业
			db=new DBO();
		        db.open();
			
			String sql = "delete from zuoye where zyid='"+keyid+"'";
		
			
			db.update(sql);
			//db.commit();
			db.close();
		
		}
	 public ResultSet  qlist(String sl) throws Exception{//查询作业
		   db=new DBO();
		   db.open();
		   String sql="select * from zuoye where  1=1 ";
		if(!sl.equals("")){
			sql+=sl;
			
		}
		   System.out.println("sql="+sql);