Swing界面 ：菜单界面的删除，修改，和查询和退出(JDBC)

1.建项目 建Dao entity frame test util包(以下为效果图)

 

2.从Dao包开始（先写接口，在写个类实现）

接口：

public interface CdImpl {
   //查询所有
    public List<cd> SelectAll(String cname);
   //id查询
    public cd selectcid(int cid);
    //修改
    public int update(cd c);
    //删除
    public int delete(int cid);
}

接口实现类：

 

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.util.ArrayList;

import java.util.List;

 

import com.entity.cd;

import com.util.DBUtil;

 

public class CdDao implements CdImpl{

 

         @Override

         public List<cd> SelectAll(String cname) {

         List<cd> list = new ArrayList<cd>();

         Connection conn = DBUtil.getConnection();

         String sql="";

         try {

                  if(cname !=null){

                          sql ="select * from cd where cname like '%" + cname + "%'";

                  }else{

                          sql="select * from cd";

                  }

                  PreparedStatement ps = conn.prepareStatement(sql);

                  ResultSet rs = ps.executeQuery();

                  while(rs.next()){

                          cd c = new cd();

                          c.setCid(rs.getInt("cid"));

                          c.setCname(rs.getString("cname"));

                          c.setCmoney(rs.getString("cmoney"));

                          c.setCtotal(rs.getString("ctotal"));

                          list.add(c);

                  }

         } catch (Exception e) {

                  // TODO: handle exception

         }

        

                  return list;

         }

 

         @Override

         public cd selectcid(int cid) {

                  //select *from cd where cid = 2;

                  cd c = new cd();

                  Connection conn = DBUtil.getConnection();

                  String sql="select * from cd where cid = ?";

                  try {

                          PreparedStatement ps = conn.prepareStatement(sql);

                          ps.setInt(1, cid);

                          ResultSet rs= ps.executeQuery();

                          while(rs.next()){

                                   c.setCid(rs.getInt("cid"));

                                   c.setCname(rs.getString("cname"));

                                   c.setCmoney(rs.getString("cmoney"));

                                   c.setCtotal(rs.getString("ctotal"));

                          }

                  } catch (Exception e) {

                          // TODO: handle exception

                  }

        

                  return c;

         }

 

         @Override

         public int update(cd c) {

                  // 刷新

                  Connection conn = DBUtil.getConnection();

                  String sql=