JAVA JDBC的增删改查 CRUD

这个是查询所有

@Override
	public ArrayList<user> getArrayList(String name,String state1,String flag,int page,int num) {
		// TODO Auto-generated method stub
		
		 //查看所有
		  ArrayList<user> arr=new ArrayList<user>();
		    conn=DBManager.getConnection();
		    try {
				String sql="select top("+num+")* from yonghu where id not in(select top("+(page-1)*num+")id from yonghu) and name like '%"+name+"%' and shenfen like '会员' and yonghuzhuangtai like '%"+state1+"%'";
				state=conn.createStatement();
				set=state.executeQuery(sql);
				while (set.next()) {
					int id1=set.getInt("id");
					String name1=set.getString("name");
					String pass=set.getString("pass");
					String shiyongzhuangtai=set.getString("yonghuzhuangtai");
					String shenfen1=set.getString("shenfen");
					user asd=new user(id1, name1, pass, shiyongzhuangtai, shenfen1);
					arr.add(asd);
				}
			} catch (Exception e) {
				// TODO: handle exception
			}
			return arr;
	}

这个是删除

@Override
	public int getuser(int id) {
		// TODO Auto-generated method stub
		//根据ID删除
		user asd=new user();
	    conn=DBManager.getConnection();
	    int i=0;
	    try {
			String sql="delete  yonghu where id="+id;
			state=conn.createStatement();
			i=state.executeUpdate(sql);
			
		} catch (Exception e) {
			// TODO: handle exception
		}
		return i;
	}

这个是添加

@Override
	public int getuserrr(String name, String pass, String yonghuzhuangtai,
			String shenfen) {
		// TODO Auto-generated method stub
		
		
		user asd=new user();
	    conn=DBManager.getConnection();
	    int i=0;
	    try {
			String sql="insert into yonghu(name,pass,yonghuzhuangtai,shenfen) values('"+name+"','"+pass+"','"+yonghuzhuangtai+"','"+shenfen+"')";
			state=conn.createStatement();
			i=state.executeUpdate(sql);
		
	    } catch (Exception e) {
			// TODO: handle exception
		}
	    return i;
	}

这个是修改

@Override
	public int getuiss(int id, String name, String pass,
			String yonghuzhuangtai, String shenfen) {
		// TODO Auto-generated method stub
		
		
		
		user asd=new user();
	    conn=DBManager.getConnection();
	    int a=0;
	    try {
			String sql="update yonghu set name='"+name+"',pass='"+pass+"',yonghuzhuangtai='"+yonghuzhuangtai+"',shenfen='"+shenfen+"' where id="+id+"";
			state=conn.createStatement();
			a=state.executeUpdate(sql);
			
			
		} catch (Exception e) {
			// TODO: handle exception
		}
		return a;
	}

当然了 这里面还有一个工具类一会我就发出来
https://blog.csdn.net/qq_44758351/article/details/104194998