通过反射实现一张表的删除

{
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	private static Connection getConnection(){
		try {
			Connection conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","C##admin","123456");
			return conn;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return null;
	}
	private static void close(){
		if(getConnection()!=null){
			try {
				getConnection().close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}

public static 
 
   String getNoneDeleteSql(Class
  
    c){ StringBuffer sb=new StringBuffer(); sb.append("delete from "); sb.append(c.getSimpleName()); sb.append(" where id=?"); return sb.toString(); }
  
 

public static 
 
   int deleteAllFactory(T t){
		Class c=t.getClass();
		String sql=getNoneDeleteSql(c);
		try {
			PreparedStatement pstt=getConnection().prepareStatement(sql);
			for(Method me : c.getDeclaredMethods()){
				if(me.getName().equalsIgnoreCase("getid")){
					pstt.setObject(1, me.invoke(t, null));
					return pstt.executeUpdate();
				}
			}
		} catch (SecurityException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (IllegalAccessException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (IllegalArgumentException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (InvocationTargetException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return 0;
	}


    public static void test(Users users){
    if( deleteAllFactory(users)>0){
        System.out.println("成功");
    }else{
        System.out.println("失败");
    }
}