src/com/dao/chongwuDao.java

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

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

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




import com.bean.chongwu;
import com.util.DBO;
import java.util.List;
import java.sql.ResultSet;
public class chongwuDao {
	private DBO db=null;//
	 private chongwu chongwu=null;
	 public void  insert(chongwu chongwu) throws Exception{//添加宠物
			db=new DBO();
		   db.open();
			
			String sql = "insert into chongwu (cwmc,lx,js,nl,tz,yh,fbsj ,tp,zt) values ('"+chongwu.getCwmc()+"','"+chongwu.getLx()+"','"+chongwu.getJs()+"','"+chongwu.getNl()+"','"+chongwu.getTz()+"','"+chongwu.getYh()+"','"+chongwu.getFbsj()+"','"+chongwu.getTp()+"','"+chongwu.getZt()+"')";
		
			
			db.update(sql);
			//db.commit();
			db.close();
		
		}
	 public void  modify(chongwu chongwu) throws Exception{//修改宠物
			db=new DBO();
		   db.open();
			
			String sql = "update chongwu set  cwmc='"+chongwu.getCwmc()+"',lx='"+chongwu.getLx()+"',js='"+chongwu.getJs()+"',nl='"+chongwu.getNl()+"',tz='"+chongwu.getTz()+"',yh='"+chongwu.getYh()+"',fbsj='"+chongwu.getFbsj()+"',tp='"+chongwu.getTp()+"',zt='"+chongwu.getZt()+"'   where cwid ='"+chongwu.getCwid()+"'";
		
			
			db.update(sql);
			//db.commit();
			db.close();
		
		}
	 public void  delete(String keyid) throws Exception{//删除宠物
			db=new DBO();
		        db.open();
			
			String sql = "delete from chongwu where cwid='"+keyid+"'";
		
			
			db.update(sql);
			//db.commit();
			db.close();
		
		}
	 public ResultSet  qlist(String sl) throws Exception{//查询宠物
		   db=new DBO();
		   db.open();
		   String sql="select * from chongwu where  1=1 ";
		if(!sl.equals("")){
			sql+=sl;
			
		}
		   System.out.println("sql="+sql);